February 5, 2016 at 5:03 am
Hi
I have a table with date flags in
Such as CurrentMonth, CurrentYear, PreviousMonth etc.
This has a date as the SK and flags 1 or 0 dependant upon whether the date is in the current month etc.
In SSRS, I have created a fairly simple graph, that looks at the number of orders processed over time
Month/Year as x axis, Count as y axis
The order table joins to CalendarDate based upon the order date
Rather that ask the user to input a start and date, I'd prefer to use my date flags
So, the user is asked for 3, 6, 12 or 24 months and it filters and presents accordingly
I can achieve this using separate graphs with filters e.g. CalendarDate.CurrentYear = 1
Is it possible to prompt and filter using one single data source and one single filter?
I've played around with iif and switch but can't seem to get time frame on the graph to change
Thanks
Damian.
- Damian
February 7, 2016 at 10:16 pm
Try this excellent article http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/133147/ it may help and save you having to have flags and you can add date ranges as appropriate...
...
February 8, 2016 at 2:12 am
Thanks, that helps
This does look very useful
- Damian
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply