Selecting an option will finalise the Report Wizard. When you do so you will see that the report is “Checked – Out”. This prevents changes being made whilst you are working on the report template. Excel will then open with three worksheets; Report, Base Data and Report Information.
You can get to work using all the familiar Excel functions immediately using the full array of charting, graphing and analysis tools that Excel has to offer Any changes made to this template will be pulled through into your chosen output when the report is run in future. Please note that the csv output is a flat text file and does not support images, graphs or formatting. Any worksheets that are not hidden will be output when the report is run from the Reports menu.
Once you are finished with your amendments, save and close the Dynamic Spreadsheet template. Locate the report in the CIPHR Report Designer home screen and Check-In the template.
You can edit the template at any time by Opening the report, or change the fields available by Editing. Log out of CIPHR and back in again to see the report now available in the Reports menu.
We recognise the importance of a consistent look and feel to your documents and reports. We can help with the branding of your reports by incorporating logos, formatting reports with defined fonts and colours and creating style templates to fit with your brand values.
For more information please contact our Service Delivery team by emailing firstname.lastname@example.org.