In our last tip, we showed you how to save a copy of your Excel workbook to file when running a report. If you’d like to catch up on it, then take a look here. Did you know that in addition to saving your reports in an Excel format, you have the option to run a report out to PDF? This gives you a convenient format to view and share with your counterparts. To do this, follow these steps.
1. Once in the Report Manager, choose the report you would like to work with.
2. Then, under the Properties tab, make sure the option “Show Advanced” is checked (at the bottom) – this will display the advance properties for the report.
3. Scroll down to view the “Generate Output File” option for the report.
4. Click the ellipses to the right of the field to specify the location of the output file you want to save. A new dialogue will open for this.
5. Now, after navigating to the location you would like the report saved in and giving your report a name, append “.pdf” to the end of it as the file extension. Previously, you may have used “.xls” or “.xlsx”. I have called mine “Monthly sales report – @[email protected]”, making use of the @MONTHNAME@ system variable to include the month the report is run in the name.
6. Next, click Save to close the dialogue and you can now run the report. When you do so a PDF copy will be saved to the location you specified and opened automatically at the same time.
Remember that if you don’t need to work with the Excel workbook, you can check the “Close Book on Completion” option under the reports properties to have the workbook close automatically after it is finished running out.