SSRS hide/view columns
Hi all, In ssrs , in multivalue param , i have 1 to 14 , if i click on 14 th item i am getting 14 item +1 st item and 4 th item by using tablix properies -> visibility , is there any functionality once i click on 14 , only 14 needs to display Pl do the needful , thanks
October 17th, 2012 6:36am

Hi SubaChids, Based on your description, it seems that there is a multi-value parameter in your report, and you specify the visibility of a report item based on the value selected form the drop-down list of the parameter. Currently, we cannot get much information about your requirement and the design structure of your report. Can you share a screen shot of the report structure and the expression you used to control visibility with us? So we can try to reproduce the issue. If you just want to filter the report data based on the parameter, you can try to add a filter to the dataset, and specify the filter equation as follows: Expression:=Fields!your_field.Value Operator:IN Value:=Parameters!your_parameter.Value For more information about add a filter, please see: http://msdn.microsoft.com/en-us/library/ms156270(v=sql.100).aspx If I have any misunderstanding, please let me know, and post your requirement with more details. It will benefit for us to do further analysis. Regards, Fanny LiuFanny Liu TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
October 18th, 2012 11:31pm

I am making a few assumption but selecting only 14 from your multivalue parameter and having 1, 4 and 14 set to visible indicates that the parameter type is set to Text and that you are using a statement like: =IIf(InStr(Join(Parameters!MultiValue.Value,","), [TableNumberString]) > 0, False, True) Where [TableNumberString] is a string representation of a number from 1 to 14, such as "1", "2", "4", or "14". If the only value selected from the parameter is 14 then the above formula, when run for one of the tables (say table 1), translates to: =IIf(InStr("14", "1")>0,False,True) Since "1" is the first character of "14" and "4" is the second and "14" begins at position 1 then the InStr formula will return a value greater than 0 for all 3 of these tables and they will be displayed. What I do to eliminate this type of false positive is add a comma (,) before and after the joined parameter values and before and after the value being compared as follows: =IIf(InStr(","+Join(Parameters!MultiValue.Value,",")+",", ",1,")>0, False, True) Now if you select only 14 from the list the InStr is looking for ",1," in ",14," and will not find it. Likewise for table 4. In fact the only match it will find is table 14 (",14,"), which is the desired result. Should you select 5 and 14 from the parameter then the parameter string will be ",5,14,". So it will match only on the 2 tables that are expected. Please let me know whether this fixes your issue. If not, please share the exact formula you are using to toggle visibility of the tables. Out of curiosity, is this the blog post you based this approach on? http://www.bidn.com/blogs/mikedavis/ssis/816/ssrs-hide-or-show-some-or-all-columns-on-a-report
October 19th, 2012 12:53am

u can find my full requirement here pl http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/ea3c5e31-44c3-4dfa-be77-3aeed1552dd3 thanks
Free Windows Admin Tool Kit Click here and download it now
October 19th, 2012 3:23am

Hi, You can use this useful link "hide/unhide columns in ssrs report" for your problem's solution as: http://praveenpoosapati.blogspot.com.es/2010/10/hideunhide-columns-in-ssrs-report-while.html Regards Vishal
October 19th, 2012 4:31am

Some other usefull link: here the columns are hiding on the base of parameter's values: http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/4089fd69-c44c-486c-a46f-28b058a916f2 http://theruntime.com/blogs/thomasswilliams/archive/2008/09/29/hiding-and-showing-columns-based-on-a-parameter-in-reporting.aspx and this is a sample report project, you can download it: http://www.codeproject.com/Articles/11254/SQL-Reporting-Services-with-Dynamic-Column-Reports Regards Vishal
Free Windows Admin Tool Kit Click here and download it now
October 19th, 2012 4:35am

thanks tim
October 19th, 2012 5:10am

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

Other recent topics Other recent topics