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