Fundamentals- JobAid Section 6: Using Link Button and Subreport At the conclusion ofthis exercise, you Will be able to: Enhance „Using Highlighting Expert. rpt” report by creating Button and a subreport. Link button for Business Partner Master On-demand subreport to display order details ink Coad & 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 rep OF3 p 8. 8. 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 „FiIe pod” to your local computer. Click Menu Insert -> Picture Format Editor window opens. On the Hyperlink tab, in the Website Address field, enter the following string: http://$bl 5. Click the Formula button to the right ofthe 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://$bl

Click and Close to exit Formula Workshop. Click OK to exit Format Editor for linka row 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 subreport (similar to a hyperlink) Click on the Report Wizard to start creating the subreport. 7. Select RDRI [Sales Order-Rows table Click Next Button. Will come back to “Insert Subreport configuration” window. 9. Click “Link’ tab on “Insert Subreport” window. . Select ORDR. DocEntry from the available fields under “Contaner Report field(s) to link to” section and Click 11. button. Place the subreport in the detailed section of the report as shown below. 12. Right Click on the just inserted subreport object and Click “Format Subreport”. Note: You can also Edit Subreport and do formatting as per the requirements. Click on “Subreport” tab. Change Subreport Name to “Order Details”. Click OK 13. Change Report Summary Info: Click File -> Summary Info -> Change Title to “Using Link Button and Subreport” the file as „Using Link ubreport”. 3

Leave a Reply:

O seu endereço de email não será publicado. Campos obrigatórios marcados com *