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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics