suppress the row if has all columns as zero

[unknownly]

Hi All,


How can I suppress if all the columns of a row returns zero. I tried to do this in format section and in suppress X+1 Iam checking for
col1 = 0 and
col2 = 0 and
col3 = 0 and
col4 = 0

It does the suppress but what if I have grouping and subtotals and only one detail row in the group the subtotals show all zero.

Here is the ex: of what it looks like
Number Name col1 col2 col3 col4 //page heading
group1, group1 description
group2, group2 description
aaa aaadesc 0 0 0 0
subtotal: group2 0 0 0 0
total: group1 0 0 0 0

So, when I do the suppress it looks like this

Number Name col1 col2 col3 col4 //page heading
group1, group1 description
group2, group2 description
subtotal: group2 0 0 0 0
total: group1 0 0 0 0

How can I do a suppress( the whole group) if the group returns only one detail row.

Hope, you guys get what Iam try to say...you know.

Any help Greatly Apperciated


Thank you,

Sweetie

 

[bdreed35]

The same way you suppressed the detail section except you use the summary fields:

Sum ({col1}, {group2}) = 0 and
Sum ({col2}, {group2}) = 0 and
Sum ({col3}, {group2}) = 0 and
Sum ({col4}, {group2}) = 0

Add this to the conditional suppression for both the Group 2 Header and Group 2 Footer.

~Brian

 

[MJRBIM]

Format the GROUP HEADER and GROUP FOOTER sections to supress where the Sum of the colums by group looks like this --->

Sum ({Table.col1}, {Table.Number})= 0 and
Sum ({Table.col2}, {Table.Number})= 0 and
Sum ({Table.col3}, {Table.Number})= 0 and
Sum ({Table.col4}, {Table.Number})= 0

 

[unknownly]

Thank you. It works!

I was so stupid that I was doing the suppression same way as in detail and it was mess.

Thank you,

Sweetie