Crystal

Fundamentals- JobAid
Section 6: Using Link Button and Subreport

At the conclusion of this exercise, you will be able to:
Enhance „Using Highlighting Expert.rpt‟ report by creating Link
Button and a subreport.
Link button for Business Partner Master
On-demand subreport to display order details
Load & Preview this report into SAP Business One menu using 8.8
Crystal Reports Integration Features

You want to create a crystal report using Link Button, Subreport features and Preview this report in SAP Business One 8.8.

1.

Launch Crystal Reports 2008 for SAP Business One

2.

From your recently viewed reports, open „Using Highlighting Expert.rpt‟.

3.

Go to „Design‟ View.
Manually insert the Link Arrow icon graphic into the Crystal Reports layout.
Note: During workshop, download linkarrow.JPG from „File pod‟ to your local computer.
Click Menu Insert -> Picture

Select the linkarrow.JPG file that you have just downloaded.

Ensure you insert the linkarrow just before CardName in detail section. Move the position of all other fields towards right accordingly so that linkarrow could be inserted before CardName.

4.

Right-click the linkarrow graphic and select Format Graphic.
The Format Editor window opens.

On the Hyperlink tab, in the Website Address field, enter the following string: http://$b1$/link?table=OCRD&key=C20000 5.
Click the Formula button

to the right of the Website Address field.

The Formula Workshop – Format Formula Editor – Hyperlink Text window opens.
In the work area, enter the following string as shown below:
'http://$b1$/link?table=OCRD&key='+{ORDR.CardCode}

Click Save and Close to exit Formula Workshop.
Click OK to exit Format Editor for linkarrow graphic.

6.

Increase the height of Detail section.
Click Menu Insert -> Subreport

Click on the radio button “Create a subreport with the report wizard”.
Enter report name as “CR-8.8-Subreport-OrderDetails”
Select the checkbox “On-demand