How can I launch a report without generating it automatically?

I am accessing a report in IE by typing the following link in the address field:

http://localhost/ReportServer/Pages/ReportViewer.aspx?/Reports/TheNameOfMyReport

When the page is loaded, the report is generated automatically because all report parameters have default values.

How can I modify my report so that it is not automatically generated? I would like to wait until the user clicks on "View Report" before rendering the report.

As a temporary solution, I removed the default value of one report parameter but I would like to get it to work even if I leave all default values in.

I have seen sites where they describe a list of extra parameters you can include in the url to modify the behavior of the report like:

&rs:Command=Render

&rs:Format=Excel

&rc:NoHeader=true ...

but I haven't seen anything to tell the reporting engine not to render a report.

Any help would be appreciated, thx.

Is this not possible. I am also looking forward to a way to do the same?|||This appears to be only possible with your workaround above or by using the Reportviewer control in Visual Studio.

How can i insert a curreny formated column

Hi i have made a column that is called carprice. Instead of just typing in £500 i want to be able to put in 500 and then have sql auto format it to £500 in the column. In other words just put the £ price infront. Is there a way of doing this thanks.A currency value should be left as a number without any symbols. The client side code should be the one formatting the value with the appropriate currency symbol. DotNet has support for this type of thing for client side formatting.|||I agree, storing as a number is the best design. Later when you need to use that data in a calculation, you dont have to try and parse it and deal with invalid entries. But the downside to just having a number is that you have no idea what currency that number is in. So if your app has any possibilities of ever going global, you might consider having a second field to track the currency. You could have a dropdown that lists all the currencies you support. You could then case on the currency to do the formatting of the output of the value you stored as a number.