June 24, 2008 at 2:47 am
Hi
A couple of questions on email Data Driven Subscriptions.
1) Is it possible to display report parameters in the email subject?
2) Is it possible to have one email sent out containing multiple versions of the same report with different parameters?
Regards
Ben
June 25, 2008 at 5:39 am
For your first point Yes for Data Driven subscriptions you can control what gets placed into the Subject Line. This can be from a parameter or from the data driven Sql
/***********************************************
SELECT CASE WHEN count(*) > 0 THEN 'email_Person'
ELSE 'No Records Email' END AS EMAIL,
CASE WHEN count(*) > 0 THEN 'Enter Subject Line when there are records'
ELSE 'Enter Subject Line when there are no Records' END AS SUBJECT_LINE
FROM 'YOUR FROM CLAUSE ON YOUR REPORT'
****************************************************/
For your second point i do not believe there is a way of sending multiple reports from a single subscription
June 25, 2008 at 8:16 am
Yes, I could retrieve a subject line from the data driven sql.
The default subject when you set up a subscription is
@ReportName was executed at @ExecutionTime.
These 2 variables are from the globals collection that you can use when designing a report. I wondered if you have access to the others or the parameter collection. I've had no luck so far so I assume not.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply