Listing Subscribed SSRS Reports including Parameters & their Values

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Bhudev Prakash » Listing Subscribed SSRS Reports including...

Listing Subscribed SSRS Reports including Parameters & their Values

Rate Topic

Display Mode

Topic Options

Author

Message

Bhudev Prakash

Posted Friday, January 15, 2010 1:34 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, May 13, 2013 8:00 AM
Points: 49, Visits: 168

Comments posted to this topic are about the item Listing Subscribed SSRS Reports including Parameters & their Values

Post #848123

SAinCA

Posted Thursday, February 04, 2010 5:05 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 11:57 AM
Points: 115, Visits: 487

Nice start, but what about Parameters on a Linked Report that are hidden from the User and are assigned default values? The subscription is based off the Linked Report.

Any ideas on how to include those, too, please?

Post #860050

JMI

Posted Wednesday, February 09, 2011 11:19 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, June 28, 2011 12:06 PM
Points: 557, Visits: 775

Bhudev!

Excellent query!

It is a huge problem for us to quickly identify the SubscriptionID
when user forwards an email generated by Subscription (built-in, not DDS).

With your query it becomes a lot easier.

Bhudev,
Do you know if it's possible to retrieve SubscriptionID at the time of Subscription execution?

It would be so nice to have let's say an Email Subject like:
"Report: Global Derivatives - Risk Summary; SubsID='267DF775-59C9-40DA-A173-06106AD89110'

Post #1061414

« Prev Topic | Next Topic »

Permissions