Following are the excel reporting tools used for Report Development:

1. To fill any value of existing field

${YOUR_FIELD_NAME_HERE}

2. To start records in loop as result of any sql query

${sql@=YOUR_SQL_QUERY_HERE}

3. To end the loop of sql

/${sql@=}

4. To sum the column F4 in loop

$[SUM(F4)]

5. To put formulae with columns F5 and G5

$[F5+G5]

6. Background colour and formating of cells will retain as it is

7. If big number like account number above the length of 14, Microsoft Excel will not be able to handle it as number. It will reduce the length to 14 digit. So need format the cell as text.