Skip to Content
avatar image
Former Member

Dynamic recipients with a prompt

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Mar 31, 2016 at 12:25 AM

    Amar,

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

    Regards,

    Ajay

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 31, 2016 at 05:55 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 31, 2016 at 06:03 PM

    So is there any other way?

    Add comment
    10|10000 characters needed characters exceeded