SSRS help
amy77
Posts: 1 New member
Hi Guys,
Had a general question regarding SSRS - I want to be able to set up an automated report that is sent quarterly to users.
The script is the same but needs different date ranges based on the month the report is sent.
Ie, if it's January -> report should pull data between '01-01-previous year' AND '12-31-previousyear'
if its April -> report pulls data between -01-01-currentyear' AND '03-31-currentyear'
Is this possible?
Had a general question regarding SSRS - I want to be able to set up an automated report that is sent quarterly to users.
The script is the same but needs different date ranges based on the month the report is sent.
Ie, if it's January -> report should pull data between '01-01-previous year' AND '12-31-previousyear'
if its April -> report pulls data between -01-01-currentyear' AND '03-31-currentyear'
Is this possible?
Tagged:
Answers
Thanks for your post!
Unfortunately, as SSRS is a Microsoft Product and not a Redgate Product there is little information we can offer you on the subject.
However, Microsoft also has a Forum and your question may be better placed here!
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home