Report Generator
Report Generator
The Report Generator allows the user to extract specific field contents from the project database which is summarized as a flat table and can be printed directly as a PDF document or exported into an EXCEL file for further analysis. Operators frequently use the Report Generator to hand out a daily, weekly or monthly report that is focusing on the total length of the inspected sections.
To open the Report Generator click on Printing > Report Generator:
The Report Generator window will open offering the option to produce PDF and Excel reports:
In the first row, use the tab buttons Section, Inspection, Observation and Ratings to display the related database fields which can be selected for a table report (1). Next select the fields (2) that you wish to query for the report as described below.
To create the report, consider each field to be a column in a table going from left to right, and drag the required fields into the Printing Fields boxes in the desired order:
The user can drag queries into the Printing Fields boxes at any time from any of the tabs in the top panel. The colors of the fields in the Printing Fields area shows which tab they have come from:
You can also add a placeholder column with a title of your choice. For example, if you require a column in the exported spreadsheet that may need to be filled in by a user at a later date.
To create a placeholder, right click on the Printing Field and select the option, giving it a name in the process.
When producing PDF reports, there is a limit to 8 fields due to the width of the output paper. However, there is no limit when exporting EXCEL spreadsheets. All the functionalities provided by the Report Generator are listed and described below:
When producing PDF reports, there is a limit to 8 fields due to the width of the output paper. However, there is no limit when exporting Excel spreadsheets. To add more fields, click the PLUS button indicated.
To apply a sort order to the data rows, drag the corresponding field from the Printing Fields to the Sort area. You can apply multi-level sorting and use the Sorting Settings to apply the sorts as ascending or descending.
To clear all of the Report Generator options click this button.
If you wish to open a pre-saved report generator configuration, click the folder icon and navigate to the required (.rgf) file.
To save the current report configuration for future use, click the diskette icon and give the report file a name.
The recycle bin allows the user to drag any options from the Printing or Sort Fields for removal.
The Preview button allows further options for each column in the output including how the data is summarized.
Click the Excel button to output the report to an Excel (.xlsx) spreadsheet.
Click the PDF button to output the report to a .pdf file.
The red cross closes the Report Generator window and clears all current user selections.
Excel and PDF files created in the Report Generator will be automatically saved in the [Project Folder] > Misc > Docu location.
Where a project contains both Sections and Laterals, the table reports will be carried in separate pages of the PDF file, or in separate worksheet tabs in the EXCEL file.
Table reports can also be generated for Nodes in a similar way by ensuring that the WinCan VX main screen shows the Nodes tab activated before launching the Report Generator.