• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

Which declared variable should I use in a crystal report?

I'm working on a report that has that has part #'s and other associated data with the part #.  Some of the parts#'s are also associated with another part and we call that the master part.  For example:
Part 123 is the master part.   Quantity to produce is entered as zero.  
Part 124 is a member part of Part 123.  Quantity to produce is 1000.
Part 125 is a member part of Part 123.  Quantity to produce is 2000.

Part #123 does not have an order quantity.   But part # 124 and 125 do.  I'm trying to add the quantities of part 124 and 125 together and reference back to Part 123, but declaring a variable.  We can't enter a quantity for 123.  What declared variable do I use- while printing records or while reading records.  I would like the report to show "Part 123 Quantity to produce = 3000".

In my table, I have the master part # set up as a field for the member parts.  I can suppress the quantity of 124 and 125 by looking at my table and if the master part # field is not null.  
0
sfrisk
Asked:
sfrisk
1 Solution
 
mlmccCommented:
Two ideas.

First link the table to a copy of itself on
Table1.PartNumer = Table1a.MasterPartNumber

Select records where MasterPartNumber is null.

You can then group by PartNumber
Display the subparts and use a summary to get the quantity for the masterpart.

The second idea.
Use a subreport to calculate the quantity for the master part thenn return the value and display in the group footer

mlmcc
0
 
sfriskAuthor Commented:
mlmcc - Both are better approaches than what I was thinking.  It should work and do what I need it to.  I'll try it tomorrow when I get back to that project.  Thanks for all of your help, you sure know your stuff!!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now