Switch to: V9V8V7V6V5

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

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.

See Also

The Valentina Reports engine is integrated across multiple Valentina products.