Groups | Blog | Home
all groups > sql server reporting services > september 2005 >

sql server reporting services : Changing Row Height Question


Shane Eckel
9/19/2005 11:29:03 PM
I have a report of Assets where I let the user decide if they want to group
on the Asset category or not. If they choose a Group from the Parameter
list, the report puts the Asset Category in the Group Header. If they choose
not to group, then it puts nothing in the Group Header. However, this leaves
a blank spot that doesn't look right. How can get rid of the Group Header if
the user selects '<None>' from the parameter list?

The first field in my Group Header looks like this:
=IIF(Parameters!GroupOn.Value = "Asset Category",
Fields!AssetCategory.Value, "")
--
Bismi
9/27/2005 12:02:02 AM
Hi,
Go to the parameters, in the visibility , click on the epression and type
the expression and it will hide accordingly.

OR right click the group,click edit group,click visibility and do the
expression there as well.

cheers

[quoted text, click to view]
Shane Eckel
9/27/2005 11:52:01 AM
Nice, I'll try this right now. Thanks for taking the time to reply to my
inquiry.

Take care,

Shane



[quoted text, click to view]
Shane Eckel
9/29/2005 10:06:08 AM
Thanks for posting this answer, but it isn't behaving correctly.

If I put the expression on the Edit Group level, the entire group hides.
If I put the expression on the textbox, the text within the field hides, but
the row does not shrink.

Any other ideas?
--
Thank You!


[quoted text, click to view]
AddThis Social Bookmark Button