how to hide parameters in Reporting URL in SSRS 2008
I would like to hide parameter Date2 using URL in SSRS 2008. I can hide all parameters using rc:Parameters=False but i would like to have other parameters list and would like to hide only 1 parameter.
http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fTest&rs:Command=Render&rc:Parameters=True&Date1=01/01/2011&Date2=1/1/2012
Thanks.
Padam
June 15th, 2011 11:39pm
Looks like this may work
This is possible, in the xml definition for the report, find the definition for the parameter, it should look something like this
<ReportParameter Name="YourParameterNameHere"> <DataType>String</DataType> <Prompt>YourParameterNameHere</Prompt></ReportParameter>
And you can add this line to set hidden to true:
<ReportParameter Name="YourParameterNameHere"> <DataType>String</DataType> <Prompt>YourParameterNameHere</Prompt> <Hidden>true</Hidden> </ReportParameter>
http://stackoverflow.com/questions/3636905/how-can-you-hide-unhide-reporting-services-report-parameters-via-url-query-stringJeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
Free Windows Admin Tool Kit Click here and download it now
June 15th, 2011 11:50pm
Thanks, but i would like to hide parameter from URL and not from XML. My requirements is little different.
Can we hide parameters from URL? I know i can do rc:Parameters = false but it hides all parameters and i would like to hide 1 parameter only. Padam
June 16th, 2011 11:06am
Did you read the article? If so, I don't think you understood it as it advises how to hide URL parameters by modifying the report definition file (which is an XML file).
So, if you do this in the report definition file
<ReportParameter Name="Date2">
<DataType>String</DataType>
<Prompt>Date2</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
You should get this URL
http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fTest&rs:Command=Render&rc:Parameters=True&Date1=01/01/2011
If you did read the article and that's not what you want then I may not completely understand your question :-)Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
Free Windows Admin Tool Kit Click here and download it now
June 16th, 2011 11:21am
Hi Padam,
Based on the discussion above, I noticed that you only need to hide one parameter but keep the others through URL access, correct? However, the rc:Parameters is used to control
the visibility of parameters area in the toolbar.
As an alternative approach, I would suggest try to create a linked report based on the current report. In this way, we can re-configure the parameters. For example, specify default
to the Date2 and hide it. Then, if we need to hide the Date2 parameter, we can specify the path of the linked report in the URL.
For more information about Adding, Modifying, and Deleting Linked Reports, please refer to
http://msdn.microsoft.com/en-us/library/ms155889.aspx
Thanks,
Tony Chain
Tony Chain [MSFT CSG] | Microsoft Community Support
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
June 20th, 2011 11:31pm