How can I edit/customize reports?
This article contains general information on how to customize reports in Store Manager.
All reports in Store Manager can be customized, you can change report layout, insert pictures (logos), add and remove fields etc.
Every report consists of two major parts:
- Report template
- Report queries
Report templates are stored in .fr3 files they contain report layout information. Report queries are stored in .sql files, they contain SQL queries to retrieve data required for report.
You can find report files under "Application Data" directory shortcut: Start -> All Programs -> eMagicOne -> Store Manager for ... -> Application Data.
By default Store Manager "Application Data" directory looks like this:
Program has two types of reports:
- Default reports
- Custom reports
These two types are almost identical, the only difference is that custom reports can be modified within Store Manager, you can add new custom reports or remove existing ones, whereas default reports should be modified with external program called Report Tool. You can find Report tool in application program group along with other program shortcuts:
Such reports as Invoice, Packing Slip and Order are default. Default report temlplates are stored in Reports\English subdirectory in .fr3 files:
To edit one of these templates run Report Tool and open appropriate file.
Download User's Manual to learn how to edit report templates.
Remember that every report needs some data (as well as a template) in order to be displayed . To customize data for a report you have to modify its .sql files.
SQL files are stored in Reports\SQL subfolder:
Report can use one or more .sql files whereas one .sql file may be used in one or more reports. As for example Order, Invoice and Packing Slip are very similar reports, and they use the same queries to retrieve data.
To figure out which .sql is used in a report open this report using Report Tool and see fields:
Doubleclick some field to get the following screen:
Entire report field enclosed in square brackets . First part (before dot symbol) is .sql file name where "SQL" is a part of the name replaced with "DBDataSet". Second part (after dot symbol) is field name quoted with "".
For more information on how to edit reports download this User's Manual.