6.Data Formats and Maintaining Totals.

- Number Format,Date Format,Bold Character,Field Browser
- Sub Total and Grand Total
- Running Totals:
- Brought Forward and Carry Forward
- Conditional Formatting
- Setting Limit Records Per Page
- Page Reset

Number Format: To Apply number format as #,##0.00 , provide the default number as 9,999.00 (or) else double click on the text fileds. Go to Add help text,go to

status bar/helpkey.
Select Tyoe Your own and write the following syntax.


Sub Total and Grand Total: Take one summary column inside of the main group end for each.
Place the cusrsor at end of the table,enter,it will create one new row.copy paste the amount field XML tag. Double Click on it,go to add help text,use the sum function

like below.


Or Else

Create New Row place the cursor in the new column-> go to template builder->insert->field->select your column.
Select sum in calculation->click on insert.

To display grant total ->use cummary column outside of the main group.

Running Totals: Before starting the exercise,please go through this points.