How to export data contained in printed reports
A little known feature of the HWeb Admin Report module is that there are multiple ways to “print” the final or displayed report.
Print to PDF
Print to CSV
Print to Paper
While printing to paper may be the most common, it is often desirable to either send the document electronically to an email distribution list or to view the raw data and perhaps remove some of the information displayed or modify the report layout. Additionally, exporting the raw data can allow you to take the results from multiple reports and compare them side by side in a spreadsheet application or run additional calculations on the data. Saving as raw data is also a great way to archive or store information that you may want to retain for future use.
To make it easier to select from the printing options available to you, you should first enable “Print Preview” mode. This mode allows you to view your document on the screen before it is sent to a printer. To enable “Print Preview” mode:
1) Launch HWeb Admin application
2) Select “Options” from the title bar and then click “Print preview” to select. (If there is already a check mark displayed next to “Print preview,” then Print Preview mode is already enabled.)
Proceed to run the desired report and press the “Execute” button when the report parameters have been set. The report engine will generate the data and then open a display window showing what the report will look like if printed to paper or as a PDF. In the top left most corner of the print preview display window is the word “File.”
Use your mouse to click this option and you then are presented with your printing options:
Save as a PDF file - PDF stands for Portable Document Format. It is a common reporting format supported by many other applications. Depending on your use of PDF’s they may be locked to prevent further editing or they may be sent to people who have PDF editing capability for further adjustments and refinements. There are many PDF reader applications that may be obtained online for free. When you select the Print to PDF option, the Hudson application will open a network browsing window and allow you to browse your local computer and perhaps your network resources and allow you to select the location to save the document as well as the document name.
Save as a raw CSV file - When selecting the raw CSV option, your document is saved in a very simple Comma Separated Value format. In this situation, all report data can be opened and viewed as raw text, with each value separated from the next by a comma. CSV formatted files are often very small in size and are ideal for storing large amounts of information. While CSV formatted documents may be viewed with most any text editing application (ex: MS Notepad or Word Pad) their true value comes when they are opened and viewed with most common spreadsheet applications (MS Excel, Open Office, etc.). To view raw csv data in a spreadsheet, you can usually either open a spreadsheet application first and then follow the instructions to “import” the CSV document, or you can alternatively right-click on the CSV document icon or file and select Open With, and then select the spreadsheet application on your machine. When you select the Print to CSV option, the Hudson application will open a network browsing window and allow you to browse your local computer and perhaps your network resources and allow you to select the location to save the document as well as the document name.
Print - The print option will send your document to your connected network printer. You may have the ability to enable additional printing controls locally such as double-sided printing, color, grayscale, fast draft, multiple pages per sheet, etc. These are typically controlled by your local printer interface.