Hi,

I am working on a report which shows New, open, Closed Tickets by Priority as below.

I have used a group by priority and placed in group header and want to suppressed group which has all the values as 0's ..example for priority 4 all values are 0..I used a condition for bottom border so that it will display line to last group
IF GroupNumber = DistinctCount(Command.Priority) THEN crSingleLine


Now problem is when last group has all 0's. it will be suppressed and bottom line will also be suppressed.

How do I display bottom line for the group which is priority 3 in this case?
----------------------------------------------------
|By Priority               New     Closed     Open|
|None                      1        0        1   |
|1                         0        0        3   |
|2                         0        0        2   |
|3                         5        1        59 |
|4                         0        0        0   |
----------------------------------------------------

Thanks in advance
Jyothi

Edited by Jyothi Yepuri - 11 May 2009 at 6:27pm

Thanks for the reply.

Thanks DBlank. Working fine.