Passing both seen and unseen Parameters on URL | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Passing both seen and unseen Parameters on URL

Hi <br />Im trying to pass both seen and unseen parameters to the report via the URL at the same time. The seen parameters are those viewed by the user, the unseen are those that pass information to the report and display specific information relative to the user (Region, Language, Currency). <br /><br />In the Parameter Section in the Report Manager under the properties tab the Parameter settings are as follows<br />RegionID<br />Prompt string: empty<br />Prompt User: Remove Tick<br />Default Value: empty<br />Has Default: empty<br />EntityID<br />Prompt string: Entity<br />Prompt User: Tick<br />Default Value: empty<br />Has Default: empty<br /><br /<a target="_blank" href=http://localhost/reportserver/?%2fTesting%2fReport1&rs:Command=Rende&RegionID=5&rc<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />arameters=true>http://localhost/reportserver/?%2fTesting%2fReport1&rs:Command=Rende&RegionID=5&rc<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />arameters=true</a><br /><br />I get an error<br />•The report parameter ‘MA’ is read-only and cannot be modified. (rsReadOnlyReportParameter) <br />High Security is not necessary however passing parameter the user is not aware of is vital.<font face="Verdana"></font id="Verdana"><br />Thanks again<br />Dale<br />
….just to keep you all informed.
I spoke with a Microsoft rep and he says this is a know issue and said :
"This is a known issue. You will be able to work around this in SP1 by clearing out the prompt string once the report has been published to the server." Ive heard SP1 is planned for release on June 15th.
]]>