fmReports - General Reports Section
By each report name you can identify its purpose and information it contains. Comparing reports' data allows you to see if you need to make any changes in pricing or description.
For some reports you need to specify the report dates before the report is generated.
Once you open the report, the following options are available: print, save, see the report outline, thumbnails, choose page settings and edit page (report).
There are also numerous export options available. You can save current report as an image file, PDF file or a table and open it later using some application. This can be a big help when it comes time to fill out your tax report, since you can import it directly into an Excel spreadsheet
There are many ways to customize a specific Report. Just go to Edit page by clicking corresponding icon. There you'll see "Designer's" toolbar, “Standard” toolbar, “Text” toolbar, “Frame” toolbar, “Align” toolbar. Check User's Manual to get a complete description of this page.
General reports section contains lot's of standard Shopping Cart reports. Among them:
To Select and View Report, just Click on it once and in the Products count Window enter the records count to be displayed or in the Report Time Period Window select one you need and press ok.
At the report page, which is opened after you select the report, this report can be viewed, saved, printed or edited with the help of toolbar.
From this page you can export current report to PDF, HTML, Excel, RTF, BMP, GPG, TIF, DIF etc formats.
There's also Edit page option that allows to edit report data and its layout in Fast Report Designer (Text font, size, color, alignment, etc.,framing options can be selected).
In case you'd like to change some field contents in Fast Report Designer Window, double-click on it to get the Memo screen. Please note that any of these changes made to a specific report will not be saved as a template change. To edit one of report templates you have to 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 its template) in order to be displayed. To customize data for a report you have to modify its .sql files. SQL files are stored in \Application Data\eMagicOne Store Manager for X-Cart\Reports\SQL sub-folder Report can use one or more .sql files whereas one .sql file may be used in one or more reports. As for example all General reports are very similar 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 "".