Grouping Problem 2

[sim133]

Hi Everyone,
I am trying to develop a report which has different groups. One of my group fields is "OTHER". I want this group to be the last grouping in the report. Is it possible to tell Crystal to print this group at the last?

Thanks
I am using Cristal XII

 

[lbass]

You could either use specified order on the group (report->group expert->options->specified order) or you could add a space before the other groups as in:

if {table.field} in ["A","B","C"] then
" "+{table.field} else
"Others"

Of course this means the alignment of the groupnames wouldn't be perfect.

-LB

 

[synapsevampire]

Try the following formula as the group field:

If {table.field} = "OTHER" then
"ZZZZZZZZZZZZZZZ"
else
{table.field}

Then use the database.field as the display.

It will now Group with your Other field as the last one, yet by using the database.field for display it will show the text "OTHER".

-k