OZ e-Form Developer
  • OZ e-Form Concepts
  • 🌈e-Form DEVELOPER
    • Day 1: Welcome On Board
      • About Course
      • Preparations
      • OZ e-Form Overview
    • Day 2: e-Form Design
      • Designer Environments
      • e-Form Layout Structure
      • e-Form Components
      • e-Form From Documents
      • Preview / Export / Save
      • Hands-on Practice
    • Day 3: Dynamic e-Form
      • e-Form Scripting Guide
      • Hands-on Practice
      • Advanced Features
    • Day 4: e-Form Application
      • Server Deployment
      • Viewer In HTML
      • Viewer APIs
      • Prefilling e-Form
      • Submitting e-Form
      • Sending MemoryStream
    • Get Your Certificate
    • Design Guide
      • Dialogue Flow
        • Overview
        • Creating Dialogue Flow
        • Uploading e-Form to Server
        • Running Dialogue Flow
        • Group and Statement
        • Custom Styling
      • Multilingual e-Form
      • Miscellaneous
      • Videosign
        • Videosign User Guide
      • OZ Verifier
        • OZ Verifier Introduction
        • Implementation and Use
        • Requirements
      • HTML5 Editor
        • HTML5 Editor Introduction
        • HTML Editor
        • Requirements and Sample
    • Day 5. Server & Reporting
  • 🌈Server Developer
    • OZ Server Console
    • OZ Scheduler
      • Features
      • Installing OZ Scheduler
      • Scheduler Task
    • Binding & Exporting
      • Overview
      • Export API Example
        • Extract Input Data
        • Export with OZ Server
        • Export with Scheduler
        • Export with Scheduler Task
    • Repository Server
    • Sync Server
      • Overview
      • Installing Sync-Server
        • SSL configration
      • Sample Application
      • Implementation
    • QR Link Mobile Sign
  • 🌈Report Developer
    • Overview
      • About Course
      • Preparation
      • Report Designer Overview
    • Query Design
      • Database Connection
      • Designer Environment
      • Dataset Design
    • Report Design
      • Designer Environment
      • Components
      • Table
      • Master-Detail
      • ODI Parameter
      • CrossTab
      • Chart
  • 🌈MOBILE DEVELOPER
    • Android Native
    • iOS Native
    • TOTO Framework
      • TOTO Overview
      • Sample App Overview
      • Server Application
      • Android Project
  • ⬇️Product Downloads
  • 📚 Product Documentation
  • 📕Technical Guide
  • ⚛️ ReactJS Integration
Powered by GitBook
On this page
  • OZ Data structure
  • Data Store
  • Dataset
  • ODI (OZ Data Information)
  • Structure of ODI
  • Creating ODI
  • Query design mode
  • Query Wizard
  • Create order.odi
  • 1. Add <order> dataset
  • 2. Add <detail> dataset
  • 3. Create Master-Detail relationship

Was this helpful?

  1. Report Developer
  2. Query Design

Dataset Design

Design datasets with Query Designer to use in the Report Designer

OZ Data structure

Data Store

A datastore is a data repository that supports various data sources. It supports functions such as connecting to a database, defining data, and configuring data fields. The data store types are listed below.

Type

Description

DATABASE

A data source interface to JDBC/ODBC/OLEDB RDBMS, Dataset is defined by SQL.

USER DATA

A data source interface to external data sources like File data(Text, CSV, XML) or data from user applications (EJB, Servlet, ASP, JSP, Stored Procedure).

GROUP DATA

Split a dataset of any data source into multiple datasets by the specified field. GDS is used to reconstruct a dataset into master-detail datasets.

FILE STORE

A data source interface to CSV file or XML file without DTD located on the server (accessed by path)

HTTP STORE

A data interface to CSV file or XML file without DTD located on the web (accessed by URL)

SOAP STORE

A data source interface to the data from web services.

XML

A data source interface to an XML file with DTD/XSD

SAP

A data source interface to data from SAP R/3 RFC.

CLEAR QUEST

A data source interface to the database from IBM Rational Clear Quest program

Dataset

Dataset is a set of data fields selected from a data store. The way to define a dataset depends on the types of data store. Dataset for database store is defined by a query.

ODI (OZ Data Information)

ODI is a file in XML format storing data stores. OZ Report Designer uses ODI to map or bind report forms to data.

Structure of ODI

A single ODI file can have multiple data stores and one data store can have multiple datasets.

Creating ODI

Query design mode

Mode

Description

Design View

Easy way with drag & drop

Manual

Write down or copy query into the query editor

Query Wizard

Generate an advanced query in an interactive way

Query Wizard

Tab

Description

TABLE

Select tables for FROM clause

FIELD

Select columns for a select list

JOIN

Define Join conditions

WHERE

Define WHERE conditions

GROUP BY

Define GROUP BY and HAVING conditions

ORDER BY

Define ORDER BY conditions

Create order.odi

1. Add <order> dataset

Using Query Wizard

Using Manual mode

  1. Menu bar > Query > Design Mode > Manual

  2. Copy the query below to the Query editor

-- order
SELECT orderheader.SalesOrderID, customer.Channel, customer.CustomerName, orderheader.DueDate, orderheader.ShipDate, orderheader.TotalDue, customer.EmailAddress, customer.Phone, address.PostalCode, address.Country, address.StateProvince, address.City, address.AddressLine1, orderheader.PurchaseOrderNumber 
FROM orderheader 
INNER JOIN customer ON customer.CustomerID = orderheader.CustomerID
INNER JOIN address ON address.AddressID = orderheader.AddressID
ORDER BY address.Country ASC, address.StateProvince ASC, address.City ASC, customer.CustomerName ASC, orderheader.SalesOrderID ASC

2. Add <detail> dataset

SELECT orderdetail.SalesOrderID, product.ProductNumber, product.ProductName, orderdetail.OrderQty, orderdetail.UnitPrice, orderdetail.OrderQty * orderdetail.UnitPrice AS Amount 
FROM orderdetail 
INNER JOIN product ON product.ProductID = orderdetail.ProductID
WHERE orderdetail.SalesOrderID = #order.SalesOrderID#

3. Create Master-Detail relationship

  1. Select the detail dataset.

  2. Set the Master Set property to order.

PreviousDesigner EnvironmentNextReport Design

Last updated 3 years ago

Was this helpful?

🌈