Include group headers where no detail exists..... 1

[robmason10]

Report shows system down times and is grouped by Critcal, desireable and low-impace - these three fields are included as group headers - I would like it so that these headers are shown even if the detail for the group is blank?

 

[synapsevampire]

I'd create a Main report which does a distinct select of all of the Groups, and then use a subreport linked by the groups to pull back filtered data (I assume that you do have the values in the database, the problem is when you filter the rows).

-k

 

[robmason10]

That'll do nicely - was getting confused as I had already bult the main report - some restructuring to be done now. Tx

 

[Ngolem]

this is tricky since no details means no records...hence no group header.

However me might be tricky about this if you only have 3 possible headers of Critcal, desireable and low-impact

Ok we are grouped on this field with these possible values

let us consider several cases

1) No Critical (sp) details

In the Group header divide it into sections

Section (A) of this header put in a fake header...ie all the information you would expect for the header except hard code the field where you would normally put the Group Name to be "Critical" and leave an appropriate amount of space where details would have gone (for appearance sake)...or better yet put some text indicating no records.

In the conditional suppress for this section put the formula

whilePrintingRecords;
onFirstRecord and {Table.Group1value} = "Critical";

2) No Critical or Desireable records

Do the same as in (1) in a Group header (B) except hard coding the field "Desireable" and changing the conditional suppress as follow:

whilePrintingRecords;
onFirstRecord and {Table.Group1value} = "Desireable";

3) we won't address Low Impact being missing as well since there would be no data at all and this would never be executed...if this is a possibility this would have to be done in a report Page header for all 3 values

So You would put your Normal Group 1 header in Group Header 1 (c)


now we address missing data in the middle of the report

In the Group 1 footer we divide it into subsections as well

4) Critical Data but no Desireable data

Again...rig up a copy of what you did in 2) and put it into Group footer 1 (a)

in the conditional suppress for this section put the formula

whilePrintingRecords;
NextisNull({Table.Group1value}) OR
(
{Table.Group1value} = "Critical" and
next({Table.Group1value}) = "Desireable"
);

4) Critical Data or Desireable data and no Low Impact

In Group footer 1 (b) create a fake Group footer for Low Impact as you have done for the others.

In the conditional suppress for this section put the following formula

whilePrintingRecords;
NextisNull({Table.Group1value}) OR
(
(
{Table.Group1value} = "Critical" or
{Table.Group1value} = "Desireable"
) and
next({Table.Group1value}) = "Low Impact"
);

I think that will do it....Tis is really only feasible for situations with a small number of possible senarios....you can see this becoming quite awkward if there are lots of potential missing data groups


Jim Broadbent

 

[Ngolem]

SV - much better than my approach and more general Don't know what I was thinking....I guess It was because of the limited possible missing values

Jim Broadbent