Search
Search

# 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

##### Former Memberreplied

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

0 View this answer in context
View more on this topic or