1. prompt values 2.excel format

[sudhircrn]

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.

[bdybldr]

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.

[sudhircrn]

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...

[BIsrik]

Check on the report options in set properties of the report also..Check that no values are stored.

Srik

[bdybldr]

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?

[sudhircrn]

Yes . I tried to login as a different user and then logged back on my user credentails. But still it persists.