sql server reporting services: How Hide Colum Headings -- sql server reporting services

How Hide Colum Headings

Mike Harbinger
1/16/2005 6:00:51 PM

sql server reporting services:

I have a report that consists of 4 groups representing 4 levels of grouped
data with separate column headings and no detail rows as follows:

ColHeading 1
Level 1
ColHeading 1.2
Level 1.2
ColHeading 1.2.1
Level 1.2.1
ColHeading 1.2.2
Level 1.2.2

The report always prints a column heading at each level even when no data is
printed at that level. I have tried using the invisibility test as follows:
-Select ColHeading 1.2 row
-Test for existance of first cell in Level 1.2
-Get error that item is out of scope

Can this be done?

Many thanks!

Re: How Hide Colum Headings

Jim
1/17/2005 10:54:37 AM

It's ugly, but if you're using sprocs, you can dump your data to TABLE
variables, then check for the existence of data in subordinate levels, then
update those values in the parent. This isn't particularly elegant, and
it's slower than it should be, but I've had to resort to this kind of thing
with SRS before. HTH.

[quoted text, click to view]