Summarizing by Product Type multiple line items

[Mikerla]

Newbie to Crystal Reports 11.5 with Epicor 905

Here is what I am trying to do.

I have an Order file which will have multiple Line Items each having a dollar amount per unit and a weight as well as a quantity. We drill down past the Product ID to assign products to Product Code Types. The Product are assigned to a Product family ID's which are "F" or a "P".

I have been able to Sum up the line items by $ and lbs with the same Product Code Types by Order Number but I would like to also Sum by Product Family ID's (F & P) per order by $ and LBS.

Any Suggestions?

 

[lbass]

You should be able to use conditional formulas like this:

if {ProdFamilyID} = "F" then {table.amt} //or {table.lbs}

Then assuming you have a group on order, right click on the formulas (placed in the detail section) and insert sums on them at the group and/or report level.

-LB

 

[MCuthill]

Mikerla,

If I understand your description correctly, you should create a group on Product Family, then a second group on Product Type Code. You can then create Summaries of all the necessary fields on each group.

The above should look something like this with finished:

Group 1: Product Family
-- Group 2: Product Type Code

F
-- Code 1
-- Code 2
-- Code 3

P
-- Code 4
-- Code 5

Hope this helps!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[Mikerla]

@MCuthill

Thanks for the response

I have that going on just as you have it but I need totals for all the $ & LBS for the "F's" and for the "P's" followed by the individual totals for the Product Code Types for both the F & P.

I get a result buy my F only has the first line item totaled and my P has the total for all the Product Code Types.

Make sense?

 

[MCuthill]

@Mikerla,

Can you please provide some example of data from your database and/or report? I am not sure I understand the data structure. Is a Product Type Code assigned either an "F" or a "P"? From your reply it would seem that all products are assigned to "P".

Thanks,

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."