Preview Reports

The Preview Reports function in the Report Menu combines the current capabilities of the existing sales database report screens in the DDMS system with the new functionality of the SQL EBS database. It is designed to allow both new and experienced users to easily view and print SQL reports. It also allows users to make minor report changes on the fly that could previously only be made in more complex report designer applications. Information is displayed in an Excel-style grid with columns that can be fully customized using sorts and limits.

 

The first standard group of cataloged sales reports is included with the DDMS/EBS Version 8.13 software installation. These print from their respective SQL tables. For example, the sales reports print from the current SQL SalesOrderJournal table and related supplemental files. The report definition files are saved as an XML document and placed in the ddms/reporting/eci2 folder during software installation.

 

Custom reports can be created and saved using third party software, Component One (C1) Report Designer. If you create additional reports, you save them in the ddms/reporting/custom folder. The Preview Reports function lets you catalog and provide security for your reports. See the Advanced SQL Reporting handout on our website for more information on creating custom SQL Reports.

 

For more information, see Using Preview Reports.