cuba-platform / documentation

CUBA Platform Documentation
https://www.cuba-platform.com
Creative Commons Attribution 4.0 International
25 stars 45 forks source link

Make "crosstab report" documentation more clear #699

Closed IskandarovRost closed 4 years ago

IskandarovRost commented 4 years ago

Environment

Description of the bug or enhancement

https://doc.cuba-platform.com/reporting-7.2/crosstab_xls.html

1) https://www.cuba-platform.com/discuss/t/cross-tab-report-for-sample-sales-application/12363 Please pay more attention to the report external parameters, as it is absolutely unclear that the following exception occurs due to (${selected_customers}) is missed

image

2) Also add a couple of words about X and Y of crosstab band("orders" dataset): It is not trivial to understand

The orders dataset will provide data for the matrix cells, which is the order amounts sum for the 
particular month and customer. It takes orders_master_data@customer_id (the customer id) as the 
Y-coordinate of the cell, and orders_dynamic_header@header_id (the month name) as the 
X-coordinate, and fills the matrix cell with the amount value.

3) also the SQL queries with month(o.date_) work in hsql (and do not work in Postgres - need to rewrite the query). Mention this fact, or use some another function.