June 17, 2009 at 9:30 am
What I am wanting to do is let my users have the ability to select a Date range (Start Date) and End Date) when they select on a report. It seems to me there has got to be some way of doing this.
I know that this can be done through the Report Builder option. However my supervisors feel that this would be too much work for the users to do.
I'm not even sure this is possible in SQL 2005. I spent the morning checking online an there is documentation for doing it in SQL 2008 but not 2005.
Any assistance would be welcomed.
Figured it out!
June 18, 2009 at 9:51 am
you can create parameter in report with start date and end date and type should be date time. Then you pass that parameter into your stored procedure and get the data according to start date and end date.
When you create parameter in your report as type of datetime then it will appear as a calender in your report preview.
i hope it helps.
Vijay
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply