One of the nicer features within Toad® for DB2 is the wide array of reporting capabilities. There is a constant requirement for managerial level reports that need to be run on a regular basis. Many of these reports are generating using reporting tools like QMF, Crystal Reporting, etc. Toad’s data reporting facility provides an easy method for generating professional report templates which can be saved and reused. I will take you through an example of building a custom data report.
The first step is to build the desired query. You can do this through the query builder, or SQL editor. In my example I built a simple join of the sample department and employee tables through the query builder option.
Once you are satisfied with your query, right click on the results grid and select:
“SEND TO/Data Report Designer”.
This will open up the report design wizard.
Select the desired columns for the report
Select desired grouping
Select the desired layout
Once all the basic formatting questions have been answered the report designer will then be displayed. The designer allows you to make custom headings, page breaks, column headings, etc.
Once you r formatting is complete, select the preview button to see the finished report:
The report templates can then be saved and put into the project manager for later reference. Toad for DB2 provides a low cost easy to use alternative to other 3rd party report generators.