...
Script, category - block in which the SQL query itself is written. Described in section Work with queries;
Tables - block in which report columns are added and configured. Described in section Work with columns;
Parameters - a block in which variable parameters are configured to run the report. Described in section Work with parameters;
Working With Queries
In this block, the user writes a sql query that will have to load data from tables in the database. Queries are written in SQL. User must have basic SQL programming skills to write queries. SQL at a basic level can be learned in the shortest possible time (up to 1 day).
The basic queries required to create basic reports are described in the section Basic SQL queries.
This block of documentation describes possible actions with an already written block of sql code, working with basic queries that are necessary to create basic reports is described in the section Basic SQL queries.
The SQL query code is entered in the "Script, Category:" block:
...
Style All - editing the general style of the report. The process is similar to editing in any other text editor;
Expand by - this field is described in detail in the section Extend By and Group By;
Group by - this field is described in detail in the section Extend By and Group By;
Name - the user sets the name of this column in the report;
Key - indicates what data to pull into the column. For example, there is a request:
SELECT SKU_ID SKU, STORE_ID STORE FROM SALES_SKU
If user puts the STORE field code in the SKU column settings, then the data from the STORE column will be displayed in the SKU column in the report. But this is possible only if one SKU column is displayed, if both SKU and STORE columns are displayed - then adding the field code will not work.
You cannot add a field code to the same field.Data type - selection of which data type should be displayed in the field. The following data types are supported:
Text - for text fields - for example "Article name";
Number - for numeric fields - for example, "Sales volume";
Data - for fields with any date format - for example, "Week of sales" or "Date of sales";
Format - this field appears if you select the data type "Number" or "Date".
Link - allows user to add a link to another page, data or something else. For example, there is a request:
SELECT SKU_ID SKU, SITE_LINK LINK FROM MONITORING
The SKU column displays product codes, and the LINK column displays links to the site. In this case, if user select a link to LINK in the "Link" field in the SKU column settings, then in the report, when user clicks on the number in the SKU column, a link from the LINK column will open.
The link can only be added to other columns;Width - the user can limit the possible field width in the report. The value must be entered in pixels. If the width is auto, then the field will be stretched to fit the text.
Style Сell - editing a separate style for displaying information in the report. The process is similar to editing in any other text editor;
...