Reports

fmReportEditfmCustomReportsFormfmStringDialogfrxPreviewFormfmSendErrorReport

Sub-pages listing:

Store Manager allows you to work with a third-party program (Report Tool) for report developing and editing. You can check the following manual to better understand its functional.

Reports are documentst that contain information on the products, orders, customers movement at your store.

You can preview already built-in report documents in the relevant section of Store Manager, or create your own report. For this you will need some SQL skills.

Each report consists of two main parts:

  • Report template - contains report layout information and places in files of a specific format (.fr3 ).
  • SQL queries - this part, placed in the .sql files, contains queries that will retrieve necessary data from the database required for the report.
Reports parts

In the Reports section of Store Manager there is the list of available reports with the toolbar panel that allows to:

  • Create a new report document
  • Edit (modify) the existing one
  • Remove selected one from the report list
Report toolbar

To modify report click the [Edit Report] button. The form with two tabs will appear:

The first tab - "SQL Editor" - allows to retrieve data from the store database and display it in the report document. In this tab, you can edit created SQL query or replace it with the [Open Query From File] option. To simplify the creation task, launch [Visual Query Builder] from the top panel:

SQL editor

You shuold see the selected database tables with the checked fields in the left pane of the builder form.

Database fields in Visual Query Builder

You can also add the additional terms, such as aggregate, sort type, grouping etc. to the queries. All these additions will be reflected at the bottom of the window.

Additional terms

To verify the query, use the upper option on the top area of the form called [Run Query] and get the results in the tab.

Run query

Press [Export to Excel] to save your creation to a separate file, or click the [OK] button to move to the next step of report editing / creation:

The second tab - "Report Designer" - provides information that should be displayed in the current report document. Data is placed in the relevant boxes called "bands."

The main structural elements for report creating are:

  • Report Title
  • Page Header
  • Master Data
  • Report Summary
  • Page Footer
Report bands

You can add more data in each band using other options from the toolbar panel, such as:

  • Picture:
  • System Memo:
  • Memo:
  • Barcode:

Once you have completed your report design, click the [Preview] button to see how your report looks. You can find it directly in the top toolbar:

Preview option

You can also use the [File] icon to open the menu with the necessary command:

Preview option in a File

To better understand how to create a report press [About] on the toolbar and select "Help Contents..." from the dwop-down:

Help contents option

This option uploads the document with the step-by-step description.

We are glad to offer our help and create Reports personally for you following all your requirements and needs.

Press the option in the "Reports" section to move to the necessary page with the service to get acquainted with possible offerings on report creation and indicate your suggestions by filling the form below in the current window.

Order Report Development

Please contact us today with a sample of your report and we'll provide you estimated time and cost.