Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 409
  • Last Modified:

sorting by formula field

My formula is crystal 11:

If Sum ({@Backflushes}, {ARINVT.ITEMNO}) = 0 then 0
else Sum ({@Rejects}, {ARINVT.ITEMNO})*1000000/Sum ({@Backflushes}, {ARINVT.ITEMNO})

Is any way sort report by this field ?

{@backflushe} and {@rejects} don't have any sum inside.

thx

h
0
henryk123
Asked:
henryk123
  • 3
  • 3
  • 3
  • +4
2 Solutions
 
JayConverseCommented:
Sorry, you cannot sort on a formula like that, because it needs to be evaluated after a grouping.
0
 
gavsmithCommented:
Can't you create a group on that formula field and use group sort to decide order?
0
 
mlmccCommented:
You may be able to sort the group on it

Click REPORT --> GROUP SORT EXPERT
If you can when you select the group and then choose ALL the formula will show in the box.

mlmcc
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
GJParkerCommented:
You won't be able to use that formula to sort records or groups in crystal as this is evaluated at print time at the end of the report build and so is not available when grouping and sorting is done.

The only way I have done this in the past is to calculate my summary values using SQL expressions and then use these values to sort with, although depending on your report / db this may not be possible. let me know the following details and I'll try and let you know if this would be possible

What database are you using ?
show the details behind the rejects and backflush formula
show the SQL for your report
0
 
henryk123Author Commented:
not working,

In group sort expert I see only regular sum fields, formula is not visible
0
 
henryk123Author Commented:
- oracle 10
- few more fields direct from database
- no
0
 
GJParkerCommented:
Not suer what your problem is and really don't care but in that case I can't help you and the answer to your original question is NO.
0
 
henryk123Author Commented:
crystal limitations
0
 
gavsmithCommented:
GJParker answered your question

Q: Is any way sort report by this field ?
GJParker - "the answer to your original question is NO. "
0
 
James0628Commented:
It seems like JayConverse deserves at least some of the points, since he said in the first post that it couldn't be done.

 James
0
 
JayConverseCommented:
Forget about it.  Life it too short to worry about points.
0
 
GJParkerCommented:
Ditto JayConverse remarks , however FWIW ....

The original question is - "Is any way sort report by this field ?" which was correctly answered as "no you can't" by JayConverse

The fact that the reqiuestor did not want to investigate any alternative solutions and chose to give up should not alter the fact that experts had taken the time to read and post correct replies, meaning that the requestor has still learnt something from this post which he has learnt from the experts on here.


0
 
gavsmithCommented:
My fault, I missed Jay's first comment when I objected, sorry about that. But you are both right (last couple of comments I mean)
0
 
James0628Commented:
Yeah, it wasn't really about the points.  Just trying to give credit where it's due, and it was, technically, the first correct answer.  If the question is going to be PAQ'd, it made sense to me to include that answer in the solution.

 James
0
 
South ModModeratorCommented:
All,
 
Following an 'Objection' by James0628 (at http://www.experts-exchange.com/Q_26887174.html) to the intended closure of this question, it has been reviewed by at least one Moderator and is being closed as recommended by the Expert.
 
At this point I am going to re-start the auto-close procedure.
 
Thank you,
 
SouthMod
Community Support Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
  • 3
  • +4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now