Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Listing Subscribed SSRS Reports including Parameters & their Values Expand / Collapse
Author
Message
Posted Friday, January 15, 2010 1:34 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, May 29, 2014 9:07 AM
Points: 49, Visits: 186
Comments posted to this topic are about the item Listing Subscribed SSRS Reports including Parameters & their Values
Post #848123
Posted Thursday, February 4, 2010 5:05 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, November 24, 2014 11:14 AM
Points: 117, Visits: 586
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
Posted Wednesday, February 9, 2011 11:19 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr 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
Posted Thursday, November 7, 2013 1:31 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 7, 2013 1:28 PM
Points: 1, Visits: 0
I'm new to this forum and writing queries as well.
I have tried running this script in Management Studio and it runs fine, however if I try to build a report in VS2k8 I get the following error: An error occurred while the query design method was being saved. SELECT failed because the following SET options have incorrect settings: 'ARITHABORT'.
This comes up after pasting the query into the design query window and hitting next.
Does anyone have a an easy solution for this?
Thanks..
Post #1512433
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse