Formula used as a Group

[crystal28]

I have a field that has multiple values that includes SHIPPED as one value and other values like Cancelled,Not Shipped,Pending etc..,i need to group the report based on this field,with the group being seperated by

"SHIPPED" and all other values combined as one Group..i.e the report has to show rows grouped by SHIPPED and other group should have all rows that have

Not shipped
Pending
Cancelled

etc..

 

[pgtek]

Hi]
create a group base on that field and check keep group together
you will have all the different values listed seperatedly

cheers

pg

pgtek

 

[ianoctdec]

You could create a formula to group on:
if table.field = 'SHIPPED' then
table.field
else
'OTHER'

Regards,
Dana

 

[crystal28]

Thanks for the replies,as far as using the IF loop the problem is in the else section i have to use the same field.

Its like

if table.field = 'SHIPPED' then
table.field
else table.field <> 'SHIPPED' then
table.field

so thats where its going to be a issue,i tried creating a formula and use it to group IF {table.field}="SHIPPED" Then
"SHIPPED" Else "NOT SHIPPED" is what i tried...

 

[MrBillSC]

You can use ianoctdec's formula for grouping. You do not have to use it for reporting. Report the actual data field from your table.

MrBill

 

[raccess]

I also have similar situation. What is ianoctdec's formula?

 

[MrBillSC]

raccess,

see response from ianoctdec (programmer) above.

MrBill