cancel
Showing results for 
Search instead for 
Did you mean: 

Get Data from SubReport

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

nilesh_pawar6
Participant
0 Kudos

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

Former Member
0 Kudos

Thanks Pawar,

It works

Answers (0)