on 01-14-2015 2:58 AM
Dear CR Expert,
I have design a Report with data structure as follow:
COPro Cost Element Value Product Output
P-0001 9000001 $ 100 1,000 Kg
P-0001 9000002 $ 150 1,000 Kg
P-0001 9000003 $ 175 1,000 Kg
P-0001 9000011 $ 200 1,000 Kg
P-0001 9000012 $ 250 1,000 Kg
P-0001 9000013 $ 275 1,000 Kg
P-0001 9000021 $ 300 1,000 Kg
P-0001 9000022 $ 350 1,000 Kg
P-0001 9000023 $ 375 1,000 Kg
P-0002 9000001 $ 100 1,100 Kg
P-0002 9000002 $ 150 1,100 Kg
P-0002 9000003 $ 175 1,100 Kg
P-0002 9000011 $ 200 1,100 Kg
P-0002 9000012 $ 250 1,100 Kg
P-0002 9000013 $ 275 1,100 Kg
P-0002 9000021 $ 300 1,100 Kg
P-0002 9000022 $ 350 1,100 Kg
P-0002 9000023 $ 375 1,100 Kg
P-0003 9000001 $ 100 1,300 Kg
P-0003 9000002 $ 150 1,300 Kg
P-0003 9000003 $ 175 1,300 Kg
P-0003 9000011 $ 200 1,300 Kg
P-0003 9000012 $ 250 1,300 Kg
P-0003 9000013 $ 275 1,300 Kg
P-0003 9000021 $ 300 1,300 Kg
P-0003 9000022 $ 350 1,300 Kg
P-0003 9000023 $ 375 1,300 Kg
Then, I create formula for Activity Grouping and Cost Component based on Cost Element
Activity Group:
If Left(Cost Element,6) = "900000" Then
"Activity-A"
Else
If Left(Cost Element,6) = "900001" Then
"Activity-B"
Else
If Left(Cost Element,6) = "900002" Then
"Activity-C"
Else
"Not Assigned"
Cost Component:
Labor = If Right(Cost Element,1) = "1" Then Value Else 0
Material = If Right(Cost Element,1) = "2" Then Value Else 0
Equipment = If Right(Cost Element,1) = "3" Then Value Else 0
Report should look like:
Activity Group Labor Material Equipment Total
Activity-A $ 300 $ 450 $ 525 $ 1,275
Activity-B $ 600 $ 750 $ 825 $ 2,175
Activity-B $ 900 $ 1,050 $ 1,125 $ 3,075
Total Production Qty = 3,400 Kg
Cost of Production = $ 1,92/Kg
My Question is:
How can I get the Total Production Qty like illustrated above since the data is available on each row of Cost ?
So, for now on, I try to use SubReport to Calculate Total Production Qty but I can retrieve the result for further calculation to get Cost of Production.
Please advice...
Thanks
Hi Adi,
I think the below links are useful to solve your query
Create share Variable logic
OR
simply create another report and then add as a subreport on main report
Crystal Reports 2011: Add an Existing Report as a Subreport
Regards,
Nilesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.