SSRS 2005 How to set up query and data-driven subscription when each retrieved row has its own email address

SSAS and SSRS
4

For a data-driven subscription - you need a query that returns the following information:

Select DistributionName
        , SendTo
        , SendCc
        , SendBcc
        , ReplyTo
        , IncludeReport
        , iif(RenderFormat = 'Excel', 'ExcelOpenXml', RenderFormat) As RenderFormat
        , IncludeLink
  From {some table} 
Where {some conditions};

You then map each field in the subscription to the appropriate field returned.

If you have 2 rows in the results - then 2 emails will be sent based on the values in the SendTo column.

1 Like