rm103
asked on
SSRS Create drop down date open for Week To Date, Month to Date and year to date
Hello,
I'm working on an SSRS report which I'm extracting sales data for different item classes. I have the body of the report complete. I need to create a parameter drop down to either report on sales by week to date, month to date or year to date. I would rather provide a drop down instead of a start and end parameter where the user has to select specific dates. I"m not sure where to begin to develop the query and where to insert it on the SSRS report (maybe a 2nd dataset?) If so how do I link the 2nd dataset of the date calculation to the drop down parameter list?
Any help would be appreciated. Thanks..
rm103
I'm working on an SSRS report which I'm extracting sales data for different item classes. I have the body of the report complete. I need to create a parameter drop down to either report on sales by week to date, month to date or year to date. I would rather provide a drop down instead of a start and end parameter where the user has to select specific dates. I"m not sure where to begin to develop the query and where to insert it on the SSRS report (maybe a 2nd dataset?) If so how do I link the 2nd dataset of the date calculation to the drop down parameter list?
Any help would be appreciated. Thanks..
rm103
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Rm103