fmCustomReportsForm, fmReportEdit

Custom Reports

Store Manager allows you to work with a third-party program (Report Tool) for report developing and editing.

Check User's Manual to learn more about this tool.

Our program gives you an opportunity to select one of the proposed variants of custom reports or create your own.

Go to main menu, choose tab Reports - Custom reports . There is a list of embedded reports.

Custom Reports List

You can delete , edit, rename created ones. If you want to look over the report, click the 'Show report' button .

Let's consider a simple example of creation your own Report.

In order to create a new report you should click on the appropriate button - and specify the report name in the form which appears.

Create new report

Then you should build one or more SQL queries. You can open the saved file with SQL queries (1) or create new one - click ‘Visual Query Builder’ button to simplify this task (2):

Visual Query Builder

There are tables of your database on the right side of the window (1). Choose necessary tables and click twice on them with your mouse(2). Selected tables will be moved to the left side (3). Check necessary rows of these tables.

Visual query builder will create SQL queries itself (4).

Visual Query Builder form

You can add to your queries an additional term (aggregate, sort type, grouping etc) in the table below. All your additions will be displayed in the SQL queries at the bottom of the window.

Table in Visual query builder

In order to check your generated queries, press the appropriate button in the top of the window.

Run Query

On the Result page tab, you can see data, which the query has returned.

These results can also be exported to Excel by hitting "Export to Excel" button.

When you're done, click OK button.

Report Designer - the second step of your report creation.

After you've created a query(ies), the report layout can be designed.

Design report

First of all, you should select data, which will be used in the report.

Select dataset

Go to Report →Data →check necessary dataset → press OK. Your data will appear on the right side of the window. The basic objects, you'll most likely need to work with are the “Band” and “Text” objects.

“Band” object allows creation on a design page, of an area, which has definite behavior, according to its type.

“Text” object displays one or several text lines within the rectangular area.

Choose necessary bands from the designer toolbar. You can select from the drop-down menu such bands as Report Title, Page Header, Master Data and Page Footer.

Report bands

Every band has its own meaning. Report Title consists of a title name of your report, Page Header - names table’s or list’s columns, MasterData attaches to database and contains with data, that will be displayed in the report, 'PageFooter' consists of current date and page number.

Text object

Choose from the toolbar 'Text object' and moving the mouse cursor over the page, click again.

The object is inserted at the mouse position. The text editor window will be opened right away;

if it does not appear automatically then double-click the object by mouse. Type report name in the ' Report Title' band and then click "ОК" button.

Report title

In 'Page Header' band via text object, you can assign title names in your table data.

Page header

In order to attach your dataset, you should double-click by mouse in the area of 'Master Data' field. Such window will appear:

Master data

Now choose text objects and set data, that will be appearing in the Report as a table in the following way:

Master data band

and do the same with the other text objects.

Master data band2
System object

You can assign a current date and page number to your report. Choose 'System text'

-from the toolbar and the "System Memo" window will appear. Select [DATE] from the drop-down of 'System variable' field.

Choose 'Master Data' in the 'Data Band' field and your dataset in 'DataSet' field, then click "Ok".

Page footer

To assign page number you should do the same as in the previous example, just select except Date [PAGE] value. The report design is finished. To preview the report either select the “File>Preview” menu item or click the corresponding button in the toolbar.

Preview report

The preview window containing the report page with the attached data will appear. This report can be printed out, saved to a file (*.fp3), or exported to one of the supported export formats.

Order Report Development

In case you need to design your own reporting document with the specific data in it, press the upper option in the Reports tab and you will get to the Reports Development page, where the appropriate report design can be ordered.

Order Report Development

The report's price may change depending on the complexity of the request, so it would be better to contact us before ordering the service and specify all your requirements and interesting questions.

By eMagicOne Inc.