Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sort Formula Fields

Status
Not open for further replies.

nag999

Programmer
Apr 16, 2003
33
IN
Hi ,

I am calcuating the forumla fields which is as below,

@totalvalue={orderdetail.quantity}*{orderdetail*price}

I want to sort on the formula field @total value for each order.How can I do it in crystal?

Any help is really appreciated.

Thanks,
Nagaraj
Aqua Regia Technologies.
 
On the menu, click [Report] and select [Sort Records]. Your formula should be there as an item to select.

I assume Crystal 8.5, versions matter and it's useful to state it so that no one recomends a solution that your version of Crystal does not have.

Madawc Williams
East Anglia
Great Britain
 
Hi ,

This below formulas are working fine and I could sort on such formulas.
@totalvalue={orderdetail.quantity}*{orderdetail*price}

The only problem is when i have a formula which is having summary information in the formulas it is not coming in Report > Sorting. Is there any why we can evaluate these formulas before printing on crystal report?

Thanks,
Nagaraj
Aqua Regia Technologies.
 
To sort on summary formulas, use the TopN/Sort group expert.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
dgilsdorf@trianglepartners.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top