Group specified on non-recurring field

[rrrdavis07]

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:

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

 

[kray4660]

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.

 

[hilfy]

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

http://www.decisionfirst.com