SSRS 2008 Conditional Visibility of Top Group
I am converting from 2005 to 2008 and have a report that does the following and is not working:1. User selects a parameter denoting how they'd like to view the report (B or R values).2. If "B" then hide the top group and show the second group and allow expanding into groups 3,43. If "R" show top group and allow expanding into groups 2,3,4When I select "B", it does not work, show's nothing other than the header/footer of the table. When I select "R", it works correctly.Any insight?
July 29th, 2009 10:04am

Hi dustin,From your explaination, you have 4 groups. The only different between selecting B and R is B will hide top group (group 1) whereas if other than B is selected (R), it will show all groups. Please make sure, select the whole group 1 header line, and at visibility hidden property, you put expression like:=iif(Parameters!Option.Value="B", True, False)You should have all those other toggle item set for expanding group 3&4. HTH.Chicagoan ...
Free Windows Admin Tool Kit Click here and download it now
July 29th, 2009 10:15am

You have read correctly. The other groups aren't shown, however they will be drilled into. I have tried "Row Group" visibility and then just selecting cells...nothing has worked. I will try to post the code I've got in place.
August 3rd, 2009 11:25am

OK, here's what I have...Group 1 Hidden Code:=IIF(Left(Trim(Parameters!spGroupingID.Value),1) = "B",True,False)Group 2 Hidden Code:=IIF(Left(Trim(Parameters!spGroupingID.Value),1) = "R",True,False)
Free Windows Admin Tool Kit Click here and download it now
August 3rd, 2009 3:40pm

Anyone else doing conditional visibility? It seems that there are 3 places where you can set visibility and toggle on a table. No combo is working yet. I can't believe I'm alone on this one!
August 4th, 2009 11:48am

Dustin, did you find a solution to this? Please help!
Free Windows Admin Tool Kit Click here and download it now
July 19th, 2012 9:19am

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

Other recent topics Other recent topics