Group - Sort on Detail Field - Then Group Again 1

[dunkyn]

I need to group on a field, then sort on a detail field, then group on additional fields.

Problem is this...it defaults to grouping, then sorting.

So, my output appears as

ABC Bond 9-22-2005
GHI Bond 3-01-2001
XYZ Bond 12-31-2003

Grouped on the asset name (which is required, but I want to sort on the expiration date and then group on the name of the asset) ?

GHI Bond 3-1-2001
XYZ Bond 12-31-2003
ABC Bond 9-22-2005

Any suggestions?

 

[lbass]

Group on expiration date (Group 1) and then on asset name (Group 2). You can suppress the header and footer for Group 1 so that the group isn't obvious.

If you are adding the group on expiration date (and have already grouped on asset name), go to report->change group expert->and use the arrow key to make expiration date the higher order group.

-LB

 

[dunkyn]

thx

 

[synapsevampire]

Or just modify your existing group to:

totext({table.date},"yyyyMMdd&quot+{table.asset}

You can then just use the {table.asset} alone for display purposes if need be.

-k