Sage 200 Reporting – Help:
Help and Support
Creating a New Report
You can start the creation of a new report by taking an existing report and then copy and rename it to enable it to be amended or;
You can start a new report by using the NEW option and select an appropriate report structure or;
You can start a new report by using the NEW option and select the BLANK option that will allow the selection of any database tables to build your own SQL Join structure. This BLANK method is useful if the report is relatively simple and requires few joins to related tables and you understand the relationship between the many Sage 200 tables.
Using the BLANK option will require all run time criteria to be defined as none will be automatically added. The NEW report structure option will come with predefined criteria
Click the link above to download this PDF document.
A useful way of understanding how the database table relate to each other is to use the report designer to open an existing report and then select REPORT – JOINS.
The join diagram shows how the tables are related but this view can also be used to show related table. Sect a table and then right-click to display the short-cut menu. Choose the ‘Related tables’ option to view a list of table that can be joined to the highlighted table. Note, this feature only relates to the standard Sage 200 tables and will not display any third party tables. Also, any related table currently within the join structure will not be in the drop down list.