.The following fields on the Work Run window are used as follows:
|
Specification |
Description |
|
Use Active Sheet |
When the report runs, it will run into the sheet that is selected on the save of the last |
|
Clear Sheet |
This will delete the contents of the sheet before the report data is entered into Excel |
|
Append to Sheet |
This will enter the data in the last row after the existing data in the sheet. This is used if we are running the report as part of a consolidated report |
|
No Report Headings |
If the report is being appended to other reports above it, you may wish to suppress report headings, you can do so with this option |
|
No Period Headings |
If the report is being appended to other reports above, it, you may wish to suppress period headings, you can do so with this option |
|
Unprotect before generating |
If the Excel template and worksheet you are running the report into is protected, you can instruct Power Writer to unprotect the sheet and generate the report |
|
Protect after generating |
If the ‘Unprotect before generating’ option has been used, Power Writer can be instructed to re-protect the report after the report has been run |
|
Password |
If the ‘Protect after generating’ option has been used, you can specify a password here |
1.
For the first report in the Work Run, position your cursor in the Clear Sheet
field and select the checkbox .
2. For any subsequent reports, check the Append to Sheet, the No Report Headings and No Period Headings will automatically be checked when the Append to Sheet option is checked.