Having run the report you will see that you now have an additional spreadsheet added to your workbook. This is important as it helps to understand how the Extension works and how we can customise the way the report looks.
Changing the Area Above the Table
When the report is run the template sheet is copied and renamed "Report" it is then filled with the data. Therefore any changes you make to the template sheet will be present in the report sheet once you have run the report.
You can try this now by changing any of the cells ABOVE the table area and then regenerating the report.
Once you have selected all the headings that you require you can also hide this row (row 9 in the screenshot above) and include client friendly headers on the row above (row 8 above)
Changing the Area Below the Table
The area below the table is treated in a different way to the data above the table. With this section of the report the Extension will copy the formatting and contents of the second row down for all the rows created in the report. This is illustrated in the diagram below. You will see that the first row does not have any formatting applied to it
Therefore any formatting changes that you wish to apply to the whole grid must be applied to the second and first row of the data table on the template sheet. This may seem a little con-fusing initially but the system has been designed so that when you add equation columns you can have a different equation on the first row.
All cell formatting will be copied down, including any conditional formatting.
Adding Equations to the Data Table
Adding equations columns into the data table can be done following the two simple steps:-
- Add text to the header cell so that the program can refer to the column in its interface
- Add the equation to the first and second row of the grid.
The example above shows how you can modify the SPT template to include a column for the level of the SPT reading (ground level - depth). When the report is run you will see that this equation is copied down in the same way as all the other formatting.
Adding Project and Company Data
The data that can be returned to a report table does not include company or project information. This can be set up using a separate menu option as detailed below:
To insert project information into a report follow the steps below:
- Select the cell to add the project information to
- Select the required Project parameter from the Insert | Project menu as shown below.
- Repeat for all project fields.
- When the report is generated the cell(s) will contain the selected project parameters as shown below.
To insert company address information into a report follow the steps below:
- Select the cell to add the company information to
- Select Company Address from the insert menu as shown below. When the report is generated the company address defined in the OpenGround Cloud configuration pack will be added to the selected cell.
To insert template images to the report follow the steps below:
- Select Template Image… from the insert menu. The Insert template image form will now be displayed with the templates images that are included with the current configuration pack.
- Click on the required image and click Insert
- The image will be added to the sheet and can then be resized and positioned as required. This image will be updated every time you run the report depending on what images are stored in the configuration pack.