Reports‎ > ‎

How to create a simple type of Report

fmCustomReportsForm
fmReportEdit


Consider creating a simple type of report named, for example, 'Customer's Data'.


1. First of all, press ‘New Report’ button in the top menu of Custom Reports section and specify the name of your new report. Click ‘OK’ button.



Then, create one or more SQL queries to select required data. To facilitate this task, you can use 'Visual Query Builder', which is located on the toolbar in the 'Edit Report' form. 



You may open a previously saved file with SQL queries, by using the appropriate button in the top menu - 'Open Query From File'.



'Visual Query Builder' window (see image below) consists of database tables on the right side(1). Сhoose necessary data on the right (2) and double-click on it or drag and drop it to the left (3).


Check necessary rows of selected tables (4) and visual query builder will create SQL queries based on this (5).



You can add additional items and conditions to these queries in the table below (aggregate, sort type, grouping etc) and all changes will be displayed in the SQL queries at the bottom of the window.


The 'Run Query' button serves to check the correctness of created queries. Press "OК" button if your queries are correct.



Your selection appears in the right pane of the window as a result.


The next tab in the 'Edit Report' form is 'Report Designer'. It allows to design new report on your taste.



Use bands - an area on a design page which behaves according to its type - to create necessary fields of your report. To create a Report of a simple format you should select from the toolbar following


objects or bands as: "Report Title", which contains the immediate name of a report, "Page Header" - headers of report columns; "Master Data"  - attaches to the performed in 'Visual Query Builder' window


dataset and places the data  that will be displayed in the Report; "Page Footer" accommodates the total designation of the page: the page number, the current date, company name and so on.




To enter the desired text in the selected bands you should choose "Text object" from the designer toolbar. Click on the ‘Text object’ 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 theReport Title band and then click ‘ОК’ button.


Using 'Text' objects you can assign names to headings of tabulated data.


In our case, the titles names will be the following: 'Firstname', 'Lastname', 'Email', 'Company name' - are identical to dataset headers.



To attach dataset to 'Master Data' band  double-click the mouse on its area. It calls the 'Memo' window, where you should select the required dataset and press 'OK' button.



In order to numbered customers in your Report you should perform the following manipulations:


1. Select in the 'Memo' window 'Text' tab and choose 'ABC' option by clicking on it with your mouse. This will call an editor's form, where you can choose the 'Variables' tab and on the list that appears select 'Line#' position.


It will be moved to the lower field 'Expression'. Click 'OK'.



2. To attach the following information you should in the similar 'Memo' window, that launches after choosing Text object from the toolbar, click 'Data' tab and select from the list of dataset the required column.


In our case, this should be "Firstname" column. Click 'OK' button. It will be displayed in the 'Master Data' band.




Make analogous manipulations with other dataset columns, in particular, 'Last_name', 'Email' and 'Company'.



To numbered of report pages and place the current date at the end of the page allows 'Page Footer' band.


Choose System text from the toolbar System object  and  in the system memo that will appear, select PAGE position from the system variable, choose Master Data in the ‘Data Band’ field and your dataset in 'DataSet' field,  then click ‘Ok’.




To set the current date you should act as in the previous example just select except Page DATE 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:



We considered the example of creation a simple type of report. If there is necessary to create a more complicated report with complex design, please contact us and we will gladly assist you!

By eMagicOne Inc.

Comments