January 18, 2012 at 5:19 am
Hi
I am relatively new to Reporting Services 2008 and I have a child group with a footer which I am using for a total, what I am trying to do is hide this footer row if there is only one row in the group. I am using this expression for the child group's footer row "Hidden" property
=CountRows() < 2
It successfully hides the row when it should but it doesn't take up the "slack" if that makes any sense. It leaves an empty line in the report where the total (footer) would have been instead of shifting everything up. My report has 3 hierarchical groups with the footer and the details in the last group.
Is there any way to go about doing this? Not sure how to explain any further without posting a screenshot of the "hidden" footer.
Thanks
Ross
January 18, 2012 at 12:06 pm
My one suggestion would be to make sure you are actually setting the footer row properties rather than the group properties or even a cell property.
January 18, 2012 at 10:28 pm
Sorry this is going to sound stupid, is there some way to ensure I have selected the actual footer row besides just clicking the row selector on the left of the grid?
All I did, and all I thought I could do was just select the row selector (Grey block) on the left of the footer row. That is what I applied the expression to
Thanks for the response
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply