Crystal Report - sum field from subreport

Did you add total bar length to the report just to have a number and this needs to be something else?

I don't understand how the profile count is stock profiles required * the profile number

Also you can't count that which has been built yet.  The summary will have to come in the group footer

mlmcc

mlmcc,

I created a report that makes more sense and can be worked with.  For each group, there is a quantity.  I want to total up the quantities of the group per elevation.

For instance, in the first grouping, elevation 4 shows up once.  No matter how many times elevation 4 comes up in that grouping, count that as one.  Now multiple it by the group qty.

My goal would be to have totals for each elevation at the footer of the report.  So the total qty's in the footer should be:

elevation 3 = 5
elevation 4 = 6
elevation 5 = 2
elevation 6 = 4
elevation 7 = 6

Keep in mind too there could be in infinite number elevations.  It's not always going to be elevation 3,4,5,6,and 7.

Cut-List-Totals.rpt

Thanks!

I think you mean an indefinite number of elevations.  The only way this can work That I can see right now is to use an array to keep the counts.  Arrays are limited to 1000 elements so that should be sufficient.

Will the elevation numbers always be integers?

mlmcc

Yes, indefinite :-)   Yes, the elevation name will always be an integer and won't go above 50.  Thank you for your help.

Wait, just to make sure, were you going to help me with that?

I will try to figure out the method

HI mlmcc, just seeing if you might have made some progress on this?

Thanks so much mlmcc.  It looks like you put a lot of work into that.

Thank you.