PT Sterling Tulus Cemerlang
www.sterling-team.com

Phone
+62-877-8655-5055
+62 (21) 580-6055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower 18th
Jl Jend. Sudirman kav 45-46
Jakarta 12930 - Indonesia

350+ FREE Tips for you from Sterling Tulus Cemerlang (STEM) - SAP Indonesia Gold Partner, and Become SAP B1 Super User

Crystal Report : Passing Parameter to Sub Report

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

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

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

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

, , , , ,