Post reply

Report Expiry & Subscriptions

  • August 17, 2005 at 10:41 am

    #110810

    I've set a report expiry of 100 years on one of my reports(it takes three parms), but only one needs to be specified as the other two are derived.

    I created a subscription to generate the report with certain parameters, and tracked the calls to the db using profiler, and sure enough the stored proc is called. However when I then went in through the report manager interface and viewed the report with the same parameter, the system seemed to still access the db and not use the cached data from when the subs had run previously.

    I think the problem is that the subsscription does not cache the data since if I subsequently run it through report manager it does NOT query the db as expected.

    Any ideas why this is and if the subscription can be made to cache the data?


    Thanks Jeet

  • August 17, 2005 at 11:54 am

    #582852

    I think you want a snapshot (can't remember if its the history or execution tab on the properties) and then you can check a box to have it display from the snapshot.

  • August 17, 2005 at 3:13 pm

    #582884

    I've had alook at snapshots, but can't find out how you can specify parameter values. I plan to call this report with two different parameters, and although you can specify defaults for these parameters I can't see how you can say for a snapshot use a certain set of parameters.


    Thanks Jeet

  • August 18, 2005 at 5:55 am

    #582973

    If you're trying to create multiple snapshots of the same report using different parameter sets, you'll need to create a linked report.  A report can use only the default parameters when taking the snapshot.

  • August 18, 2005 at 3:06 pm

    #583346

    Many thanks for pointing me in the correct direction David.

    I never know this facility even existed depite the great big button on the general tab.


    Thanks Jeet

Viewing 5 posts - 1 through 4 (of 4 total)

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