Report from - Report to

Hi,

I have a report setup on reporting services which has several subscriptions attached. The report is run every business day, each hour (8am till 7pm), but the only problem I currently have, is with the report from and report to fields. Is there a proper way to set these up for the automatic distribution, so that the subscription that runs at 8am, will report data from the day before 7pm till 8am?

thanks!

Lionell

Can you clarify your ask? I think what you want is possible, but I'm not sure whether you want a distribution list (data-driven subscription) or you want the 8:00 AM report to be different than the other reports (parameterized report or distinct .RDL).

|||

It's a standard report, not a data-driven subscription. The 8:00 AM report needs to report data from the last time the report was run the previous day until 8:00AM of the current day.

Is there a @.LastTimeRun function which can be used? This probably needs to be put into the report right? Or can it be configured through the web based report manager?

Every report that runs needs to report data from a certain period, for example the 8:00AM report will report from 7pm previous day till 8:00AM current day. Next report will be run at 9:00AM and report data from 8:00AM till 9:00AM and so on.

Hope this explains it better.

regards

Lionell