Skip to Content
avatar image
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.

Please advice...

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jan 14, 2015 at 04:32 AM

    Hi Adi,

    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

    Crystal Reports 2011: Add an Existing Report as a Subreport

    Regards,

    Nilesh

    Add comment
    10|10000 characters needed characters exceeded