Post reply

Using sysdate in report subscription

  • May 6, 2009 at 8:38 am

    #209186

    Hi

    I have a number of reports which run against the previous weeks data, I would like to automate this report using the SQL subscriptions.

    The report parameter requires a first date and last date, can I use sysdate -7 and sysdate -1 so that I don't have to continually edit the subscription?

    Any help would be greatly appreciated.

    Thanks

    Craig H

  • May 7, 2009 at 3:34 am

    #990193

    Solution found

    I set the first date to use a non-queried default of "=dateadd("d", -7, today())", while last date would default to "=dateadd("d", -1, today())" then when you subscribe the report will default to the previous week's data.

    It still allows other users to run the report for ad-hoc periods, they can just replace the default values when submitting the report.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply