Hello Sabine, Derek.
For those who want a simple page to print with a choice of columns and some customization options.
New version of the program New V1
Features (currently):
- the ability to work with any MVD features for the Report: SQL query (Script) for ONE TABLE, Button action Report, Button action Report SQL.
You can send all columns to the Report.
- Select columns for printing (Report).
- Changing the order of columns (Report).
- Change alias of columns for printing in Report. (Report) DblClick on the fields.
- Possibility of auto-numbering lines. Requires column name "Line" in script or via calculated field (in MVD). See example.
- Select page orientation (Report).
- Simplified display of columns on the page in the preview. (Report)
- Out-of-print warning. (Report)
- Changing the size of columns and intervals in FastReport. (Report) Columns words auto wrap.
- Editing the form header in FastReport. Change text, font size and style (Bold).(Report)
- Automatic conversion of Dates in SQLite format to regional format (Report).
- page footer with page number (Report).
! Version under editing. Remarks and comments are accepted. !
Errors are possible.
In the future, it will be placed in the Reports section.
P.S. In the example, both options work (script SQL (old) and MVD Report (new) ) through the new version of the Report.
To showcase the possibilities. The MVD Report version removes duplicates (DISTINCT), the list is shortened.