Auto refreshing a report for certain time

[DSR]

Hello Guru's,

I am using Cognos 10.1, In Report Studio I have one required Value Prompt on a prompt page. First time when user runs the report user will select value and click on the finish button which will execute the report. From that time let say every 5 minutes report should refresh for the selected value and prompt page should not appear. Whenever user wants to select another value there will be a button or link in output page which takes to the prompt page.

Please throw me some ideas, I was thinking about Java Script and etc.

Thanks in Advance.

Regards,
DSR

[RKMI]

Hi,

Did you see this post by Paul, http://www.cognoise.com/index.php/topic,10856.0.html

It uses JS.

Thanks,
RK

[DSR]

Thanks for reply.

The above script works without a prompt page in report. As I explained if there is prompt and if prompt is selected report should not show prompt page again, it should refresh for every 5 minutes. I want to check the condition of the prompt in javascript before it executes and refreshes. If prompt does not have value then prompt page should appear. if prompt is having some value, report should refresh with the selected value in the prompt without displaying the prompt page.

Hope you got my requirement.

Regards,
DSR

[Rahul Ganguli]

Hi,

You can still perform this using JavaScript.
You need to get the promt value in a variable and append it on the report url, also you have to append &prompt=false in url.
This way the report will run again without prompting for the same selection.

Regards,
Rahul

[DSR]

Thanks for helping me. Issue got resolved. Used regular report refresh java script and unchecked prompt for values check box in cognos connection report properties. This will prompt prompt page first time and next time onwards report will not display prompt page.