Valentina Reports Features

This section describes features of Valentina Report engine, which is located in the VREPORT DLL. This DLL is included into all Valentina ADKs, Valentina Studio PRO and Valentina Server.

Visual WYSIWIG Editor

Valentina Studio PRO provides Report Editor to visually design Reports. You can use these reports in your desktop or web applications.

Free Report Viewer

Valentina Studio has a Report Viewer included in the free Valentina Studio. You can use Report Viewer to

OPEN existing Valentina Project (*.vsp) files.
CONNECT to any supported data source for the report.
specify parameters to get records (Parameters are set up in Valentina Studio Pro but usable within Valentina Studio).
specify parameters to generate a report (Parameters are set up in Valentina Studio Pro but usable within Valentina Studio).
PREVIEW reports within Valentina Studio.
EXPORT reports into supported formats, such as PDF.
PRINT a report to a locally attached printer.

You can use COMMAND LINE PARAMETER to write bat/bash scripts, which control Valentina Studio for the purposes of generating reports.

Datasources

Valentina Reports supports report generation from the most popular database servers available on Windows, Linux and macOS.

mySQL Server
mariaDB Server
MS SQL Server
PostgreSQL Server
Valentina DB Server (a component of Valentina Server)
Valentina SQLite Server (a component of Valentina Server)

Valentina Reports support report generation from a local database on Windows, Linux, and macOS

Valentina DB local files
SQLite local files

Your Valentina Reports engine based APP can connect to a data source on another OS and another computer over the Internet.

Report ADKs

All Valentina ADKs (except V4MD) provide native (fastest) classes/methods to work with Valentina Reports.
Other programming languages and OS can use REST access.

Export Formats

PDF
- Contains TEXT as TEXT. You can select it and copy-paste.
- XML embedded as metadata, with records of a cursor that was used for report

HTML
Picture (JPG/PNG/GIF)
Latex

Printing

LOCAL APP printing to LOCAL printer(s).
CLIENT APP printing to LOCAL printer(s).
CLIENT APP printing to Server printer(s).

Report Properties

Variable Paper Formats
- Standard Formats: ISO-A, ISO-B, ISO-C, North American, JIS, Architectural, PA series, …
Columns
Gutter - space on left/right side of the page
Margins top/left/right/bottom
Maximum number of records/pages to generate

Report Scripting

Script Languages
- JavaScript - custom scripts are executed by embedded JavaScript engine (Google V8).
- SQL - allows execution of arbitrary SQL commands in the datasource.
Script Kinds:
- for a Report:
  - pre_build
  - post_build
  - pre_add_page
  - post_add_page
  - pre_print
  - post_print
- for a Control:
  - pre_place
  - post_place

Sub-Reports

Report can have one or few sub-reports
Map by fields
Map by parameters
Recursive Reports, [v10.5.2]

Multi-part Reports

Starting with v9.5 you can build Multi-Part Reports combining a few different reports into the single one.

Regions

Report Header
Report Footer
Page Header
Page Footer
Column Header
Column Footer
Group Header
Group Footer
Body

Сontrols

Primitive Controls (Line, Rect, Ellipse, …)
Database Field Control
Label (Static Text) Control
Picture Control
HTML Control
Sub-Report Control
Chart Control
- 2D/3D Views
- Styles: Area / Bars / Lines / Pie
- transparency
- Perspective
- Splines
- Parameters: fonts/colors/size/borders/…

Barcode Control
- Aztec
- Code 11,
- Code 128
- Code 128 (Subset B)
- Code 16K
- Code 2 of 5
- Code 2 of 5 Interleaved
- Code 2 of 5 IATA
- Code 2 of 5 Data Logic
- Code 2 of 5 Industrial
- Code 2 of 7 Codebar
- Code 32
- Code 3 of 9, Extended
- Code 93
- DataMatrix
- Deutsche Post Leitcode
- Deutsche Post Identcode
- Flattermarken
- Han Xin
- ITF-14
- LOGMARS
- EAN
- EAN-128 (GS1-128)
- EAN-14
- ISBN
- MSI/Plessey
- NVE-18
- PDF417
- MicroPDF417
- PDF417 Truncated
- Pharmacode One-Track
- Pharmacode Two-Track
- PLANET
- POSTNET
- PZN
- QR and Micro QR
- Telepen Alpha
- Telepen Numeric
- UPC A
- UPC E

Text Fields:
- Text Field
- Page Number Field
- Total Pages Field
- Time Field
- Date Field
- DateTime Field
- Records Field
- Total Records Field

Evaluation of expressions. Start with ‘=’, e. g. “=price1+price2”

Macros:
- $(record) – current record number
- $(page) - current page number
- $(pagetotal) – page count
- $(date) – current date
- $(time) – current time
- $(datetime) – current date and time
- $(weekday) – current weekday
- $(monthname) – current month
- $(day) – current day
- $(month) – current month
- $(year) – current year
- $(hour) – current hour
- $(minute) – current minute
- $F(fieldname) – insert field value
- $P(parameter_name [=default_value]) – define parameter, which later can be changed from App Code.
- Examples: “$(page) of $(pagetotal)” “Field ‘Age’ value: $F(Age)”

As of Valentina Studio Pro 9.6.4 the use of macros has been depreciated and replaced by JavaScript (or SQL) expressions.

Table of Contents