Link to home
Start Free TrialLog in
Avatar of Robb Hill
Robb HillFlag for United States of America

asked on

SSRS - Date Report Options

Here is what I would like to accomplish:

I would like to build a parameter on a report that gave date options.

For example the parameter would be a dropdown list like so:

1)  Monthly  ( Monthly would be based on the current day and month and be the beginning of that month to the following month.
2)  Quarterly  ( Same principle as Monthly.  Just do it based on the Current month that I am in.
3)  True Quarterly (give the option to select Q1, Q2, Q3, Q4 where those Qs break up the year from Jan 1 in to 3 months a piece)
4) Yearly:  This would need to be the current month and a year out from that date.
5) True Year:  Beginning to end of year.



I would want to default this parameter to Monthly so it doesn't have to be selected.


Please help
ASKER CERTIFIED SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial