Installation Installing Repertoire Server Headless Mode Server Services System Requirement System Requirement General Information Upgrading Report Server Core ...

A First Report Basic report template includes : 1. Blank 1. Standard Report Tabular Report Columnar Report Mailing Labels 1. Mobile ...

Server API The key concept in REST is the idea that each resource should have a unique global identifier and that operations can be applied to the resource through ...

Accessing Runtime Data If you are embedding an Elixir Repertoire Engine into your application, you can easily access application data from within the Engine. JavaScript ...

Addition and Concatenation JavaScript is a loosely typed language. This means you don't need to define the types of variables, JavaScript will infer them. For example ...

Alternate Colour for Records in the Detail Band This allows the data to be presented with alternate background colors per records. use the following scripts in the ...

Generate Data via Ant Task (Runtime Engine) Write a build.xml, defining the parameters for generating. This will require the Runtime Engine. Code Snippet ...

The following will demonstrate how to map IML and Glint file extension to Elixir Interactive. Note that this information is only valid for version 7.0.1 and below ...

Introduction This is a step by step guide showing how a valid login user to BEA Portal 10 Application, can seamlessly access a resource ( typically a dashboard, report ...

Calling a SOAP Service Because the Object !DataSource supports arbitrary JavaScript, it is quite simple to call any external APIs to obtain data. As an example, here ...

Capturing a Snapshot of Data From Any DataSource The attached User Guide shows how data from any JDBC databases can be saved into tabulated datasource. Capture Snapshot ...

Scripting with Chart To display custom colors for charts: Applicable for : Area, Bar, Column, Pie Code Snippet importClass(Packages.com.elixirtech.chart2.custom ...

For assistance, please contact support or sales at elixirtech.com ChooiKheng 07 May 2007

You should use Click not Select as your action event in !RepertoireServlet. Click is for user actions, Select is only for updating other views. These are currently ...

Component Alignment There are several ways you can do alignment in Elixir Report: 1. Use Up/Down/Left/Right arrows to move report elements by 10 pixels. 1. Use ...

Introduction In certain situations, machines hosting the Elixir Repertoire Server may be behind a firewall that has blocked off access to all ports except port 22 ...

Creating A !DataSource (Illustration) TanDunlin 27 Dec 2005

Creating a JDBC Datasource Java Database connectivity (JDBC) is a standard SQL database access interface, providing uniform access to a wide range of relational databases ...

Creating A Report Template (Illustration) TanDunlin 27 Dec 2005

Custom Java Datastore This is a simple example that dumps the output from the datastore to the console. The documentation that describes the interfaces is in the ...

Creating A !DataSource with Dynamic Parameter (Illustration) TanDunlin 20 Jul 2006

Daily Rolling File Appender This allows the logging(Log4j) to re create a daily .log file and save the previous daily .log file according to it's date. Replace the ...

DataCache A !DataCache object represents a set of records and an index identifying the current record. By default these records are loaded by the DataCacheManager ...

DataCacheManager The !DataCacheManager provides cached access to datasources, so that the records are not read more often than necessary. You can obtain a DataCache ...

Introduction to Greenplum Greenplum Database is actually an array of individual database instances running on different servers or hosts, all working together to ...

DataSource Connectivity with Vertica Database Vertica Database allows the connection by either JDBC or ODBC drivers. Using the JDBC driver will be recommended instead ...

Parameter Lookup Ensemble now supports the ability for scripts to reference other GOs on the diagram. This walk through will work in the next auto build: Create a ...

Dynamic Parameter Date UI The dynamic parameter syntax #{label,type,default} now supports date as a choice. The allowed syntax for the type component is: date ...

Introduction The Repertoire Demo Applet Application is a simple applet application that illustrate how RML templates can be rendered. This application serves as a ...

Introduction The Repertoire Demo Servlet Application is a simple servlet application that illustrate how server resources can be access via the Server REST API. This ...

Introduction This is a update release of the DemoServlet using the Repertoire Server Version 7.2.x. For details of the features and functionality, please see Demo ...

Deploying License Key To run our Product, you will need the valid license key. For assistance, please contact support or sales at elixirtech.com. The license key ...

System Requirement Supported Platforms Elixir Repertoire supports any Java SE version 5.0 Runtime Environment (JRE) update 8 (or later) compliant platforms such as ...

Diagnostic Tips List of actions that can be taken to debug issue encountered Ask yourselves the following questions : Can the report be generated via Elixir Report ...

Drill Down Data for Chart Currently, there is no drill down data for Chart. An alternative solution is to use a group headers to show summarized data, and then output ...

Drill Down Data for Chart Currently, there is no drill down data for Chart. An alternative solution is to use a group headers to show summarized data, and then output ...

Currently, there is no drill down data for Chart. An alternative solution is to use a group headers to show summarized data, and then output HTML with the Tree mode ...

Drill Down on Charts The current version does not support chart drill down. An alternative solution is to use a group headers to show summarized data, and then output ...

Dynamic Columns The samples below show how you can allow users to specify the columns they want to see and the columns will be shown in their report/dashboard accordingly ...

Dynamic Content This sample demostrates how to render different sections based on different values. During the rendering stage, the Render If script will run. The ...

Dynamic Meter Intervals From version 7.2 onwards, intervals within a meter can be dynamically determined based on the minimum and maximum values retrieved from a table ...

Working with Dynamic Parameter (Datasource, Report) SQL query is the part where a range will be defined to specify the report request. Example : Select from employee ...

Rest API The key concept in REST is the idea that each resource should have a unique global identifier and that operations can be applied to the resource through a ...

Elixir Cookbook The Elixir Cookbook is a collection of working 1. Report Templates 1. ETL Composite Datasources 1. Dashboard Templates 1. Schedule Jobs ...

Elixir Ensemble Ensemble Cookbook JonPriddey 10 Jul 2005

Repertoire Data Designer Data Aggregation, Extract Transform Load (ETL) and OLAP Cube transformation http://www.elixirtech.com/graphics/Posters/ElixirEnsembleSmall ...

Elixir Perspective Information Dashboard for Navigating and Visualizing Enterprise Data http://www.elixirtech.com/graphics/Posters/ElixirPerspectiveSmall.jpg ...

Elixir Perspective Cookbook Miscellaneous vs. "Select" in RepertoireServlet ZhuBo 12 Mar 2007

Repertoire Data Designer Repertoire Report Designer Repertoire Dashboard Designer

Installation Version 5.x Specific Version 6.x Specific Version 7.x Specific Non Windows Headless Mode Windows Server Services What's New What's new for ERS 7 ...

Elixir Report Report Cookbook JonPriddey 10 Jul 2005

Repertoire Report Designer Enterprise Reporting for Web, Print and Mobile Delivery http://www.elixirtech.com/graphics/Posters/ElixirReportSmall.jpg Report ...

Elixir Repertoire Server Cookbook Getting Started System Requirement Installing Report Server Upgrading Report Server Basic Information (Docs, API, Library) Configuration ...

User Manuals Elixir Repertoire Includes : Elixir Choreographer (EC) Elixir Report Professional (ERD) Elixir Repertoire Server (ERS) Elixir Repertoire ...

Sample of Regulat Expression ( ^\ )\ \s( ^\s )\s( ^\" )\"( ^\s )\s( ^\" )"\s( 0 9 )\s( 0 9 ). Apply on access.log file: ( ^\ ) // characters up to ...

Excel Limit Below are some main metrics for Microsoft Excel: Microsoft Excel 7.0 (95) Maximum Sheet Size : 16,384 rows by 256 columns Column ...

See .FileAttachment

FileSystem DataSource 19/04/2005 It is a simple datasource to allow you to generate reports, charts or capture data about parts of your filesystem. For example, ...

Using Filter Processor Filter processor is a tool with which you can manipulate and group the database records to filter out those records which meet specific criteria ...

Fine Tunning Elixir Server The time taken for report generation depends on various factors such as the report complexity, type of datasource, generation format and ...

Font Mapping for PDF Format Physical fonts need to be installed in locations known to Java Runtime Environment. Users can add the physical fonts that use a supported ...

Formatting of numbers in Excel output When we pass in a field of double, float or integer type into Excel, Excel ignores our formatting and treat it as a number without ...

How do I install Use the jar! JonPriddey 12 Jul 2005

Frequent Asked Questions This collection of frequently asked questions (FAQ) provides brief answers to many common questions about Elixir Report Professional (ERP ...

Headless Mode (Unix System) Running Elixir Server without a monitor, mouse or keyboard. In unix environments, it usually means that X or an equivalent windowing ...

Hiding Components You can hide components in a report by using a RenderIf script. Put a script in the RenderIf property so that it returns true to show or false to ...

Integrating Elixir Repertoire Server with IBM WebSphere Portal 5.1.0 WebSphere Portal provides a centralised online platform that enables organisations to create a ...

iText Issue PDF File Handle Invalid Problem Description: This iText issue may occurs when there are high load/simultaneous rendering of reports through Itext ...

ImportClass Standard Java classes can be accessed by JavaScript using !ImportClass() that is available in Elixir Report Code Snippet importClass(java.util.Vector ...

Increasing the Java HeapSpace for Remote Designer The following steps allow a user to increase the Java HeapSpace for Remote Designer 1) Edit the file \RepertoireServer ...

Installing Elixir Repertoire Server 5.x Ensure Java is pre installed. The software requires a Java VM version 1.4.2 or later. Java 5 ...

Installing Elixir Repertoire Server 6.x Ensure Java is pre installed. The software requires a Java VM version 1.4.2 or later. Java 5 ...

Supported Platforms Elixir Repertoire Server 7.x supports any Java SE version 5.0 Runtime Environment (JRE) update 8 (or later) compliant platforms such as the following ...

Internationalization Support for Product Display Elixir products for designing can display different languages depending on the locale settings. Locale settings can ...

Internationalization for Elixir Repertoire 7.1 and above If a system is set to a Chinese locale, standalone Repertoire, Remote Repertoire and the server web UI will ...

Internationalization for Elixir Repertoire 7.1 and above If a system is set to a Chinese locale, standalone Repertoire, Remote Repertoire and the server web UI will ...

For assistance, please contact support or sales at elixirtech.com JonPriddey 29 Aug 2007

Known Issues and Patches in ERS 7.1 Render Report Template with Parameters to Target via ERSClient Problem Description: Rendering a report template contain parameters ...

Known Issues and Patches in Repertoire Designer 7.1.0 MediaSize is overriding the MediaTray Problem Description: The printer tray that was specified doesn't get ...

List of Error Messages Frequently encountered issues and resolution are listed as follow. Error Message Description Resolution Can't start server: com.elixirtech.net ...

JDBC Datasource Connectivity To integrate our software Repertoire Designer/Server with a database, we will firstly require a JDBC or ODBC driver. JDBC connection will ...

Introduction With Elixir Repertoire Server 7.x onwards, all resources ( .rml, .ds, .job ) are accessible via the REST API. All resources, at first attempt, will ...

JavaScript Elixir tools use JavaScript as the embedded scripting language. The implementation is based on the Mozilla Rhino engine (http://www.mozilla.org/rhino/) ...

JavaScript API Reference Standard Javascript utilities can be easily referenced. Includes Formatting and Date Funtions. Date function offsetYears(origDate, numYears ...

JavaScript substitution JavaScript can be embedded in literal text by using variable substitution syntax where the first character is an equals " " sign. For example ...

IJobInfo Interface !IJobInfo Provide Job Information on process on the Server When rendering report or generating data, methods return an !IJobInfo interface. You ...

For assistance, please contact support or sales at elixirtech.com

Working with LDAP Datasource LDAP is a Lightweight Directory Access Protocol. It is a protocol for accessing information directories such as organizations, individuals ...

Integrating Repertoire Server with LDAP Server The attached documentation guide demonstrates the setup of Repertoire Server with a Secondary LDAP Server. ERS with ...

Linefeed Into An XML Attribute By default, XML attributes do not allow linefeed. This is an XML feature called "attribute value normalization". This is a built in ...

Line Height You can set the spacing in between the lines by specifiying your desired value for the LineHeight property. See the sample report: Line Height.rml Main ...

Place JDBC driver All JDBC driver (jar) can be place in ext directory Microsoft SQL server JDBC driver TDS is an open source 100% pure Java (type 4) JDBC 3.0 driver ...

Lookup a Data Source to create Combo Box for user entry To give you a feel, the parameterization syntax will support a new "lookup" type as follow: ${Company Name ...

Manipulation Of Report Element's Properties Properties of report element such as 'Alignment', 'Width' and 'Left' can be manipulated using script. An example will ...

RenderIf based on !MimeType This is sample which shows a different label when you choose to render in Excel output or PDF output. The following script is added in ...

Mixing Portrait and Landscape A report may contain a mixture of portrait and landscape pages. Each section of the report has a reference to a Page Setup. You may create ...

Monitoring Elixir Server Currently Elixir Repertoire Server provides a basic monitor tool via Java Management Extension (see http://java.sun.com/products/JavaManagement ...

More Information On Rendering To Excel A few points to take note for excel output rendering 1) Selection of font Excel doesn't support Java's font. Using more ...

More on Sub Report This allows a user to include an Sub Report within another Sub Report. The following are the steps to perform using the attached sample 1) Create ...

Not a Number The output !NaN stands for Not a Number. JavaScript (and Java) will use this special value to indicate that an operation could not be performed because ...

.Net DLL The .Net Client component (dll) can be used with NET, C#, C or any languages that .Net framework provides supports on. This .Net Client Component will no ...

What's new in Repertoire 7.1 ? Elixir Repertoire Report Designer Full i18n Ready Capabilities Automatic Launching of Elixir Repertoire Interactive and ...

What's new in Repertoire 7.1.1 ? Minor Feature Elixir Repertoire Report Designer PCL Renderer Support for duplex printing output Bug Fixes Elixir Report ...

What's new in Repertoire 7.1.2 ? Minor Feature Elixir Repertoire Report Designer Support for Wind Rose Chart. Bug Fixes Elixir Report Designer "Can ...

What's new in Repertoire 7.2 ? Elixir Repertoire Report Designer Chart preview can be disabled so that complex charts don't slow the design process Sub ...

What's new in Repertoire 7.2.1 ? Elixir Scheduler Designer Security options such as Read, Hide Details or Encrypted are supported in trigger files Elixir Repertoire ...

What's new in Repertoire 7.2.2 ? Elixir Remote Designer Elixir Remote Designer can be run within NetBeans program, with the NetBeans plugins installed Elixir ...

Nobody Group Member list: Set GROUP Persons/group who can change the list: Set ALLOWTOPICCHANGE TWikiAdminGroup Used to prevent dangerous ...

OnLayout The OnLayout script is called when a band is positioned on a page. This event occurs after OnRenderEnd. At the point OnRenderEnd is called, the component ...

OnRenderBegin The OnRenderBegin script is executed after RenderIf returns true. This script allows you to configure the item (which might be a section, band or component ...

OnRenderEnd The OnRenderEnd script is executed after rendering of the item (which might be a section, band or component). This script allows post processing of the ...

Name: fory Email: yangfy@evget.com Company Name: Company URL: Country: China Comment: My Links .WelcomeGuest to learn TWiki ...

java.io.IOException: The handle is invalid This has been fixed in a patched version of IText. JonPriddey 23 Nov 2007

Page Numbering Page Numbers and Page Counts can be inserted into the report output using the special variable substitutions ${#} (current page number) and ${##} (total ...

Apply locale formatting 1. Report On Render Begin: pageCount 1 2. Page Footer On Render End: pageCount 3. Field in Page Footer: "Page " Format.formatNumber(pageCount ...

Modify Page Numbering behavior Not happy with ${#} and ${##}? Then do it yourself with scripts... In order to know the total page count you need to wait until all ...

PDF Silent Printing Using Ghost script to print PDF GSPRINT uses Ghostscript to print a PDF file to a Windows printer. Using Ghostscript alone you can ...

Rest API The key concept in REST is the idea that each resource should have a unique global identifier and that operations can be applied to the resource through a ...

Creating A Report with Dynamic Parameter (Illustration) TanDunlin 20 Jul 2006

Reading JSON Data Another way to access external data is to pass it in as a dynamic parameter. Because all parameters are strings we need some way to define collections ...

Sample of Regular Expression ( ^\ )\ \s( ^\s )\s( ^\" )\"( ^\s )\s( ^\" )"\s( 0 9 )\s( 0 9 ). Apply on access.log file: ( ^\ ) // characters up to ...

RenderDetails Each output format allows different rendering parameters to be set. In Elixir Report these parameters are called render details. When you set the values ...

RenderIf The RenderIf script is called for each section, band and component in the report to determine whether it should be rendered. You may enter a script expression ...

RenderIf based on !MimeType This is sample which shows a different label when you choose to render in Excel output or PDF output. The following script is added in ...

Rendering Sequence Rendering order for version 5 Page Header Section Header Group Header Details Group Footer Section Footer Page ...

Rendering To Excel Excel doesn't allow overlapping content. When Rendering to Excel, you need to ensure that the components in the report all conform to a grid structure ...

Rendering to LPT Format There are a few points to take note to achieve best results in the LPT output Set the font Courier, size 10pt, Set the ...

Elixir Repertoire client It provides both report generation and data generation Client API interface. Data Store allows the user to trigger a section of actions to ...

Java 1.4 support for Repertoire Client 7.1 For the deployment of J2EE solution based on Java 1.4, download and read the following carefully: Support for Java 1.4 ...

Repertoire Client for Java 5 and above Environment The JAR files are located at Repertoire Server 7.1.0\RepertoireServer\clients\lib To obtain the latest RepertoireClient ...

Introduction With Elixir Repertoire Server 7.x onwards, all resources ( .rml, .ds, .job ) are accessible via the REST API. All resources, at first attempt, will ...

Report Bursting Elixir Repertoire Server provides a solution that allows splitting of a rendered report based on the grouping to be sent to a specific printer or physical ...

Repository Configuration for Version 6.x Repository.xml is to provide information on storage and access of report template and datasource to the report server. Properties ...

Resource Bundle Resource Bundle file needs to be placed in $ELIXIR REPORT HOME/ext/ Locale is defined using the dynamic parameter passed in from the report. A function ...

Some sample script for DateHandling Date.js function getMonth(Date) { return Date.getMonth(); } function getYear(Date) { return Date.getYear(); } function getFullYear ...

Quartz Misfire Instructions Not Accurate Our Scheduler Designer is using Quartz Scheduler (a 3rd party package). An issue has been filed against the following scenario ...

... no changes ... no changes ... no changes ... no changes ... no changes ... no changes ... no changes ... no changes ... no changes ... no changes ... no changes ...

Section Invocation Sections can be enabled / disabled sections during runtime. The following codes demostrate how to retrieve a dynamic parameter to determine the ...

A secure filesystem is an extension to the local filesystem and used when the file access needs to be limited access to specific users and groups. A secure filesystem ...

Scheduler Job to Send Generated Report via Email This sample shows how you can use Elixir Scheduler Designer hosted by Elixir Repertoire Remote interface to create ...

System Requirement Hardware Requirements Elixir Repertoire Server will run on any hardware platform that supports Java 2 Standard Edition ( JDK 1.5 version 8 ...

Basic Information (Docs, API, Library) Location of basic documents and required library 1. Documentation A. Elixir Repertoire Server User Manual A ...

Installing Elixir Repertoire Server Ensure Java is pre installed. The software requires a Java VM version 1.4.2 or later. Java 5 ...

Upgrading to Elixir Repertoire Server 6.x 1. Copy the following to a temporary folder (E.g. C:\temp). report server config file (located at $ERS HOME/config ...

Run Server as System Service Elixir Repertoire Server allow you to run as system service in the various platform as Windows and Unix. Setting up Repertoire Server ...

Sharing Scripts Each report has a Function Definitions editor (on the Functions tab) in the Report Designer. Any code here will be run before the report is rendered ...

In order to do silent printing (of a glint file), a few things are required. (1) add correct jar files into the project (2) codes to generate the rml file into ...

Corporate Head Office Elixir Technology Pte Ltd 50 Armenian Street #04 04 Wilmer