Switch to: V9V8V7V6V5

Valentina Reports Features

This section describes features of Valentina Report engine, which is located in 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 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 report to a locally attached printer

You can use command line parameters to write bat/bash scripts, which control Valentina Studio for the purposes of generating reports.

Datasources

Valentina Reports supports report generation from 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 supports report generation from local databases available on Windows, Linux and macOS.

  • Valentina DB local files
  • SQLite local files

Your Valentina Reports engine based product does not have to be installed on the same computer or have the same operating system as the computer on which the data source is available.

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 meta data, with records of 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 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:
    • Report
      • pre_build
      • post_build
      • pre_add_page
      • post_add_page
      • pre_print
      • post_print
    • Control
      • pre_place
      • post_place

Sub-Reports

  • Report can have one or few sub-reports
  • Map by fields
  • Map by parameters

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)”

See Also

The Valentina Reports engine is integrated across multiple Valentina products.