PT Sterling Tulus Cemerlang
www.sterling-team.com

Whatsapp
+62-877-8655-5055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower Level 30
Jl Jend. Sudirman No. 45-46
Jakarta 12930 – Indonesia

500+ FREE Tips SAP Business One for you to Become SAP B1 Super User from Sterling Tulus Cemerlang (STEM)

Crystal Report : Passing Parameter to Sub Report

SAP-Business-One-Tips-Crystal-Report-Passing-Parameter-to-Sub-Report

When creating a report, sometime we need to use a subreport. Same as the main report, we also need to use parameter in sub report query. And the parameter used for the sub query report is a result from the main report.

Below are some steps on how to use result from main report as parameter for sub report :

  1. Make sure your subquery report is correct and there’s no other parameter needed to be setup.

    SAP Business One TIps - Crystal Report Passing Parameter to Sub Report

    SAP Business One TIps – Check Subreport Query

  2. Return to main report , and then right click in subreport area and choose “Change Subreport Link”.

    SAP Business One TIps - Crystal Report Passing Parameter to Sub Report

    SAP Business One TIps – Change Subreport Link

  3. In the left box, find “Command”

    SAP Business One TIps - Crystal Report Passing Parameter to Sub Report

    SAP Business One TIps – Command Field

  4. Then select which column will be used as parameter (in this example: BatchNum) . Click the selected column and then click on button “>” . Make sure “select data in subreport “ already checked, and then choose column that will be use for subreport (in this example also use “BatchNum).

    SAP Business One TIps - Crystal Report Passing Parameter to Sub Report

    SAP Business One TIps – Select Parameter To Use in Subreport

  5. Click “OK” and it will automatically create a parameter in subreport. If we look at the query, there’s nothing change. But don’t worry because it’s already mapped automatically.

    SAP Business One TIps - Crystal Report Passing Parameter to Sub Report

    SAP Business One TIps – Crystal Report Passing Parameter to Sub Report

Also read:

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang
More details about SAP Business One,
email to: sales-enquiry@sterling-team.com or call +6221-5806336 or wa +6287786555055

, , , , ,