Group sort on formula field

[leftfldr5]

I need a way around not being able to group sort on a formula field.

Here is the layout of my report: 2 tables and Inventory Master and Work Order table with a possible 1 to many relationship.
Item # -- Qty -- Standard Cost -- Ext Cost

The report is grouped on Item # and Ext Cost is Qty * Standard Cost. All the fields are in my group footer and all other sections suppressed. I want to sort the group by Ext Cost, but it is a formula field in the footer and it will not let me.
Please help.

 

[synapsevampire]

Try posting technical infornmation rather than descriptions:

Crystal version
Database/connectivity used
Example data
Expected output

It also sounds like you don't understand what a group is. Groups are automatically sorted, so if you want something sorted by that entity it should be the group, not something else.

So a TOP N report might be what you seek, but I'll reserve advising you until you demonstrate what you have and need.

-k

 

[leftfldr5]

Crystal 10, SQL database, ODBC

Yes TOP N sort is what I need on a formula field.

 

[lbass]

Are you saying that you dragged the detail sections into the group footer in order to show only the most recent value for example? What is the exact formula for extended cost? Does it contain any group summaries?

-LB

 

[leftfldr5]

I am gathering quantity records in the detail section and then have a summary by item number in the group footer. I then taken that sum quantity and muliple it by a static cost number to get extended cost, which makes extended cost this formula:
( {IV00101.STNDCOST} * Sum ({SVC06101.QTYSOLD}, {SVC06101.ITEMNMBR})
I would know like to do a TopN sort by extended cost.

 

[lbass]

Create a command (database->database expert->your datasource->add command) which looks something like this:

Select Sum (SVC06101.`QTYSOLD`) as SumSold, SVC06101.`ITEMNMBR`
From `SVC06101` SVC06101
Group by SVC06101.`ITEMNMBR`

Link the command to your table on the item number field. Then in the report, create a formula {@extcost} to be placed in the detail section:

{IV00101.STNDCOST}*{Command.SumSold}

Right click on {@extcost} and insert a maximum on {@extcost} at the item number group level. This maximum summary will now be available for a topN/group sort. Even though {@extcost} will be the same as the maximum of {@extcost}, you need to do the inserted summary in order to make the group sort available.

-LB