Unlike other types of queries, Reports can be based on multiple object types at the same time. Reports thus make it possible to retrieve and present information from several tables in the database in one and the same result. This means that individual entries in the results window can contain a compilation of data from several different objects, and not just single objects as in the other query types.

Reports are predefined selection queries created in SQL or Java by Digpro and/or by the system administrator. This means that you as a user can only run and use the results of reports, not create new ones or edit existing ones.

 

Generate a report

1.Select Tools > Query Tool.

2.Select the Reports tab..

3.Select the desired report.

4.Enter one or more selection criteria in the text boxes next to the field names. Text boxes in pink are mandatory and must be filled in.

5.In the drop-down list Result as, you can choose to display the result of the report in the form of a Table/Tree or write the result directly to a File, for some reports you can show the results in a Chart.

6.Press Search. The result of the search is displayed in the results window.

 

Show result as Chart

1.In the drop-down list Result as, select Chart.

2.Press Search. Dialogen Visa diagram öppnas.

3.Select your desired options and press Show. The chart will be displayed.

 

More information

You can select which columns to display. Press the arrow at the far right in the table's header row and select or deselect columns. This way you can customize the report for your specific purpose. See section User interface > Tables.

If the report contains coordinate data, such as the dpPower report Stations with coordinates, you can choose to save the result as a GPX file. It can then be read into external programs or into a GPS device.

See section Troubleshooting reports and its subsections for descriptions of various troubleshooting reports you can use.