C# reportviewer datetimeparameters?

Question

0.00/5 (No votes)

See more:

I have one table called DailyReport which has a column DateInput(date when data has been written in the DailyReport table). Each day data is written in, and I am in need of having a report generated by dates, so I have placed two datetimepicker controls on my report but I can't get the code to help me open report by desired dates checked by those datetimepicker controls.
Any help with the code? I have checked the articles here and Google, but I am still in a jam.
Thanks!

Posted 30-Jan-11 19:42pm

shonezi

Updated 30-Jan-11 20:56pm

Deeksha Shenoy

v2

Add a Solution

Comments

Abhinav S 31-Jan-11 1:44am

What sort of jam are you in? Are you getting some errors?

shonezi 31-Jan-11 3:51am

I just can't get fill adapter to work for the table to generate report when I choose date in those two datetime controls because those datetime controls are not bound to the table. I am new to C# but eager to learn, I have a report, two datetime controls, one button, a table with primary column DateInput with dates, and I want when I choose dates and click on the button to generate report only for choose dates. I know I have to put some code in SQL for the report but I don't know how because those datetime controls are not part of the table

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Accepted Answer · 2011-01-30T22:04:00

Solution 2

Steps:
1. Get the 'To' date and 'From' date from the datepicker controls.
2. These dates are parameters to the query that will fetch data. Now query can be part of report or query data directly can be used in report
3. In query:

SQL

SELECT * FROM DailyReport WHERE DateInput BETWEEN @FromDate AND @ToDate

This query would return you the needed data. Use the data in your report and display it.

Posted 30-Jan-11 22:04pm

Sandeep Mewara

Comments

shonezi 31-Jan-11 4:57am

I did this but when I click on finish I get error in WHERE clause near '@', so when I try preview data I get nothing, no parameters

Sandeep Mewara 31-Jan-11 5:00am

'@' signifies parameters.

Either use the query in SP or parameterized query.

shonezi 31-Jan-11 5:14am

forgive me for asking but what does that mean to use query in SP or parameterized query???

Sandeep Mewara 31-Jan-11 5:27am

Not an issue. Tell me, how do you run a query OR get data for your report? Whats the procedure and the place you try to get data from?

shonezi 31-Jan-11 5:41am

ok1.I have table DailyReport
2.Dataset1 in which query is:

SELECT RB, Bankomat, DateInput, FROM DailyReport
WHERE DateInput BETWEEN @FromDate AND @ToDate

3. I use this Dataset1 for making Report1.rdlc which I use for reportviewer for generating report
4. above reportviewer is 2 dateTimePickers, one from and other to date, and the Button for generating report when I choose dates
5. in Button is code: private void button1_Click(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'DataSet1.DailyReport' table. You can move, or remove it, as needed.
this.DailyReportTableAdapter.Fill(this.DataSet1.DailyReport);

this.reportViewer1.RefreshReport();

I hope I have explained a little better how it looks like, I am quite new, but as I said , trying to learn :))

Sandeep Mewara 31-Jan-11 5:51am

So, you create a dataset and then assign that to report. Right?
Further, did you override report viewers button click?

You are not using SSRS reports designer where you can define dataset. Right?

shonezi 31-Jan-11 5:59am

yes, I used dataset and assign them to report, and no I am not using SSRS report designer. and overiding button click on reportviewer I don't know what it means but I just have one button witht he code above in previous comment

Sandeep Mewara 31-Jan-11 6:23am

Right. So, you don't need to override or so.

There are something called 'report parameters'. They are directly tied to Query parameters. Once you define them and use RDLC designer dataset, just put the query you are currently using. Map the @To & @From parameters. Rest let the SSRS handle. You dont need to override or do anything else.

SSRS itself would take the two datepicker values and fetch data based on the query with date values.
Fetched data would be displayed in the report as per fields mapped.

shonezi 31-Jan-11 6:12am

basically I have
table DailyReport with columns RB, Bankomat, DatInput
and I everyday write some data in and have dates
and I want report to open generated by dates, that's it

Sandeep Mewara 31-Jan-11 6:27am

On the DataSet definition page, there should be a tab called Parameters. You should be able to list the Query Parameters there, and hook them up to Report Parameters.

Helpful links:
http://msdn.microsoft.com/en-us/library/ms157187.aspx
http://msdn.microsoft.com/en-us/library/ms155917.aspx

Try and see if you still face issues. Keep it simple and just define the things and let SSRS do the work for you.

shonezi 31-Jan-11 10:12am

I can't see report Dtat pane in Visual studio 2010 on which I am working, and I work in C#

Sandeep Mewara 31-Jan-11 10:14am

You would need SQLServer BIDS to design a RDLC. There you can find designer.

shonezi 31-Jan-11 10:18am

I know I have put to much questions and perhaps you already are annoyed by me, but if I only have this what I have how can I make this work, what would you do, step by step if you don't mind.
one table, two datetimepickers, button.... choosing from date to date clivk on buton opens report, how would you do it easiest way

Sandeep Mewara 31-Jan-11 10:20am

If you cannot design the report as you say, then how are you planning to display data?

Just by assigning a datasource to report would NOT show you any data. (If you are assuming it would like in datagrid).

You need to design RDL, put table in it, map with query fields and then only you can view it.

shonezi 31-Jan-11 10:29am

ah sorry, now I know what you meant, I do have designed RDL but I just want to display those data by dates when I choose which one, I mean between dates

Sandeep Mewara 31-Jan-11 10:31am

Yes, I know. Now in your designer:
1. Define two date parameters
2. Define a dataset for the report
3. Use the current query
4. Map the two report parameters with query parameters
5. Done. Now, report will automatically fetch data between two date parameter values.

shonezi 31-Jan-11 10:40am

ok, just one thing, those two date parameters are dateTimePikcers???

Sandeep Mewara 31-Jan-11 10:43am

Once you define the paramters, it's on you how you take those values.

Design a form, place two datetimepickers and button and internally on button click, map your datetimepicker values with report and thats it. Report will handle the rest.

In BIDS, if you see the report and if you given to/From date as datetime datatype then datepicker comes up to get the data.

shonezi 31-Jan-11 11:35am

last question and then I am gone :)) defining date parameters , I need help on code. so I have two dateTimePickers: dateTimePikcer1 and dateTimePicker2, how does this code looks like
dateTimePicker1.Value
dateTimePicker2.Value
????