Date Range as a parameter

joshis5322 used Ask the Experts™
I've just one date column as ScheduleDepartureDate in my reports which is also a parameter field. I've used SSRS2005 and called stored procedure to get this data on my report.
Now, I've to create a range field as a parameter from that single date column. For eg;
StartSchedDeptDate and EndScdedDeptDate as a parameter field in that report.

Is there any way to do that in SSRS 2005?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Sure, the easiest thing to do is have your Stored procedure accept two date fields @startdate and @enddate you then just send them to the stored proc as parameters?

You would then need to modify your query in the stored procedure to do something like the following

select * from departures where scheduledeparturedate between @StartDate and @EndDate


Thanks Auric.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial