In the reports wizard ability to create simple reports by SQL query

[ovchinnikovsp]

Motivation

Major part of the reports consist of just one band loaded by the native SQL query(very similar to the admin tools SQL console), so it would be good to have an ability to easily create such reports using wizard

Solution

Modify the report wizard the following way:

1. First step
   1. Move Report Type section before the Entity field
   2. Add another Report Type - Simple report by SQL query
2. For the type Simple report by SQL query user have to specify the SQL query
   1. Aliases or table columns are used as a headers

[mariodavid]

Hi, i recently stumbled upon that fact as well. I think one of the main implocations is that without the wizard, the user also has to manually create the template file, which is not the most intuitive thing to do e.g in excel with the named ranges and so on.

I guess the column selection isn't possible through the wizard, because cuba does not really know about the structure, but at least the template file generation could be provided.