Create an alias field for a formula

[jretoa]

I have a formula :

IF Sum ({p21_sales_history_view.qty_shipped}, {p21_sales_history_view.item_id}) > {inv_loc.qty_on_hand} THEN Sum ({p21_sales_history_view.qty_shipped}, {p21_sales_history_view.item_id}) - {inv_loc.qty_on_hand}

But it does not show as a report field when I am trying to create a group. I want to have the option to sort by this field.

This is in Crystal Reports 9.2

Can anyone help me?

 

[chelseatech]

Summaries are calculated after you group, so that approach doesn't work.

Create a formula of
{p21_sales_history_view.qty_shipped}, - {inv_loc.qty_on_hand}

Summarise that in your group, and suppress the display of the summary.

Then use a TopN of that summary and it whould be close to the value you want to sort the group by.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm