Compare Subtotals Crystal 8.5

[mgrejtak]

I'm using Crystal 8.5 against an Oracle database and have never done anything with subtotals other than display them. Now I need to use some comparision logic to compare the sum of one field at the date level (group) vs the max of another field at the date level. The comparison will be used for suppression.

This version of Crystal does not appear to have an easy way to do this - though I'm told it does in later versions.

What is the quickest, easiest way to accomplish this?

Any help would be appreciated!!!


Thanks!

 

[lbass]

You didn't say what the comparison is, but you would go to the section expert->group header or detail or group footer->suppress->x+2 and enter something like:

sum({table.field1},{table.date}) > maximum({table.field2},{table.date})

If the date group is not based on days, then you would have to add the date condition, e.g., "monthly", after the date field, preceded by a comma.

-LB

 

[mgrejtak]

Thanks for the reply - some additional info:

MaxOnHand (formula field) captures the maximum inventory for an item (aggregate by part by date). This field will not change from date to date within a part - only across parts.

SumNeedQty (formula field) determines the amount of inventory needed (aggregate summary). This value changes per date per part.

Report is currently grouped by Dates of Need (days).

Will your solution still work given that the fields above are formulas and aggregates? I've not seen the syntax you mentioned previously - I'm presuming I would do it in the group header for date.


Thanks in advance!

 

[lbass]

Please try the solution and note that you create the formula in the section expert conditional suppression formula area, and then report back.

I'm not following your description. If you need further help, please supply some sample data that shows how the part relates to the date group, e.g., what is your overall group structure, and when you refer to an aggregate by part by group are you referring to an summary at a different group level?

-LB