Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
 Posted - 2008-09-25 : 21:37:25
|
| We have a .NET app that uses ReportViewer to show SSRS reports. During development, it's convenient to show the params on the report so the .NET developers can see if the params are being passed correctly.However, after development of a module is done, we need to hide the params. Is there are way of doing this on all reports within, say a certain folder for example, by running a script? Maybe on the ReportServer DB? I've had a look, but the parameter col doesn't seem to have show/hide in it.Has anyone something like this? |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-09-26 : 01:32:51
|
| Got some help from a friend. I wasn't seeing all the data in the ReportServer.dbo.Catalog.parameter column because the column length was being limited by the query editor. The comment below shows the difference between a parameter which is hidden & which is not. I just need to create a query to replace the text accordingly.<Parameter> <Name>Div</Name> <Type>String</Type> <Nullable>False</Nullable> <AllowBlank>False</AllowBlank> <MultiValue>True</MultiValue> <UsedInQuery>True</UsedInQuery> <State>MissingValidValue</State> <Prompt>Division</Prompt> -- NOT HIDDEN <PromptUser>True</PromptUser> <Dependencies> <Dependency>cbCompany</Dependency> </Dependencies> <DynamicValidValues>True</DynamicValidValues> <DynamicDefaultValue>True</DynamicDefaultValue> </Parameter> <Parameter> <Name>Show_State</Name> <Type>Boolean</Type> <Nullable>False</Nullable> <AllowBlank>True</AllowBlank> <MultiValue>False</MultiValue> <UsedInQuery>True</UsedInQuery> <State>MissingValidValue</State> <Prompt /> -- HIDDEN <PromptUser>True</PromptUser> <DefaultValues> <Value>False</Value> </DefaultValues> <Values> <Value>False</Value> </Values> </Parameter> |
 |
|
|
|
|
|
Script to hide paramaters