May 24, 2012 at 9:13 pm
I have the following questions for running an subscription for an SSRS 2008 r2 standard edition report
1: When the subscription is setup, how will it know what ssrs 2008 r2 report to execute and what parameter values to give to the SSRS report? Is there an exe that is executed?
2. How does the subscription export the report that is generated to a PDF file in a specified directory path location?
3. I also want to subscription to execute a stored procedure that will export the data that appeared on the report to an excel spreadsheet for users to work with.
Thus can you tell me and/or point me to a reference that will show me how to accomplish these tasks?
May 25, 2012 at 12:04 am
wendy elizabeth (5/24/2012)
I have the following questions for running an subscription for an SSRS 2008 r2 standard edition report1: When the subscription is setup, how will it know what ssrs 2008 r2 report to execute and what parameter values to give to the SSRS report? Is there an exe that is executed?
2. How does the subscription export the report that is generated to a PDF file in a specified directory path location?
3. I also want to subscription to execute a stored procedure that will export the data that appeared on the report to an excel spreadsheet for users to work with.
Thus can you tell me and/or point me to a reference that will show me how to accomplish these tasks?
1- a job is created in the SQL agent for each subscription. The parameters are stored in the SSRS database linked to the subscription for a normal subscription and a query to retrieve the parameters for a data driven subscription.
2- when the subscription is created you are asked which export type to use. Hard coded for a normal subscription or data driven from a field in the data or hard coded for a data driven subscription.
3- if I understand you right, a single excel file with two tablix would suffice, the first is the nicely formatted output, groups etc and the second is a dump of the raw data, separated by a page break which would cause a new tab in excel.
Fitz
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply