The Crystal Reports software is used to analyse business information and create standard or custom reports. It is capable of building the reports from any data source. The built-in formulas and cross-tabs allow to present the important relationships between the different sets of data. The sum of the data values at the intersection of the columns totals and the row totals is used to add a per cent and grand total column to your Crystal Cross Tab report.
- Skill level:
- Moderately Easy
Click the "Start" button in the Windows and select the "Crystal Reports" from the "All Programs" menu.
Select the "Open" option on the start page, click on the file you want to edit and then click the "OK" button to open your report.
Click the "Design" tab on the navigation bar.
Click the "Cross-Tab" option on the "Insert" menu.
Drag the Cross Tab object into the report when an object frame appears with the arrow cursor.
Place the object frame in an empty area in the "Report Header" and click the "OK" button to put an empty Cross Tab in your report.
Right-click the "Cross-Tab" object and select the "Cross-Tab Expert" option from the shortcut menu.
Select and drag the group names and field items to the Rows area in the "Cross-Tab Expert'.
Select a summarised field on the "Cross-Tab" tab and then click the "Change Summary" button.
Select the "Show as percentage of" option, and choose the summary field you want to base the percentage on.
Click the "OK" button to close "Crosstab Expert". Right-click on the "Row Grand Totals" and select "Totals on Top" to place the subtotal fields below the row cells values.
Click the "OK" button to add a per cent and grand total column to your Crystal Report.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for