How Hide Colum Headings

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!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.
"Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
news:uUv6jhD$EHA.2788@.TK2MSFTNGP15.phx.gbl...
>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!
>