Hi friends,

Did any one came across how to enable/disable report filters?

As it seems once we have included a report parameter it will automatically become a filter for the same report. But i need to set some of the filters as hidden as a configuration setting.

Can any one help me in doing this?

Lasi

Hi Lasi,

 You could set the parameter to be of the Hidden or Internal type. This can be done by going to Report -> Report Parameters menu option when the report is in Data or Layout modes. Here you can set the parameter to be Hidden and then set a default value to it either from a query or a non-query by specifying a value or expression.

After publishing the report, values can be set for the hidden parameter, either through the report URL like this:
http://exampleWebServerName/reportserver?/foldercontainingreports/report1&param1=testvalue
here, report1 is the report. param1 is the parameter and testvalue is the value for the parameter.

or by using something called a subscription definition (this is when users subscribe for the report). More information about it here: http://msdn2.microsoft.com/en-us/library/ms157306.aspx

Hope we could get more insight from others as well, especially regarding setting values from configuration files etc.

Regards.

Gogula G. Aryalingam (MVP - SQL Server)

Thanks lot.

Hi friends,

It looks like all the methods mentioned here is to set parameter options manually. What i really needed is to set parameter visibility at run time. Currently i am investivating to write a custom code for it. Any new ideas are mostly welcome.

Hi All,

I found a way of implementing this functionality! but sorry for late reply.

I am using ReportParameter objects to set parameter values through the visual studio report viewer control. It contains a "Visible" property to do hide when necessary at the run time.

Following is a code sample:

ReportParameter p1 = new ReportParameter("Parameter1", param1Value);

p1.Visible = true;

Thanks for the support!

Lasi