STReport is a software tool for creating, modifying and viewing reports. It is an open source tool developed by Stratebi.
STReport will allow us to handle custom or adhoc reports in an intuitive and easy-to-use way.

When it was initially defined, STReport's main goal was to build a user-friendly solution, especially focused on simple and intuitive management by the end user..

STReport users will be able to define their own reports, re-open them, modify them, save them, export them to different formats, and all of this, without any previous knowledge in programming languages (eg SQL).

The STReport visual layout is as shown in the following image.

In the left frame, you will find the option to Model (Models).
Here is where we are going to select the data model with which we want to work in the current report. For each report, you can only select one data model.

Once the model is selected, the folders and items will appear in the 'Categories' section, which we will explain in the next point.

The toolbar will allow us to interact with the report: execute it, create formulas, etc.

It allows to change the visual aspect of table to report and vice versa.

Manually run the query (the selected items) of the report.

For each change that is made in the report, it runs automatically.
For example, a new element is moved from the 'Categories' to Columns option.

Hide the left frame: Models and Categories, so you only see the body of the report and the elements in Columns, Groups and Filters.

Hide/Show the STReport toolbar.

Lists the filters that are created for this report.

It allows us to create calculated members or formulas that can be used in the report.

Double clicking on the items displayed on the right side (or using drag & drop) will appear in the formula section where we can apply the most usual operators: +, -, *, /. We will select the type of data (generally we will indicate type Numeric). In the Format section we can also specify a mask on the data. If we want that metric to be added, we will indicate it in the Summary section indicating the operator: sum, count, distinct count, max, min, average.

On the left side, there is the 'Function Wizard' that is an assistant that will allow us to define formulas in a simpler way. Important: it is needed to click on the 'Insert Function' button and then the ‘Save’ button.

Displays the statistics (the time spent in milliseconds for the query and the report) when the report is run.

In LinceBI, there is one option called ‘Admin LinceBI’.

A Report is choosen and then an Output Type and clicking on ‘Show Statistics’ detailed information is shown.

Disables the display of elements (fields) that are different.

If any parameter has been defined in the FILTERS section (see the documentation in section 9.3), here you can choose it they will be displayed in execution mode. The options to choose are: NONE, AT HEADER or AT FOOTER.

Represents the body of the report: where are the selected elements (fields) and filters applied. The elements that are in Columns or Groups have an ascending / descending arrow that allows the ordering of the same.
It is divided into three sections that we will explain below.

In this section, we drag those elements (fields) that we want to be displayed in columns.
f we click on the field, we visualize a window where they are going to show different options that can be applied. For example, for a text type field, we can apply:
Hide repeating values and Hide on Report.

If the field type is numeric, we can change the mask of the data, the name shown and establish a aggregation operation at the "summarization" level on this field (possible operations are sum, count, distinct count, max, min, average). This aggregation is applied for each group (for the fields selected in the GROUPS section).

In this section, you can put those fields on which you want to group by.
For example, if we have in Groups: 'Product Vendor', in the report we would be grouped by this field.

It also allows you to set an ascending or descending order using the up / down arrows.

It allows to create and modify filters (restrictions in the values) on the fields here positioned.
To filter, simply click on the field name and the 'Filter on Field_Name' window will open.
Depending on the data type, the appropriate filter window will be displayed.
You can add multiple conditions to the same filter using the operators(AND,OR...)

In the bottom left side, it shows the option of 'Parameter data' that allows generating a new parameter.

One parameter will allow us, when we open the report in Run Mode, to select the values by which it is filtered.

In the right side, the magnifying glass icon shows all the values in the lower part and then you can select them as filter values.
There is also a drop-down that will allow us to select between different ways of making the comparison.

Once the filter has been create, we have to use the arrow keys to move the filter to the right.

In the left part, we will see the conditions that we have created. We can also:

• Add a New
• Remove All
• Delete a condition (x)

It will allow us to scroll through the report, change page settings, justify each field, fill the field, text color, font, etc.

It allows us to move to the first page, previous page, next page, last page.

Nos va a perIt will allow us to create or modify a graphic based on the data selected in the report.

Depending on the type of graphic, choose the corresponding options in 'Bar Chart Properties' and 'Category Collector Properties'. Important to select a measure in 'Value Column'.

It will allow us to align the contents of a field or its title in the report.

It will allow us to fill in the values displayed in the report with blank space.

The following icons allow you to put the contents of a field in bold, italic, underline, change the font color, background color, font, font size.

When a report is opened in Run Mode (Open, Open in a new window), the report will be opened in the same format it was saved under the Display format option, as it is described previously.

On the left side, if a parameter have been defined previously in STReport, in the filters section (Generate parameter), the name of the parameter and the values of the field used will be displayed.

When you select one or more values, the report will be filtered with them.

In the upper side we have the toolbar, which will allow us to navigate through the pages of the report, show parameters, etc.

The following buttons allow us to go to the beginning, go to the page or go to the end of the report.

This button allows us to hide or not the toolbar.

This option allows us to determine the output format of the report: HTML Paginated, HTML, PDF, Excel, CSV.

This option allows us to limit the number of rows that will be displayed in the report:

If in edition mode the option 'Show Parameters' was choosen, here in execution mode the three options are shown where the parameter can be displayed(NONE, AT HEADER, AT FOOTER).

This 'check box' allows us to refresh the values of the report automatically when the parameter value is choosen.