Ad Hoc Report

Top  Previous  Next

Ad Hoc Report allows you to quickly create a report from QueWeb GUI. It provides a quick and intuitive way to create simple reports right in any Focus. 

The concept of Ad Hoc report is to use the same Focuses and Forms GUI that users are accustomed with and use in the daily tasks. In order to start the Ad Hoc Report, navigate to the Form from which you will you have to get data for your report. Click on the Ad Hoc Report button in the Main toolbar: 36. You can start creating your report by clicking on 37 icons next to the fields you want to include in your report; selected fields will be indicated by 38 icon. Once finished with fields selection, click on the Ad Hoc Report menu in the User Toolbar. The Report Window will open where you can run your report, save it or export the contents to Microsoft OfficeŠ programs.

Note: You need to right-mouse click on the column in to select it for removal or rename. Left clicking will sort the column.

 

39

Considerations when creating ad-hoc reports:

Column captions in report writer will be the same as the label names that you select for report. If you start in one Form collect all the fields from that Form before continuing to the next Form. You can also change the column captions in Report Writer once it is fully created.
Report Writer uses the relational database and links between the tables to create reports. Once you start adding fields to your report, the system will indicate the fields which cannot be added to the same report, as they dont have any relationships in the database, Ad Hoc report will mark those fields with icon.

Report Writer uses the same concept when using the Grid Counter as used in the system Grid.

You have an ability to save reports after they have been constructed by clicking on the Save Button.