count causing duplicate sections in Crystal XI

[nelsonsk2]

I have a report that pulls information from our MRP system to generate our C of C. We have added a function that counts the total number of shipments then increments that total to generate a C of C #. For some reason the details section is duplicating as many times at the number of shipments (i.e. 13560 shipments then 13650 details sections).

I can find how to suppress duplicate fields but not duplicate sections.

We have a Running total field that counts where {transaction_history.TNXCDE_15}="S" then a formula as shown below:

stringvar x;
x := cstr(count ({Transaction_History.TNXCDE_15}),0);
"ASC0000" & replace(x,",","");

 

[IanWaterman]

Sounds like you have a catesian join. Check your table links and make sure you have completed all relationships between all tables.

Ian

 

[nelsonsk2]

In the case of the count function I don't have the transaction history table linked at all. I don't want the count to only total for the one part so it is counting all shipments.

Is there a way to link the table but then force the count to look at all shipments for all part numbers?

 

[IanWaterman]

Yes you can join table and do a Running Total for the selected Part number and a normal summary caount for all the other part numbers.

Ian

 

[nelsonsk2]

I'm not quite sure how to generate the summary count for all part numbers. Would that be inside my formula using the "AllMembers" function? I've linked the transaction history table and without the all parts count. My count is only showing the total shipment for the one part (=3) but the detail is still printing three times.