INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Group specified on non-recurring field

Group specified on non-recurring field

(OP)
I'm trying to write a report that will group the results by information that is only available by a Formula. CR is throwing an error stating "Group specified on a non-recurring field" and references the formula I've created. The formula is correct, but does not appear to be a valid formula for the group creation.

The formula is as follows:

CODE -->

if sum({Command.QtyAllocated}, {Command.SAPOrdNo}) = sum({Command.Picked}, {Command.SAPOrdNo})
    then "Picking Complete" 
    else "Picking Not Complete" 

To interpret, the formula is comparing whether the quantity allocated = the quantity picked for each Order Number. The data includes all lines of an order and needs to be summed to determine the status of the entire order. CR seems to have a problem with the sum function. Does anyone have a suggestion on how to create such a group?

Randy Davis
Denver, CO

RE: Group specified on non-recurring field

The real problem is the group is based on a grouped sum which is done after grouping is done. I cannot think of easy solution.

RE: Group specified on non-recurring field

The only way I can think of to do this would be to use a Command, which is a SQL Select Statement. In the query you would do all of the data summarization so that you could determine whether the picking was complete or not. In Crystal, you would then have the information available to do the grouping without using sums generated by Crystal.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year
www.decisionfirst.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close