Robb Hill
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.