RS Data-Driven Subscription

[NewsBot]

Hi*guys,

 

i'm trying to create a data-driven subscription for a report, where the report should be sent as*email for a specified reciepiant. Everything works fine till i need the command of the delivery extension settings parameters to use a user defined*function.

 

For example, i need the comment part of the email to be configured by parameters, so i have a function that gets those parameters and returns the body as a string.

 

my command should be like this :

SELECT Alias,'CONSOL' LoanType,'PDF' Format, dbo.EmailBody('CONSOL') Comment.

 

my problem exactly in the Comment part....

 

do u have any idea how to solve such issues or any workarounds for this :(

 

thank you indeed

 

More...

 

View All Our Microsoft Related Feeds