datepicker

Question

0.00/5 (No votes)

See more:

I am using the vs2008 ReportViewer control, and I'd like to filter the date range on the report by selecting it from (2) DatePicker controls. There are a couple of ways to do it I'm sure, but I would like to write the filter as an expression in the reportviewer designer. How can I target a control(s) on my form to filter the expression through?

Please give sample fragment code. I just need this badly..

Posted 7-Mar-10 23:42pm

xiroH4ck3r

Updated 7-Mar-10 23:43pm

Deeksha Shenoy

v2

Add a Solution

5 solutions

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 · Answer 1 · 2010-03-08T03:43:00

Why would you fetch whole lot of data from DB and then apply filter expression on SSRS when you have an option to pass on the date parameters to the query and get back the desired data directly?

Take 2 dates from date control, pass those as query parameters to fetch report data. Display the data (which is based on the 2 dates selected.)

xiroH4ck3r · Answer 2 · 2010-03-08T04:08:00

Solution 2

yap I want that but how to do that pal hehehe

Posted 8-Mar-10 4:08am

xiroH4ck3r

Kschuler · Answer 3 · 2010-03-08T04:26:00

You can't automatically connect the reportviewer to another control.

You're going to have to edit the actual report to have it accept parameters, pass the parameters into the report, edit the report to use those paramters to narrow down the data in the report, and then reload the report everytime a new date is selected. It would really be better practice, and easier, to do what Sandeep suggested and select the data that falls in that date range and only send that data into the report.

Hope this helps.

xiroH4ck3r · Answer 4 · 2010-03-08T05:39:00

Solution 4

how to do that any fragment code please...

Posted 8-Mar-10 5:39am

xiroH4ck3r

Kschuler · Answer 5 · 2010-03-08T06:06:00

Solution 5

You can find sample code by searching through code project articles[^] that deal with ReportViewer controls. Or google.[^]

Posted 8-Mar-10 6:06am

Kschuler

datepicker

5 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0