SQL configurable reports

SQL configurable report scheme settings

​​ 1. Click "Settings" to enter server settings

​​ 2. Enter the plan name casually

3. If the original color scheme is empty, it represents a random color.

​​ 4. Double-click the "Setup Plan" label to save the plan. At the same time, a folder with the same name will be generated in the directory where the program is located (adding "--" before the folder name will not take effect).

5. Refer to the example to set up the configuration file (.ini) and SQL statement (.sql)

SQL configurable reporting software features

​​​SQL statements and configuration file settings:

​ ​ 1. Open the configuration folder in the program root directory.

​ ​ 2. “1=1” must be added to the Where part of the SQL statement

​ ​ 3. The configuration file supports up to 8 text box controls + 2 date controls. The file box controls can be increased or decreased at will according to actual needs, but the last 2 can only be date controls. For example: 0+2, 8+2 are both acceptable.

​​ 4. If it is not needed, you can add a "--" comment in front, and it will not take effect.