sort order

[unknownly]

Hi All,

In my report I have group by on Account type
Which has

ASSET
Exp.
Liab.
Rev.

Based on the on the account group as a parameter
Balance sheet or Income sheet

For balance sheet
Account type groups and sort as Assest first and then
Liab.

For Income statments
Account type groups and sort as Exp. first and then Rev.

But my user wants to see Rev. first and Exp. later

How can I do this sorting when the Parameter is input as Income statement.

Thanks in advance

Sweetie

 

[lyanch]

Create a formula to do the grouping on.

@Group:

if {?Parameter} = "Income Statement" then
if {AccountType} = "Rev" then 1
else if {AccountType} = "Exp" then 2
else 3 // in case of a data mistake
else if {?Parameter} = "Balance Sheet" then
.......



Then use @Group to group by. You will want to use the actual Account type to display and not the group name.

Lisa