This is a basic beginner's guide to making a report using Kexi 2.2 or newer.
|You may click on the screen shots below to see more detail, and click the "Back" button to return to this display.|
We begin with a table named masterlb shown in data format. In this example, the fields are named author, title, keywords, and so on. Before making a report, we create a query.
Selectcommand from the tab of the main toolbar.
In the view, select the desired table from the combo box and click the button. A box representing the selected table appears with list of field names. Double-click on each field you want in your query.
The query columns will automatically fill with your field selections and with the table name, as shown next.
Let's suppose that, for your report, you want all the records matching NEUROLOGY in the field keywords. Under on the line,type in
'NEUROLOGY'(Enclose the name in single quotes.)
Now, select the button to save your query. You will be asked for name of the saved query; enter
neurology. In the screen shot below, the name of this new query is displayed under category in the far left pane.
Next, to create new report that will display data defined by the query, select thecommand from the tab of the main toolbar.
Click on the tab with database icon, to the right of . You will then be able to select an internal source for your report. The new query will be among the choices. Select it, and press the button.
At this point, before entering your data, you may wish to click button to create a header and other format options:
You may wish to put a label in your header. To do so, click on command from the tab of the main toolbar and then click in the area.
Notice that in theyou can enter your own to replace the word Label. You have many options for formatting the size, position, font, etc.
To enter fields into the body of your report, click on command in the tab of the main toolbar and then click in the section. In the , pressing on the property combo box displays a list of the fields provided by your query. For each field you create in the section, select desired field from the list. This binds the fields on your report to your data.
Again, there are many formatting options. Save your report using the button. Before you switch to data mode, if you have set the data for the first time, you may have to close and re-open the report [this may be a bug that will be fixed in later versions].
When you switch to data mode, you have several options, includingcommand. Your printed report should look great!
Author undisclosed. Text adopted and edited by jstaniek.