Report Builder 3.0 - display filters used
Hello, I am trying to simply display the filters used in a report. I know that it was possible in an earlier version of report builder (by right-clicking insert -> filters description). But since the option is no more present in report builder 3.0, how can I do that now? Many thanks in advance.
March 19th, 2011 6:55am

might this help you to add filters to your dataset in report builder3.0 http://technet.microsoft.com/en-us/library/dd255287.aspx
Free Windows Admin Tool Kit Click here and download it now
March 19th, 2011 4:38pm

If you are applying the filters based on the parameters selected by the users, on the interactive environment (on the browser), the parameters part is always displayed. Users can always know what seletions have been made for the report to be displayed. If your idea is to display the parameters in the print area, then you need to manually add text boxes or other controls and set the values of parameters selected. Hope this helps Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH
March 19th, 2011 11:38pm

Ok, if the filters are based on parameters, it is possible to display them in a text field. However, can it still be done if the filters are added in the dataset or the tablix?
Free Windows Admin Tool Kit Click here and download it now
March 21st, 2011 4:11pm

Yes it is possible to display the values in textbox. 1) If the parameter allows single selection, then use the below syntax in expression of the textbox =Parameters!MyParameter.Value Note : Replace MyParameter with the name of your parameter. While defining a parameter you specify a value and a label field. If you want to display the label field, then type .Label in place of .Value. 2) If your parameter allows multiple values, and you want to display all the values selected delimited by a comma, use the below syntax =Join(Parameters!MyParameter.Value,",") Hope this helps. Please feel free to discuss if you have any further issues. Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH
March 22nd, 2011 7:42am

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

Other recent topics Other recent topics