Dynamic recipients with a prompt

[Former Member]

We have Webi report which is generated by passing the parameter in Stored procedure. and we use the same report and parameter for generating the dynamic recipients list  to publish the report. But we have issue, when we do publication by dynamic recipients, it uses the list last saved in the report instead of running the report with a prompt. Therefore  in order to distribute the report, first I have to manually run the report with prompt for dynamic recipients and save it and then run the publication. The list has to be updated manually when needed.  Is there any way this report gets refreshed by itself by using the same prompt as source document? We are using the same query for recipients list and source document

[Former Member]

So is there any other way?

[DellSC]

You could design a report that just provides the data you need for the recipients without any parameters.

-Dell

[DellSC]

AFAIK, reports used for Dynamic Recipients can't have interactive prompts - it automatically uses the last prompt value that was saved for the report.

-Dell

[CdnConnection]

Amar,

      Have you tried purging the Data with Option ( DO NOT REMEMBER PROMPT), this way it will NOT retain the last prompt.

Regards,

Ajay