Former Member

### Get Data from SubReport

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.

Thanks

10|10000 characters needed characters exceeded

Former Member
Jan 14, 2015 at 04:32 AM

I think the below links are useful to solve your query

Create share Variable logic

Passing values between reports in Crystal Reports 2008

OR

simply create another report and then add as a subreport on main report

Regards,

Nilesh