sql server reporting services: Subject Line and Subscriptions - Passing in ReportName -- sql server reporting services

Subject Line and Subscriptions - Passing in ReportName

Scott Eguires
8/10/2005 11:23:04 AM

sql server reporting services:

Is there a way to pass in the reportname to my datasource for a data driven
subscription. For example:

exec usp_Rpt_MySubscriptionParms @ReportName

The reason for this is so I can append the reportname in front of storenames
for the subject header without having to create multiple datasources for each
report.

i.e.,

Subject: Sales Report - Chicago Store #200

If there is another way to do this please let me know.

Thanks,

RE: Subject Line and Subscriptions - Passing in ReportName

Scott Eguires
8/10/2005 11:50:52 AM

Never Mind. I just figured it out on my own. I can just pass in the
reportname as a constant:

exec usp_Rpt_MySubscriptionParms 'My Report Name'

This works since the Subscription is specific to the report.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.