Do you mean to sort your report by the (group footer 2 formula) column ?
Have you used the same formula to specify the grouping for group 2. if yes, then you can specify the sort in Grooup Options.
*************************
Pradeep Kumar Gupta
Data Warehouse Consultant.
pradeep.gupta@wipro.com
If you want to sort the groups by a summary value (such as sales by region etc.), then you need to use the TopN expert.
Not only does the TopN expert allow you to answer questions such as 'Who were my top 5 sales people this month?' or 'Who were my bottom 10?', if you don't specify an 'N' value, all groups will be shown sorted by the summary value. Steve Phillips, Crystal Consultant
In Detail I have 2 columns of data (monthly prints)
actual agreed
21324 60000
32456 60000
45678 60000
34567 60000
I need to sort on the data based on AvActual - AvAgreed
I get an error saying must be evaluated later.
If actual and agreed are normal database fields you should not have a problem.
The error suggests either the fields are NOT database fields OR you have included the 'WhilePrintingRecords' clause in your formula (you probably don't need this).
Another reason for the error is if these values are sumary values rather than database values.
Does any of this help? Steve Phillips, Crystal Consultant
My doubt: AvActual - AvAgreed (OR average of actual minus average of agreed) will be constant value. How can you sort on a constant value ?
AvActual and AvAgreed values will be calculated after all the records will be printed and therefore sorting is not possible on these values.
You may try couple of other options. Like
1) Try passing AvActual and AvAgreed value as two other columns from the data source. This may require writing a view etc. Then on the report you can make a formula field like (AvActual - AvAgreed) and sort on this formula.
2) Calculate AvActual and AvAgreed values on the main report and pass these values in a sureport. The sub report then can be sorted on (AvActual - AvAgreed)
-PKG *************************
Pradeep Kumar Gupta
Data Warehouse Consultant.
pradeep.gupta@wipro.com
I will take a wild guess that you are trying to rank groups (not details) based on the difference between two subtotals. If so, the trick is to write a formula that takes the difference between the actual detail fields (not the subtotals) and then subtotal this formula. You can then rank the groups using the TopN feature.
If this is way off, then tell us the formula used for these two fields. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.