Hiding Report Parameters

Monday, December 13, 2004

17 comments

Dear Vivian:

You didn’t leave me a return address, so I hope you see this response. I said I had an answer for you, but it’s taken many days to respond, and I apologize. It has been a difficult week in the salt mines. Deployments. Conference calls. Customers destroying network settings. Sales staff destroying demo software. It's crazy around here.

Anyway, the question was: how to hide a parameter in Reporting Services?

Go to the Report menu, select Report Parameters, and highlight the parameter you need to hide. The key is to clear the Prompt text box, and make sure to supply a default value. Reporting Services will no longer prompt the user to enter a value for the parameter. The parameter value can still be dynamic if there is a VB expression or a query to specify the default value.

To override the parameter at run time with a different value (perhaps by passing the new value in the query string when using URL access), then you may get the error “parameter is readonly and may not be modified”. Make sure to install SP1 for Reporting Services to fix this.

To determine the version of Reporting Services, go to the base URL for the report server (typically http://machinename/reportserver/. At the bottom of the browser page will be the version number:

Microsoft SQL Server Reporting Services Version 8.00.743.00 <- this is old

Microsoft SQL Server Reporting Services Version 8.00.878.00 <- this is SP1

Comments

Johan Trusell Friday, January 21, 2005

Hello,
 
 I tried this, but RS is still prompting. Is it beacause I have more than one parameter?
 
 Best regards/ Johan

Scott Friday, January 21, 2005

Johan: Do all the parameters have defaults?

David Tuesday, February 1, 2005

I've installed SP1 but I still get a message: "The report parameter '<parameter name>' is read-only and cannot be modified. (rsReadOnlyReportParameter) Get Online Help". Everything works fine except when I try to set the hidden parameter from the URL. Is there something I'm doing wrong?

Scott Thursday, February 3, 2005

Did you happen to clear the "prompt user" checkbox? I believe this has to be checked, but the prompt string has to be empty. Does that help?

james king Saturday, March 19, 2005

Hi, I would like to hide the parameters as I do not prompt the user for any. Parameters are supplied based on other information relating to a user on a web site. The problem I have is that if I view the source ( the report is a drill down report) the parametes can be viewed. Is there any way to mask the paramters from the source. I tried generating the report thru the SOAP API and based on the sessioned use the sessionID to render the uRL rs:SessionID=.... This also did not work as the parameters, although stored (SessionData table) are not rendered based on the current sessionID.

Scott Saturday, March 19, 2005

Perhaps you could set the default parameter value to an expression with code in Reporting Services.

james Sunday, March 20, 2005

If the parametrs are stored on the database along with the sessionID is there no way to force the use of the parameters for that session. I noticed there is also a sanpshotID does the same apply, in that, can I pass in a snapshotID and have the report rendered with the parameters insteading of prompting again?
 Are there any appoaches to hiding the parameters source with ReportViewer?

Scott Tuesday, March 22, 2005

With the ReportViewer you should be able to pass all the parameters in the query string, and set the parameter area visibility to false.

Darin Tuesday, March 22, 2005

Is there a way to set the "Prompt User" checkbox in the report manager programatically?
 
 Thanks.

Scott Wednesday, March 23, 2005

Darin:
 
 You can do this with programatically with the SOAP API. SetReportParameters takes an array of ReportParameter objects. A ReportParameter has a PromptUser boolean property.

Andy Thursday, March 24, 2005

I have linked to a related blog entry. I posted a note under "Andy" for those of you that are trying to hide a userid.

Andy Thursday, March 24, 2005

oops, the link ended up as my name. I guess that makes sense, but here it is again:
 
 http://geekswithblogs.net/gobrien/archive/2004/07/30/9116.aspx

Bob Brutus Thursday, March 31, 2005

The easiest way to hide report Parameters is as follows:
 strReportParm = "rc:Parameters=false"
 strReportParm +="OtherParms"
 "http://Localhost/ReportManager?/Report Folder/ReportName", strReportParm
 
 Have Fun

Timur Thursday, July 14, 2005

Hello All!
I have a problem with hiding 2 of 3 report parameters. How could I send 2 report parameters in URL and provide user with possibility to select remaining one?

I've tried to realize this, but after selecting remaining parameter and clicking 'View report' I just see nothing, no errors and no report.

Valar Wednesday, June 28, 2006

Hi all...
Here I have a problem in MSRS2005.
Let me explain my scenario..
I have a report parameter allowed Multivalue selection in it. The value for this parameter is coming from a Dataset, suppose if this dataset returns only one value , the parameter should be defaulted otherwise if it returns more than 1 value the parameter should not be defaulted. Is there any way to achieve this??
I have tried adding a second datset to get the number of rows returned by the first dataset, by passsing this value to the parameter default expression..but this doesnt work. Can anybody help me out in this...

Thanks in Advance
Valar

Dom Thursday, June 29, 2006

Since this is a popular search result, everyone please note that SP2 is out.

And also that you may have to apply SP2 to the server and to the box running visual studio (can someone confirm this?)

scott Friday, June 30, 2006

Valar: I'm afraid I can't help, I have not used SSRS 2005.

Dom: Yes, that is correct. The SP would need to be applied anywhere there is an SSRS component installed, either client or server.

Comments are now closed.

On Twitter

Contact

Search Archives

by K. Scott Allen

Tweets about "odetocode"