Switch to: V10V9V8V7V6V5

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 ($199) provides Report Editor to visually design Reports. You can use these reports in your desktop or web applications.

Free Report Viewer

Starting with v6.4 you have Free Report Viewer as part of free Valentina Studio. You can use Report Viewer to

  • open existing Valentina Project (*.vsp) files,
  • connect to any databases
  • specified queries to get records
  • use that queries to generate report
  • preview report
  • export report into supported formats
  • print report to paper

Datasources

  • mySQL/mariaDB Server
  • postgreSQL Server
  • SQL Server
  • Valentina DB Server
  • Valentina SQLite Server
  • Valentina DB local files
  • SQLite local files

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