January 9, 2018 at 12:37 pm
If I change a report that already exists on the store(webpage)
can I move subscriptions to the new report or do i have to recreate?
Thanks
January 9, 2018 at 12:55 pm
jbalbo - Tuesday, January 9, 2018 12:37 PMIf I change a report that already exists on the store(webpage)
can I move subscriptions to the new report or do i have to recreate?Thanks
If you aren't renaming the report, it should just overwrite the existing report and keep the subscriptions.
If you want to test it in a lower environment, you can query the Catalog table and the Subscription table to make sure the report id and subscription id remain the same when deploying the updated report. Report_OID in subscriptions maps to ItemID in the Catalog table.
Sue
January 9, 2018 at 2:40 pm
Ahhh....
I see my problem, some reports are in sub folders, so if I temporarily move it to the main folder , overwrite it with the new report, then move back to the sub folder the subscription will stay?
January 9, 2018 at 2:53 pm
jbalbo - Tuesday, January 9, 2018 2:40 PMAhhh....I see my problem, some reports are in sub folders, so if I temporarily move it to the main folder , overwrite it with the new report, then move back to the sub folder the subscription will stay?
Yes as long as you overwrite and not replace the report. Moving reports around won't change the Report_OID in the subscriptions table or the ItemID in the Catalog table.
The subscription table doesn't have the path to the report - just the catalog table. Moving a report just updates the path in the Catalog table.
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply