Figure 38. New row for Total Field
Figure 39. Insert sum of AnnualSalary field
To insert the summary field , select the AnnualSalary field in the dialog , select
Calculation function ‘sum’ from the drop down list and check the ‘On Grouping’
checkbox. Click on ‘Insert’ button.
Next you should format the ‘AnnualSalary’ and ‘sum AnnualSalary’ fields to match the
salary data format of Crystal Reports. Double click on the text form field
‘AnnualSalary’ to open the ‘BI Publisher Properties’ dialog. Select formatting type as
‘Number’ and format as ‘$#,##0.00’. You can edit this format manually to include any
new format. Add a ‘Text to display’ label, which is just a label name to this text form
field. Follow the same steps for ‘sum AnnualSalary’ text form field.
Converting reports from Business Objects Crystal Reports to Oracle BI Publisher Page 36