Processing report -- sql server reporting services

siaj
3/10/2005 11:23:02 AM

Hello,
In my MS report I have 4 textbox parameter and One dropdown parameter
two of the textboxes and the dropdown has queried parameter. All of them
have default parameter.
The issue I am facing is that When ever I click on the preview Report on the
dev machine, My report starts to do "Processing Report" with the "View
Rreport" button disabled. The processing report keeps on going although the
query runs fine in QA in 2-3 minutes.

I want the preview report should start processing only when I click "View
Report" so that I can drill down to real problem.
I have tried removing one of the default parameter so that it waits for
parameter but it does not helps..
Any suggestions will be highly appreciated...

Cheers,
siaj

Robert Bruckner [MSFT]
3/10/2005 8:18:53 PM

You said: "All of them have default parameter."
If all parameters have a valid default value, the report will run
immediately. This behavior cannot be changed in report manager. You could
remove the default value e.g. from the last report parameter which will
prevent running the report immediately.

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

sql server reporting services : Processing report