Hi all,
I have couple of issues with my reports.
1) i have a report that has prompt pages.it works fine when i run it in report studio. but when i schedule the report the prompt page doesnt prompt for input values and directly runs the schedule. i have also verified the actions where the settings for prompt values is checked.
2) when i run the report and choose the excel format it returns an error multiple queries defined.
The first issue is related to the fact that previous prompt selections are stored if you're the owner of the report. You could develop the report using a different logon. This shouldn't be an issue for the users though. Good luck.
Sorry i was on vacation and i couldnt respond to this mail. I have written code to clear the prompts when the page is reloaded. it does nt store any values.
2) i managed to solve the second one as i needed to add to the trusted sites my main page .
I am still having the first issue...
Check on the report options in set properties of the report also..Check that no values are stored.
Srik
sudhircrn,
Have you tried taking ownership of the report as a different user and ten logging in with your user credentials and running the report again?
Yes . I tried to login as a different user and then logged back on my user credentails. But still it persists.