Finite Groupings

[ProgressiveJL]

Hi All,

CRXI

Just wondering if it's possible to setup finite groups which would display the group names regardless of whether the database contained records for that group.

 

[synapsevampire]

They aren't groups unless there's data.

To fake a heading, right click the group section and selec insert section below.

In the lower section, create a formula of:

whileprintingrecords;
stringvar array MyList:= ["one", "two", "three"];
Stringvar Output:="";
numbervar x;
numbervar y;
for x := 1 to ubound(MyList) do(
if {table.field}= MyList{x]
and
MyList[x+1] <> next{table.field} then
for y := x to ubound(MyList) do(
if {table.field}= MyList{y]
and
MyList[y+1] <> next{table.field} then
Output:=Output+MyList[y]+chr(13)
);
);
left(output,len(output)-1)

Replace ["one", "two", "three"] with your group names.

Now in the suppress formula of this new section create a formula of:

{table.field} = next({table.field})

should get you close...

-k