Welcome, Guest. Please Login.
05/11/24 at 14:03:10
News:
Home Help Search Login


Pages: 1
Send Topic Print
Counting lines in a BOM with Crystal (Read 656 times)
ndemarco
Browser
*


DBA all the way (ok,
with EVO and Lynn's
help!)

Posts: 46
Gender: male
Counting lines in a BOM with Crystal
04/05/04 at 19:53:26
 
Hello all,
 
We are working on a report to show the number of line items in a bill of materials. Although this sounds easy, we are getting tripped up.
 
We are using a Running Total field to count the number of records. We are using grouping for each item's BOM.
 
If we put the RTotal field on the Group line, it always shows up as 0.
 
If we put the RTotal field on the Detail line, it doesn't reset, instead keeps counting up and up throughout the list of Items.
 
Ideas?
 
Thanks!
 
Nick
Back to top
 
 

Analogix, Inc.
Innovative Products for Research
  IP Logged
sharon krewson
Ex Member



Re: Counting lines in a BOM with Crystal
Reply #1 - 04/06/04 at 05:44:59
 
Try putting your Rtotal in the group footer.  
 
I tried it and this is how I set it up:
 
Group by Parent;
Summarize by component with Count as the type of Summary;
Evaluate for each record;
Reset for each group
Back to top
 
 
  IP Logged
ndemarco
Browser
*


DBA all the way (ok,
with EVO and Lynn's
help!)

Posts: 46
Gender: male
Re: Counting lines in a BOM with Crystal
Reply #2 - 04/07/04 at 05:25:59
 
Thanks! I'm giving it a try today...  
 
Regards,
 
Nick
Back to top
 
 

Analogix, Inc.
Innovative Products for Research
  IP Logged
Pages: 1
Send Topic Print