Elixir Report Designer User Manual

Release 8.6.1

Elixir Technology Pte Ltd

All rights reserved.

Solaris, Java and all Java-based trademarks and logos are trademarks or registered trademarks of Sun Microsystems, Inc. Microsoft and Windows are trademarks of Microsoft Corporation.

2013


Table of Contents

1. About Elixir Report Designer
Enterprise Reporting for Web, Print and Mobile Delivery
Look and Feel of Repertoire Designer
Features of Report
Report Security
Working Set
Hidden Files And Folders
2. Report Designer Workspace
Adding a Report Template
Blank Report
Standard Report
Case Study
3. Report Structure and Invocation
Overview
Elixir Report Designer Workspace
Report Structure
Report
DataSources
Page Setup
Sections
Styles
Render Sequence
Parameters
Layout
4. Report Elements
Overview
Colours
Common properties
Types of Elements
Manipulating Report Elements
Selection
Label
Data Field
Data Grid
Image
Check Box
Line
Rectangle
Table
Horizontal Box
Vertical Box
Page Break
Sub-Report
Sub Report example
Barcode
Barcode Types
SVG
Charts
3D
Analysis
Area
Bar
Line
Column
Pie
Meter
Polar
Stocks
Waterfall
XY
Chart Properties
Chart Preview on Workspace
Creating Charts
Creating Dual Axis Charts
Composite Chart
Combination Chart
Multiple Axes
RTF
Cube Table
Cube Table Properties
Header Properties
Measure Properties
Callback
Report Parts
Resizing report parts
Table of Contents (TOC)
Properties
Case Study 1 - Composite Chart
5. Report Rendering and Output Formats
Report Output formats
CSV
DocX
Glint
HTML
HTML-Zip
Image
IML
LPT
PCL
PDF
Print
PS
PPT
RTF
SVG-Zip
XLS
XML
Availability of Renderer
6. Scripting with JavaScript
Overview
Number
Boolean
String
Object
Array
References
Scriptlets
RenderIf
OnRenderBegin
OnRenderEnd
OnLayout
Script Editor
JavaScript Security
Introduction
Steps to protect users from malicious Javascripts
Configure Security Permissions
Verify that Security Policies are Taking Effect
JavaScript Cookbook
Alternating colours
Hiding and showing components
Using parameters to dynamically set values
Accessing Java classes
7. Elixir Report Designer JavaScript Reference
JavaScript API Reference
Elixir Utility Functions
Utility Objects
Data Objects
Raw Report Objects
Logical Report Objects
8. Office Report Template
DocX
Getting Started
Comments
DataSources
Parameter
Scripts
Aliases
Hide Processing Instructions
Formatting
Render DocX Report
9. Elixir Report Designer Migration Guide
Migration Guide
Migration Overview
Template Migration Steps
DataSource Migration Steps
Adding a DataSource
Batch Mode Template Migration

List of Figures

1.1. Set Security Options
1.2. Global Properties - Repository
1.3. Working Set Wizard
2.1. Add Report
2.2. Choose DataSource
2.3. Choose Report Type
2.4. Standard Reports
2.5. Generated Tabular Report
2.6. Generated Columnar Report
2.7. Select Fields
2.8. Label Settings
2.9. Generated Glint Report
3.1. Report Layout
3.2. Report Tree
3.3. Report Properties
3.4. Add Filter For DataSource
3.5. Page Setup
3.6. Section Wizard
3.7. Difference between Sort and Sort (Simple)
3.8. Style Wizard
3.9. Render Sequence
3.10. Render Wizard
3.11. Sample Layout
4.1. Choose Colour
4.2. Named Colours
4.3. Choose Colour (Excel Compatible)
4.4. Borders and Backgrounds
4.5. Sample Data
4.6. Sample Running Sum Report
4.7. Running Sum Output
4.8. Table Wizard
4.9. Select Fields for Table
4.10. SubReport Example Layout
4.11. SubReport Output
4.12. Barcode Wizard
4.13. Barcode Control Source
4.14. Barcode Options
4.15. Positive and Negative Values Positioning with Interval Marker from 10 to 25
4.16. Chart Wizard
4.17. XYZ Axes
4.18. 3D Scatter Chart
4.19. Analysis Chart - Simple Linear Regression
4.20. Analysis Chart - Polynomial Curve Fitting
4.21. Gantt Chart
4.22. Bar Chart without Sub-Category
4.23. Bar Chart with Sub-Category
4.24. Sample Waterfall Chart
4.25. Properties Panel
4.26. Chart Preview Disabled
4.27. Column Chart
4.28. Inverted Data Column Chart
4.29. Dual Axis Chart
4.30. Dual Axis Chart Design
4.31. Composite Chart Type
4.32. Add Subplot
4.33. Sample Cube Table
4.34. Cube Table Designer View
4.35. Shape Tree View
4.36. Measure Presentation Options
4.37. Composite Chart
5.1. Render Wizard
5.2. CSV Options
5.3. IML Options
5.4. PCL Wizard
5.5. PDF Options
5.6. PDF CJK Mapping
5.7. Print Options
6.1. Script Editor
6.2. Generated Report Before Changes
6.3. Additional Scripts
6.4. Generated Report After Changes
6.5. Error logs in Console
8.1. Parameters in DocX Report
8.2. Rendered DocX Report
8.3. Render DocX
9.1. Import Wizard
9.2. Report Elements
9.3. Configure DataSource Wizard

List of Tables

4.1. URL Targets
5.1. Java AWT font types on Window platform.
5.2. Type1 PDF fonts with encoding Cp1252
5.3. List of PDF Type 1 font names
5.4. List of possible encodings
6.1. JavaScript Keywords
7.1. Core Object, Number and String functions
7.2. Date functions
7.3. Format
7.4. Log
7.5. Properties
7.6. Renderer
7.7. Data
7.8. DataCache
7.9. DataCacheManager
7.10. Function
7.11. GroupNode
8.1. Comments
8.2. Formatting Syntax