skip the first record in a group 1

[ultimatewilliam]

my records look like this:

fld1 fld2

Countries AA
USA AA
Japan AA
Australia AA
Cities BB
New York BB
Tokyo BB
Sidney BB

my report must be grouped by fld2. skip the first record when the group has changed because the first record in the group will be used as header. it should look something like this:

Countries
USA
Japan
Australia

Cities
New York
Tokyo
Sidney

any bright idea on how to make this work will be highly appreciated. thanks!

 

[lbass]

Assuming your records will sort in this order, then you can copy your {table.field1} into the group header. Next create a running total {#cntwingrp} using the expert that counts {table.field1}, evaluate for each record, reset on change of group. Then go to the section expert->details->suppress->x+2 and enter:

{#cntwingrp} = 1

-LB