CRXI, suppress duplicate group header/force drilldown

[mgason]

Hi,
this is really a two part question.
1.
how can I have a filed in a group header only appear if it is not the same as in the previous group. basically a suppress if duplicated but for the group header.

2.
I have 4 groups, the last is hidden, drill down OK.
clicking an item in group 3 opens a drilldown to group 4. Is it possible to have it drill down all the way to details without clicking again and opening another page? So all the information is in one drilldown.

thanks
mark

 

[lbass]

1) Place the following formula in the group section (I'm assuming a string field here):

whileprintingrecords;
stringvar curr;
stringvar prev := curr;
curr := {table.field}//whatever field you want to conditionally suppress

Then select the field->format field->suppress->x+2 and enter:

whileprintingrecords;
stringvar curr;
stringvar prev;
curr = prev //note no colon

2) Instead of hiding group #4 and the details section, use conditional suppression on both GH#4 and the details section, with a formula like:

drilldowngrouplevel < 1

-LB