Engine (i-net Clear Reports API Documentation)

Overview

Package

Class

Use

Deprecated

Help

i-net Clear Reports

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.inet.report
Class Engine

java.lang.Object
  com.inet.report.Engine

All Implemented Interfaces:: NodeParser, java.io.Serializable

public class Engine
extends java.lang.Object
implements java.io.Serializable, NodeParser
extends java.lang.Object
implements java.io.Serializable, NodeParser

This is the i-net Clear Reports report engine. Its purpose is to transform a report template and its associated data. The result can either be binary data to be viewed/printed by the Java viewer bean or it can be exported into a lot of export formats, like: HTML, PDF, PS, RTF, XLS, XML, ....
You can find a complete list of supported output formats in the documentation (click here to read it online).

The engine reads the report file and creates an array of output data that can be used by the client (java viewer or CSV, HTML, PDF, RTF, XLS, XML, PS viewer, ...). The output data can be created by executing the following steps:

Create a new engine by calling engine = new Engine().
To create a PDF render engine for example, use engine = new Engine(Engine.EXPORT_PDF).
Set the path to the report template by calling engine.setReportFile("file:c:/report1.rpt") on windows or engine.setReportFile("/usr/share/clearreports/report1.rpt") on unix.
Change the parameters of the report.
For example if the report was created using ODBC to an Oracle database and you want to use a native driver (e.g. i-net SERO) instead to connect to a Oracle database, copy the file Sero.jar into the class path of i-net Clear Reports and set the name of the Data Source Configuration that should be used instead:
DatabaseTables dbTables = engine.getDatabaseTables(); Datasource ds = dbTables.getDatasource(0); ds.setDataSourceConfigurationName("Oracle_DataSourceConfiguration"); Also, you could change the selection formula and examine or change other parts of the report template using RDC if you wish.
Execute the report.
Executing a report means transforming the report template together with the data from the database (or with the data that you have set using the method engine.setData()) into the target format (PDF, RTF, HTML, binary, ...).
The last action would be to call the method engine.getPageData(int) which returns the requested report page.
A report which has been executed can not be used further, you can not use neither engine.setReportFile() nor all other set or get methods other then the getPage*() methods on an executed report.

Note that the above command sequence will usually be located in a callback, for example in the checkProperties(Engine e, Properties p) callback of the ReportServlet or the ReportSocket. The callback will always be invoked when the viewer requests data from you.
In general you do not have to use the methods of this class directly. If you use the ReportServlet or the ReportSocket (Report Server), then you use a report URL instead which the ReportServlet and the ReportSocket parses and automatically calls the necessary setter methods for you. For example if you specify the URL http://localhost:9000/?report=file:c:/report1.rpt&datasource=Oracle_DataSourceConfiguration then the ReportSocket will automatically invoke the above code sequence.

However, you can use one of the checkProperties() callbacks to change the parameters before the above set methods are called (for example if you want to set or change the password).

If you want to use RDC, you can use the checkProperties(Engine e, Properties p) callback to examine and change the fields of the engine before the engine will execute the report.

See Also:: Serialized Form

Field Summary
`static java.lang.String`	`AREA_TYPE_DETAIL` Constant for `getArea(String)`: Detail Area
`static java.lang.String`	`AREA_TYPE_GROUP_FOOTER_PREFIX` Constant for `getArea(String)`: Group Footer Prefix: To access a Group Footer, use this prefix in front of the 1-based group index you wish to access.
`static java.lang.String`	`AREA_TYPE_GROUP_HEADER_PREFIX` Constant for `getArea(String)`: Group Header Prefix: To access a Group Header, use this prefix in front of the 1-based group index you wish to access.
`static java.lang.String`	`AREA_TYPE_PAGE_FOOTER` Constant for `getArea(String)`: Page Footer
`static java.lang.String`	`AREA_TYPE_PAGE_HEADER` Constant for `getArea(String)`: Page Header
`static java.lang.String`	`AREA_TYPE_REPORT_FOOTER` Constant for `getArea(String)`: Report Footer
`static java.lang.String`	`AREA_TYPE_REPORT_HEADER` Constant for `getArea(String)`: Report Header
`static int`	`DETAILS` The constant for the index number of the details area.
`static java.lang.String`	`EXPORT_BMP` Engine creates BMP output.
`static java.lang.String`	`EXPORT_CSV` Engine creates CSV output.
`static java.lang.String`	`EXPORT_DATA` Engine creates data output.
`static java.lang.String`	`EXPORT_GIF` Engine creates GIF output.
`static java.lang.String`	`EXPORT_HTML` Engine creates HTML output.
`static java.lang.String`	`EXPORT_JPG` Engine creates JPG output.
`static java.lang.String`	`EXPORT_PDF` Engine creates PDF output.
`static java.lang.String`	`EXPORT_PNG` Engine creates PNG output.
`static java.lang.String`	`EXPORT_PS` Engine creates postscript output.
`static java.lang.String`	`EXPORT_PS2` Engine creates postscript 2 output.
`static java.lang.String`	`EXPORT_PS3` Engine creates postscript 3 output.
`static java.lang.String`	`EXPORT_RTF` Engine creates RTF output.
`static java.lang.String`	`EXPORT_SVG` Engine creates SVG output.
`static java.lang.String`	`EXPORT_TXT` Engine creates plain text output.
`static java.lang.String`	`EXPORT_XLS` Engine creates XLS output.
`static java.lang.String`	`EXPORT_XML` Engine creates XML output.
`static int`	`LOG_DEBUG` Useful if you want to send bug reports to the i-net Clear Reports support at ClearReports@inetsoftware.de
`static int`	`LOG_ERROR` Log include error messages such as "report file could not be read, rendering aborted".
`static int`	`LOG_INFO` Log include information messages such as the JDBC driver that i-net Clear Reports uses.
`static int`	`LOG_STATUS` Log nothing except a status line for each rendered report.
`static int`	`LOG_WARN` Log include warning messages such as "font not found, using a replacement font"
`static java.lang.String`	`NO_EXPORT` No export, use java viewer.
`static int`	`PAGE_FOOTER` The constant for the index number of the report header area.
`static int`	`PAGE_HEADER` The constant for the index number of the page header area.
`static int`	`REPORT_FOOTER` The constant for the index number of the report footer area.
`static int`	`REPORT_HEADER` The constant for the index number of the report header area.

Constructor Summary
`Engine()` Constructor creates an Engine for the binary data used by the Java report viewer.
`Engine(java.lang.String export_fmt)` Constructor creates an Engine for different file output formats.

Method Summary
`void`	`addClippingListener(ClippingListener listener)` Registers a clipping listener with the engine - any time an element is clipped while rendering, this listener's method "clippingOnElement" is called
`void`	`addFinishListener(EngineFinishListener listener)` Add a EngineFinishListener to this engine.
`Group`	`addGroup(Field groupField)` Adds a newly created grouping into the grouping set and returns it.
`void`	`execute()` Executes the report and stores the result data in an internal cache.
`Area`	`getArea(int idx)` Returns an AreaElement of the Area set.
`Area`	`getArea(java.lang.String item)` Returns an area element of the set of areas.
`int`	`getAreaCount()` Returns the number of Areas of the report.
`int`	`getCacheSize()` This function returns the current cache size.
`static java.lang.String`	`getCreator()` Returns the creator string that i-net Clear Reports writes into the exported files.
`DatabaseTables`	`getDatabaseTables()` Returns the DatabaseTables object for this report.
`java.lang.String`	`getDefaultSql()` Deprecated. As of i-net Crystal-Clear 10.0, use `getDefaultSqlOfAllStatements(boolean)`
`java.lang.String[]`	`getDefaultSqlOfAllStatements(boolean leavePrompts)` Returns the statements that will be send to the database.
`int`	`getDocumentPageCount()` Returns the number of pages in the finally document, e.g.
`static java.util.List`	`getEmbeddableFontNames()` Returns true type font names for all fonts from fontPath (set in the i-net Clear Reports configuration) that are licensed for embedding.
`java.lang.String`	`getErrorMsg()` Returns the error message as string.
`Fields`	`getFields()` Returns a new Fields Object.
`byte[]`	`getFontData(int fontID)` Returns the byte array of the embedded font at the specified fontId, encoded in the Viewer's protocol.
`java.lang.String`	`getGF()` Returns the group selection formula used in the current main or subreport.
`FormulaField`	`getGFField()` Returns the group selection formula used in the current main or subreport as a field.
`Group`	`getGroup(int grNum)` Returns the grouping with the specified number, where number is greater than `1` or lesser than count of groupings.
`Group`	`getGroupByField(Field field)` Returns the group which is based on the parameter `field` if exists - otherwise `null` is returned.
`int`	`getGroupCount()` Returns the count of groupings in report without the count of page, report and detail area pairs.
`byte[]`	`getGroupTree()` Returns the group tree which can be sent to the java viewer as a byte array.
`java.lang.Exception[]`	`getLoadExceptions()` If one or more errors occurred while loading a report template, you can get this error(s) as `Exception[]` from engine.
`java.util.Locale`	`getLocale()` Returns the locale that is used by the renderer.
`static int`	`getLogLevel()` Returns the logging/tracing level that is used by the Engine.
`static java.io.PrintStream`	`getLogStream()` Returns the logging/tracing PrintStream that is used by the Engine.
`static int`	`getMajorVersion()` Returns the Engine's major version number.
`java.util.Properties`	`getMetaProperties()` Returns any meta properties belonging to this engine.
`static int`	`getMinorVersion()` Returns the Engine's minor version number.
`com.inet.report.RDC.MsgListener`	`getMsgListener()` Returns the MsgListener for RDC.
`int`	`getNumeralLanguage()` Returns the language of numerals for numbers, date, time and datetime values.
`int`	`getPageCount()` Returns the number of pages (Java Viewer) or chunks (byte arrays in that the report will be streamed to the client) of the report.
`byte[]`	`getPageData(int page)` Returns the data of a single report page.
`Engine`	`getParent()` Returns the parent Engine for the current subreport or null if the current engine is the engine for the main report.
`java.util.Date`	`getPrintDate()` Returns the print date for this report.
`java.lang.Object`	`getPrompt(int i)` Returns the current value for a parameter field in the report.
`java.util.Vector`	`getPrompts()` Returns the current values for parameter fields in the report.
`java.lang.String`	`getQueryFile()` Returns the name of the query file that was specified at design time, in the report url or with the method setQueryFile.
`int`	`getRecordCount()` Returns count of records this report has read from database.
`java.net.URL`	`getReportFile()` Returns the url of the report template file.
`int`	`getReportID()` Returns the identifier of this report element.
`ReportProperties`	`getReportProperties()` Returns the reports global properties.
`java.lang.String`	`getReportTitle()` Returns the title of the report specified either in the "Summary Info" dialog of the report designer or with the method setReportTitle.
`java.lang.String`	`getSF()` Returns the record selection formula used in the current main or subreport.
`FormulaField`	`getSFField()` Returns the record selection formula used in the current main or subreport as a formula field.
`java.util.Vector`	`getSections()` Returns a vector containing all sections the report consists of.
`java.lang.String`	`getSproc(int i)` Deprecated. As of i-net Crystal-Clear 10.1, use `TableSource.getInputParameters()`
`java.util.Vector`	`getSprocs()` Deprecated. As of i-net Crystal-Clear 10.1, use `TableSource.getInputParameters()`
`EngineStatus`	`getStatus()` Returns an EngineStatus object including information about the status of this Engine .
`Engine`	`getSubReport(int idx)` Every engine object of a main report may have several subreport engines.
`int`	`getSubReportCount()` Returns the number of sub-reports.
`Subreport`	`getSubReportElement()` Returns the subreport element of the main report.
`SummaryInfo`	`getSummaryInfo()` Returns the SummaryInfo class with that you can get/set the report summary info specified in the "Summary Info" of the Reports Designer or with the setXXX methods in the class SummaryInfo.
`long`	`getTime()` Returns the timestamp that was set with setTime.
`Translations`	`getTranslations()` Get the Translations of the report.
`Trigger`	`getTrigger()` Request the Trigger object of this Engine.
`java.util.Hashtable`	`getUserData()` Returns the user data that has been set with setUserData(Hashtable).
`java.util.Properties`	`getUserProperties()` Returns the user data that has been set either with `setUserProperties()`, `checkProperties()` or in the report URL.
`FormulaField[]`	`getVariableReferences(java.lang.String varName)` Returns an array of all FormulaFields referencing the variable with the name varName - this array is empty if there is no such FormulaField referencing the variable.
`static java.lang.String`	`getVersion()` Returns the release version of this i-net Clear Reports installation, e.g. "8.1.24"
`boolean`	`isPageLimitExceeded()` Check if the rendering of the report ran into a page limit.
`boolean`	`isSubEngine()` Returns whether this engine is an engine of a subreport (`true`) or not (`false`).
`boolean`	`isXml()` Deprecated. As of i-net Clear Reports, use `ReportProperties.isCCFormat()`.
`void`	`moveGroup(int source, int dest)` Moves the group with group number `source` to `target`.
`void`	`removeClippingListener(ClippingListener listener)` Unregisters a clipping listener with the engine.
`void`	`removeFinishListener(EngineFinishListener listener)` Remove a EngineFinishListener that was added with addFinishListener.
`void`	`removeGroup(Group group)` Removes the given group object from engine.
`void`	`removeGroup(int grNum)` Remove the group specified with parameter `grNum`.
`void`	`setCatalog(java.lang.String catalog)` Sets the database name that will be used at runtime instead of the database name that was specified at design time in the report template.
`void`	`setClientLocale(java.util.Locale locale)` This method do the same as the method setLocale(Locale) except that the country from the locale of the server is used for the currency format.
`void`	`setConnection(java.sql.Connection con)` Sets the connection object to the engine of the main- or subreport.
`void`	`setConnectionCloseOnFinishing(boolean closeConnectionOnFinishing)` Sets if the set connection should be closed or not be closed after the report executing has been finished.
`static void`	`setCreator(java.lang.String creator)` Sets the creator string that is visible in the exported files.
`void`	`setData(java.lang.String[] columns, java.lang.Object[][] data, boolean longColumnNames)` Sets the report data with external data without the use of a JDBC driver.
`void`	`setData(java.util.Vector columns, java.util.Vector data, boolean longColumnNames)` This method is used from the J2EE CAS Bridge in ASP scripts.
`void`	`setData(java.lang.String[] columns, java.lang.Object[][] data)` Sets the report data with external data without the use of a JDBC driver.
`void`	`setData(java.sql.ResultSet resultSet)` Sets the report data with an ResultSet.
`void`	`setDataSourceConfigurationName(java.lang.String datasourceName)` Sets the name of datasource configuration.
`void`	`setErrorMsg(java.lang.String msg)` Sets an error message.
`void`	`setGF(java.lang.String gf)` Specifies a group selection formula.
`void`	`setLocale(java.util.Locale locale)` Sets the locale, which will be used for language independent reports.
`static void`	`setLogLevel(int level)` Sets the logging/tracing level that is used by the Engine.
`static void`	`setLogStream(java.io.PrintStream stream)` Sets the logging/tracing PrintStream that is used by the Engine and Viewer.
`void`	`setMetaProperties(java.util.Properties props)` Sets (and overwrites!)
`void`	`setMsgListener(com.inet.report.RDC.MsgListener msgl)` Sets the MsgListener for RDC.
`void`	`setNumeralLanguage(int language)` Sets the language of the numerals in numbers, date, time and datetime values.
`void`	`setPassword(java.lang.String password)` Sets the password for the main and all subreports for logging on to SQL, ODBC, or password protected databases used by the report.
`void`	`setPrintDate(java.util.Date date)` Sets the print date for this report.
`void`	`setPrompt(java.lang.String prompt, int i)` Specifies the value for a parameter field in the report.
`void`	`setPrompt(java.lang.String name, java.lang.String prompt)` Specifies the value for a parameter field in the report.
`void`	`setPrompts(java.util.Vector prompts)` Specifies value for parameter fields in the report.
`void`	`setQueryFile(java.net.URL url, int i)` Sets the name of the query file for subreport $n$.
`void`	`setQueryFile(java.net.URL url)` Sets the name of the query file in main report.
`void`	`setReportFile(java.lang.String url)` Sets the report template file.
`void`	`setReportFile(java.net.URL url)` Sets the report file URL.
`void`	`setReportTitle(java.lang.String title)` Sets the title of the report.
`void`	`setSF(java.lang.String sf)` Specifies a record selection formula.
`void`	`setSchema(java.lang.String schema)` Sets the database schema that will be used with this report at runtime instead of the schema that was specified at report creation.
`void`	`setSproc(java.lang.String sproc, int i)` Sets the value for a stored procedure parameter accessed by the report.
`void`	`setSprocs(java.util.Vector sprocs)` Deprecated. As of i-net Crystal-Clear 10.1, use `setSproc(String, int)`
`void`	`setSql(java.lang.String statement)` Replaces all defined tables and joins by this SQL statement.
`void`	`setSql(java.lang.String statement, boolean useColumnIndexFromReportDesign)` Manually sets the SQL statement that will be send to the database to fetch the report data.
`void`	`setSqlIgnoreMetaData(java.lang.String statement)` Replaces all defined tables and joins of this report with the supplied sql statement.
`void`	`setTime(long time)` Sets a timestamp.
`void`	`setUser(java.lang.String user)` Sets the same username for all reports (main and subreports) for logging on to password protected databases used by the report.
`void`	`setUserData(java.util.Hashtable hash)` With this method you can associate additional data with the engine and retrieve it later (e.g. in a class that is derived from Database).
`void`	`setUserProperties(java.util.Properties props)` With this method you can associate additional data with the engine of the main report.
`static void`	`shutdown()` Attempts to interrupt all Threads created by i-net Clear Reports.
`void`	`stop()` Stops the execution of the report after the rendering of the current page was finished.
`void`	`stop(java.lang.String message)` Stops the execution of the report after the rendering of the current page was finished.
`void`	`stopAfterPage(int maxPageNo)` Sets the maximum number of report pages rendered by these engine.
`static void`	`stopAll()` Stops all Engines in this JVM or container.

Methods inherited from interface com.inet.report.parser.NodeParser
`isDOMParser, parseDOM, parseElement, parseEndElement, parseText`

Field Detail

AREA_TYPE_REPORT_HEADER

public static final java.lang.String AREA_TYPE_REPORT_HEADER

Constant for getArea(String): Report Header

See Also:: Constant Field Values

AREA_TYPE_PAGE_HEADER

public static final java.lang.String AREA_TYPE_PAGE_HEADER

Constant for getArea(String): Page Header

See Also:: Constant Field Values

AREA_TYPE_GROUP_HEADER_PREFIX

public static final java.lang.String AREA_TYPE_GROUP_HEADER_PREFIX

Constant for getArea(String): Group Header Prefix: To access a Group Header, use this prefix in front of the 1-based group index you wish to access. E.g. GH1, GH2...

See Also:: Constant Field Values

AREA_TYPE_DETAIL

public static final java.lang.String AREA_TYPE_DETAIL

Constant for getArea(String): Detail Area

See Also:: Constant Field Values

AREA_TYPE_GROUP_FOOTER_PREFIX

public static final java.lang.String AREA_TYPE_GROUP_FOOTER_PREFIX

Constant for getArea(String): Group Footer Prefix: To access a Group Footer, use this prefix in front of the 1-based group index you wish to access. E.g. GF1, GF2...

See Also:: Constant Field Values

AREA_TYPE_REPORT_FOOTER

public static final java.lang.String AREA_TYPE_REPORT_FOOTER

Constant for getArea(String): Report Footer

See Also:: Constant Field Values

AREA_TYPE_PAGE_FOOTER

public static final java.lang.String AREA_TYPE_PAGE_FOOTER

Constant for getArea(String): Page Footer

See Also:: Constant Field Values

REPORT_HEADER

public static final int REPORT_HEADER

The constant for the index number of the report header area.

See Also:: Constant Field Values

PAGE_HEADER

public static final int PAGE_HEADER

The constant for the index number of the page header area.

See Also:: Constant Field Values

DETAILS

public static final int DETAILS

The constant for the index number of the details area.

See Also:: Constant Field Values

REPORT_FOOTER

public static final int REPORT_FOOTER

The constant for the index number of the report footer area.

See Also:: Constant Field Values

PAGE_FOOTER

public static final int PAGE_FOOTER

The constant for the index number of the report header area.

See Also:: Constant Field Values

NO_EXPORT

public static final java.lang.String NO_EXPORT

No export, use java viewer.

Since:: 2.01
See Also:: Constant Field Values

EXPORT_PDF

public static final java.lang.String EXPORT_PDF

Engine creates PDF output.

Since:: 2.01
See Also:: Constant Field Values

EXPORT_RTF

public static final java.lang.String EXPORT_RTF

Engine creates RTF output.

Since:: 2.01
See Also:: Constant Field Values

EXPORT_HTML

public static final java.lang.String EXPORT_HTML

Engine creates HTML output.

Since:: 2.01
See Also:: Constant Field Values

EXPORT_XLS

public static final java.lang.String EXPORT_XLS

Engine creates XLS output.

Since:: 3.0
See Also:: Constant Field Values

EXPORT_XML

public static final java.lang.String EXPORT_XML

Engine creates XML output.

Since:: 3.2
See Also:: Constant Field Values

EXPORT_TXT

public static final java.lang.String EXPORT_TXT

Engine creates plain text output.

Since:: 6.0
See Also:: Constant Field Values

EXPORT_CSV

public static final java.lang.String EXPORT_CSV

Engine creates CSV output.
The column delimiter can be specified with property: delimiter.

Since:: 7.0
See Also:: Constant Field Values

EXPORT_PS

public static final java.lang.String EXPORT_PS

Engine creates postscript output.

Since:: 4.2
See Also:: Constant Field Values

EXPORT_PS2

public static final java.lang.String EXPORT_PS2

Engine creates postscript 2 output.

Since:: 5.1
See Also:: Constant Field Values

EXPORT_PS3

public static final java.lang.String EXPORT_PS3

Engine creates postscript 3 output.

Since:: 5.1
See Also:: Constant Field Values

EXPORT_DATA

public static final java.lang.String EXPORT_DATA

Engine creates data output.

Since:: 5.2
See Also:: Constant Field Values

EXPORT_SVG

public static final java.lang.String EXPORT_SVG

Engine creates SVG output.

Since:: 6.1
See Also:: Constant Field Values

EXPORT_PNG

public static final java.lang.String EXPORT_PNG

Engine creates PNG output.

Since:: 9.0
See Also:: Constant Field Values

EXPORT_GIF

public static final java.lang.String EXPORT_GIF

Engine creates GIF output.

Since:: 9.0
See Also:: Constant Field Values

EXPORT_JPG

public static final java.lang.String EXPORT_JPG

Engine creates JPG output.

Since:: 9.0
See Also:: Constant Field Values

EXPORT_BMP

public static final java.lang.String EXPORT_BMP

Engine creates BMP output.

Since:: 9.0
See Also:: Constant Field Values

LOG_STATUS

public static int LOG_STATUS

Log nothing except a status line for each rendered report.

Since:: 7.0

LOG_ERROR

public static int LOG_ERROR

Log include error messages such as "report file could not be read, rendering aborted".

Since:: 7.0

LOG_WARN

public static int LOG_WARN

Log include warning messages such as "font not found, using a replacement font"

Since:: 7.0

LOG_INFO

public static int LOG_INFO

Log include information messages such as the JDBC driver that i-net Clear Reports uses. This log level was default

Since:: 7.0

LOG_DEBUG

public static int LOG_DEBUG

Useful if you want to send bug reports to the i-net Clear Reports support at ClearReports@inetsoftware.de

Since:: 7.0

Constructor Detail

Engine

public Engine()

Constructor creates an Engine for the binary data used by the Java report viewer.

Engine

public Engine(java.lang.String export_fmt)
       throws ReportException

Constructor creates an Engine for different file output formats. Parameters can be set with setUserProperties(Properties).

Parameters:

export_fmt - the output format. The following values are valid:
pdf - PDF file
ps - PS file
ps2 - PS file (level 2)
ps3 - PS file (level 3)
rtf - RTF file
xls - XLS file
xml - XML file
csv - CSV file
txt - TXT file
htmBaseFileName - HTML file(s) (e.g. htmMyReport); The base file name is the file name of the first html page (e.g. MyReport.htm) and the base name of all other html files (e.g. MyReport1.htm, MyReport2.htm, ...). Each report page will be saved in a separate HTML file.

For example:

 Engine engine = new Engine(Engine.EXPORT_PDF);
 engine.setReportFile( "file:D:/reports/MySample.rpt" );
 //engine.setPassword("....");    // if you like to change/set the password
 //engine.setPrompt("...","..."); // if you like to set a parameter field value
 engine.execute();
 File pdfFile = new File("D:/exports/sample.pdf");
 FileOutputStream fos = new FileOutputStream(pdfFile);
 for(int i=1;i<=engine.getPageCount();i++){
     fos.write(engine.getPageData(i));
 }
 fos.close();

Throws:

ReportException - throw if the format is wrong.

See Also:

NO_EXPORT, EXPORT_PDF, EXPORT_PS, EXPORT_PS2, EXPORT_PS3, EXPORT_RTF, EXPORT_HTML, EXPORT_XLS, EXPORT_XML, EXPORT_TXT, EXPORT_CSV, EXPORT_DATA, EXPORT_SVG, EXPORT_BMP, EXPORT_GIF, EXPORT_JPEG, EXPORT_PNG

Method Detail

shutdown

public static void shutdown()

Attempts to interrupt all Threads created by i-net Clear Reports. Only use this if you want to dynamically reload an i-net Clear Reports engine (for example for testing different versions of an i-net Clear Reports engine in one VM Session). Warning: Before you re-init an i-net Clear Reports engine the i-net Clear Reports classes must be reloaded by a class loader.

getRecordCount

public int getRecordCount()

Returns count of records this report has read from database. For subreports it is the sum of the records of all instances of the subreport. Usable if engine is finished only otherwise returns -1. NOTE: If you need this value for a subreport then you need request the reference of the subreport Engine before execute().

Returns:: count of records or -1
Since:: 6.1

getCreator

public static java.lang.String getCreator()

Returns the creator string that i-net Clear Reports writes into the exported files. The default is "i-net Clear Reports <version#>".

Returns:: "i-net Clear Reports " + Engine.getVersion() or whatever has set via setCreator()
See Also:: setCreator(String)

setCreator

public static void setCreator(java.lang.String creator)

Sets the creator string that is visible in the exported files. For example in the postscript source file the DSC will be "%%Creator: " + Engine.getCreator();

Parameters:: creator - The default value is "i-net Clear Reports " + Engine.getVersion()
Throws:: java.lang.NullPointerException - If creator is null
See Also:: getCreator()

setLocale

public void setLocale(java.util.Locale locale)
               throws ReportException

Sets the locale, which will be used for language independent reports. This locale will be used for formating of field values (number, date, time boolean, ... ) and for the translation of labels used in reports into the language specified in the locale. It will be not used for formatting of the result of formula functions like CDbl, ToText etc. The locale is either the one used by the operating system of the client or the one specified in the report URL as property "locale". The strings for the different languages are saved in ResourceBundles. The base class for the ResourceBundles need to be specified in the i-net Clear Reports configuration using the Configuration Manager.
This method also sets the locale for the sub-reports of the engine. If you want to set a different locale for one of the sub-reports then please set the language for the sub-report engine after you've set the language for the main report engine.

Parameters:: locale - The locale to be used by the client
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: getLocale(), setClientLocale(java.util.Locale), setNumeralLanguage(int)

setClientLocale

public void setClientLocale(java.util.Locale locale)
                     throws ReportException

This method do the same as the method setLocale(Locale) except that the country from the locale of the server is used for the currency format. This method need to be used if the clients in different countries should see the same currency in the reports independent from the locale on the client computer. This method is used from web interface.

Parameters:: locale - The locale to be used by the client
Throws:: ReportException - if Engine is not initialized or finished.
Since:: 6.0
See Also:: getLocale(), setLocale(Locale)

getLocale

public java.util.Locale getLocale()
                           throws ReportException

Returns the locale that is used by the renderer.

Returns:: locale The locale used on the client
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: setLocale(Locale locale)

setNumeralLanguage

public void setNumeralLanguage(int language)
                        throws ReportException

Sets the language of the numerals in numbers, date, time and datetime values. This is the global setting of the report. It can be overwritten for each AbstractValueElement.

Parameters:: language - one of the language constant values or -1 for the current locale as default.
Throws:: ReportException - if Engine is not initialized or finished.
Since:: 6.1
See Also:: setLocale(Locale), getNumeralLanguage(), ValueProperties.setNumeralLanguage(int), ValueProperties.NUMERAL_LANGUAGE_EUROPEAN, ValueProperties.NUMERAL_LANGUAGE_ARABIC, ValueProperties.NUMERAL_LANGUAGE_EASTERN_ARABIC, ValueProperties.NUMERAL_LANGUAGE_DEVANAGARI, ValueProperties.NUMERAL_LANGUAGE_BENGALI, ValueProperties.NUMERAL_LANGUAGE_GURMUKHI, ValueProperties.NUMERAL_LANGUAGE_GUJARATI, ValueProperties.NUMERAL_LANGUAGE_ORIYA, ValueProperties.NUMERAL_LANGUAGE_TAMIL, ValueProperties.NUMERAL_LANGUAGE_TELUGU, ValueProperties.NUMERAL_LANGUAGE_KANNADA, ValueProperties.NUMERAL_LANGUAGE_MALAYALAM, ValueProperties.NUMERAL_LANGUAGE_THAI, ValueProperties.NUMERAL_LANGUAGE_LAO, ValueProperties.NUMERAL_LANGUAGE_TIBETAN, ValueProperties.NUMERAL_LANGUAGE_MYANMAR, ValueProperties.NUMERAL_LANGUAGE_ETHIOPIC, ValueProperties.NUMERAL_LANGUAGE_KHMER, ValueProperties.NUMERAL_LANGUAGE_MONGOLIAN

getNumeralLanguage

public int getNumeralLanguage()
                       throws ReportException

Returns the language of numerals for numbers, date, time and datetime values.

Returns:: One of the language constant or -1 for the locale default.
Throws:: ReportException - if Engine is not initialized or finished.
Since:: 6.1
See Also:: setNumeralLanguage(int)

setUserProperties

public void setUserProperties(java.util.Properties props)
                       throws ReportException

With this method you can associate additional data with the engine of the main report. Later you can use this data e.g. in your own class that is derived from Database.
The data are always attached to the main report engine, never to the sub report engine(s).
To set data for main or subreport engine use the method setUserData(Hashtable). A list and description of interpreted properties can you find in the Report URL Parameters.

Parameters:: props - The data to be set in a Properties object.
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: getUserProperties(), setUserData(Hashtable), getUserData()

getUserProperties

public java.util.Properties getUserProperties()
                                       throws ReportException

Returns the user data that has been set either with setUserProperties(), checkProperties() or in the report URL.
This method can be usefull if you have additional properties which should be associated with the engine. But please see also the method set/getUserData(Hashtable data) which is probably more useful.

Returns:: The user properties or null if user properties not set.
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: setUserProperties(Properties props), setUserData(Hashtable data), getUserData()

getUserData

public java.util.Hashtable getUserData()

Returns the user data that has been set with setUserData(Hashtable).
This method can be useful e.g. in your own database class, a class that extends from com.inet.report.Database and in that you set the report data without a JDBC connection e.g. with an external ResultSet.
For instance you can use this method to get the selection formula (sf) specified in the report URL and use it to fill you own ResultSet in your database class:

   public void getReportData( Engine engine, String configs ) {
       try {
           ...
           // get the url properties from the report URL
           Hashtable p = engine.getUserData();
           String[] cols = p.get("my_cols"));
           ...
           engine.setData(cols, data, true);
       } catch (Throwable t) {Utils.printStackTrace(t);}
    }

In the report URL you can set these parameter, e.g.:
http://<servername>:9000/?report=...rpt&...&sf=table.field=5

Returns:: The user data associated with this report.
See Also:: setUserData(Hashtable), setUserProperties(Properties props), getUserProperties()

setUserData

public void setUserData(java.util.Hashtable hash)

With this method you can associate additional data with the engine and retrieve it later (e.g. in a class that is derived from Database). The data are always attached to the current engine.

Parameters:: hash - The data to be set.
See Also:: getUserData(), setUserProperties(Properties props), getUserProperties()

getParent

public Engine getParent()
                 throws ReportException

Returns the parent Engine for the current subreport or null if the current engine is the engine for the main report.

Returns:: The parent engine or null.
Throws:: ReportException - if Engine is not initialized or finished.

execute

public void execute()
             throws ReportException

Executes the report and stores the result data in an internal cache. Before you can execute the report generation you need to set all options. You need to call this method before you can request the page data with getPageData.

Throws:: ReportException - if Engine is not initialized or finished.
See Also:: getPageData(int)

getPageData

public byte[] getPageData(int page)
                   throws ReportException

Returns the data of a single report page. If no export format has been specified for this engine then this method returns the binary data of one report page. These binary data are useful for the Java client only.
If an export format has been specified (e.g. EXPORT_PDF) for this engine [new Engine(Export_Format)] then this method returns the bytes of a report page or of a part (e.g. XLS sheet) of the report. For the export to PDF, RTF, XLS, XML and CSV it is necessary to write the bytes of all pages to a single file to get a valid export file (e.g. .pdf).
If the export to PS is used then it is possible to use the single pages of the .ps file, e.g. for printing.
The html export creates one html file for each report page and one jpg file for each image in the report. Therefore it is necessary to create multiple files from the byte array returned from getPageData (see samples/export/ExportWithoutViewerToHTML.java).

With the following code you can export into a .pdf file:

 Engine engine = new Engine(Engine.EXPORT_PDF);
 engine.setReportFile( "file:D:/reports/MySample.rpt" );
 engine.execute();
 File pdfFile = new File("D:/exports/sample.pdf");
 FileOutputStream fos = new FileOutputStream(pdfFile);
 for(int i=1;i<=engine.getPageCount();i++){
     fos.write(engine.getPageData(i));
 }
 fos.close();

Please note: Before you can call this method you need to call engine.execute() to execute and render the report.
This method is waiting until the rendering process of the requested page has been finished.

Parameters:: page - The number of the page. The first page is 1, the second is 2, ... . If the page number is bigger than the page count then null will be returned.
Returns:: the binary data for the Java Viewer or the bytes of the exported file (page).
Throws:: java.lang.IllegalArgumentException - if the page number is zero or negative.; ReportException - If rendering the page encounters a problem
See Also:: getPageCount(), Engine(String export_fmt)

getFontData

public byte[] getFontData(int fontID)

Returns the byte array of the embedded font at the specified fontId, encoded in the Viewer's protocol. The fontID is 1-based. null will be returned if there are no fonts embedded for the report of this Engine. If fontID is greater than the number of embedded fonts available it will return the last font available.

Parameters:: fontID - Identifying number of font to fetch
Returns:: the encoded byte array of the embedded font at the specified fontId or null if not font is available.
Throws:: java.lang.IllegalArgumentException - If fontID is less than 1.

getPageCount

public int getPageCount()
                 throws ReportException

Returns the number of pages (Java Viewer) or chunks (byte arrays in that the report will be streamed to the client) of the report.
This method is waiting until the rendering process has been finished.
This is useful if you use i-net Clear Reports with external result sets or connections and you want to know when the rendering process is finished and you can close these external result sets or connections.

Returns:: number of pages or chunks
Throws:: ReportException - If rendering the report encounters a problem
See Also:: getPageData(int), getDocumentPageCount()

getDocumentPageCount

public int getDocumentPageCount()
                         throws ReportException

Returns the number of pages in the finally document, e.g. PDF file. This is not the same as getPageCount() which returns the number of separate chunks (byte arrays in that the report will be streamed to the client).
This method is waiting until the rendering process has been finished.
This is usefull if you use i-net Clear Reports with external result sets or connections and you want to know when the rendering process is finished and you can close these external result sets or connections.

Returns:: number of pages in the finally document
Throws:: ReportException - If rendering the report encounters a problem
See Also:: getPageCount()

setCatalog

public void setCatalog(java.lang.String catalog)
                throws ReportException

Sets the database name that will be used at runtime instead of the database name that was specified at design time in the report template. If the used database does not support catalogs (e.g. ORACLE databases) then these parameter will be ignored.
This parameter has an effect only if a catalog was specified at design time. It is not possible to change the catalog if it was not specified at design time.
This function is a convenience function that sets the catalog for the main and all sub reports. Please see the appopriate function in DatabaseTables which only modifies the parameters of the current report.
Note that this method only points to the first Datasource of the report. If there is more than one data source, you need to use the

Parameters:: catalog - name of the catalog
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: setDataSourceConfigurationName(String), setSchema(String), setUser(String), setPassword(String), DataSourceConfiguration.setCatalog(String), DataSourceConfiguration.getCatalog(), DatabaseTables.createDatasource(String)

setSchema

public void setSchema(java.lang.String schema)
               throws ReportException

Sets the database schema that will be used with this report at runtime instead of the schema that was specified at report creation. If the used database does not support schema then these parameter will be ignored.
This function is a convenience function that sets the schema for the main and all sub reports. Please see the appopriate function in Datasource which only modifies the parameters of a specific data source.

This method only points to the first Datasource of the report and sub reports.

Parameters:: schema - Name of the schema
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: Datasource.getSchema(), setCatalog(String), setDataSourceConfigurationName(String), setUser(String), setPassword(String), Datasource.setSchema(String), Datasource.setSchema(String), DatabaseTables.createDatasource(String)

setData

public void setData(java.lang.String[] columns,
                    java.lang.Object[][] data,
                    boolean longColumnNames)
             throws ReportException

Sets the report data with external data without the use of a JDBC driver. You only need this function if you do not use a JDBC driver. You can create a rpt template with the report designer or RDC on dummy tables. At runtime you do not have database access.
If a record or group selection formula is set, it will still be evaluated after reading the ResultSet. If you do not wish this, you should remove these formulas with setSF(String) and/or setGF(String).
Note that this does not work with a "query file"; fetching data via a query file takes always precedence even if you call setData().
Example:


         Engine eng = new Engine();

         eng.setReportFile( "file:C:/report/MySample.rpt" );

         String[] columns = {"TestTable.ID", "TestTable.Name"};

         Object[][] data =                           

                        {{new Integer(10), "John"},

                        {new Integer(20), "Peter"},

                        {new Integer(23), "Ana"}};

         eng.setData( columns, data, true );

         eng.execute();

Make sure you do not not modify the arrays, columns and data. The Engine does not create a copy of it. The Engine modifies the data array on execute(). Do not use the same array for two calls of setData(). You need to create a copy (for example with clone() ).
As column names it is recommended to set them full qualified: <tableName>. <columnName>

Parameters:: columns - The names of the columns in the report template. This names are case in-sensitiv.; data - the report data. Supported datatypes are: all instances of Number, String and byte[].; longColumnNames - this flag is obsolete since i-net Crystal-Clear 5.3
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: ReportProperties.setIgnoreFiltering(boolean), ReportProperties.setIgnoreSorting(boolean), setSF(String), setGF(String)

setData

public void setData(java.util.Vector columns,
                    java.util.Vector data,
                    boolean longColumnNames)
             throws ReportException

This method is used from the J2EE CAS Bridge in ASP scripts. The vector columns contains the strings with the columns names. The vector data can contain object arrays or vectors with the data for the columns. It is a wrapper for the methods with arrays.
If a record or group selection formula is set, it will still be evaluated after reading the ResultSet. If you do not wish this, you should remove these formulas with setSF(String) and/or setGF(String).

Parameters:: columns - must include Strings only; data - can include Vectors or Object[]; longColumnNames - this flag is obsolete since i-net Crystal-Clear 5.3
Throws:: ReportException - If there are problems with the engine not being initialized or with the data not being valid
See Also:: setData(String[],Object[][],boolean), ReportProperties.setIgnoreFiltering(boolean), ReportProperties.setIgnoreSorting(boolean), setSF(String), setGF(String)

setData

public void setData(java.lang.String[] columns,
                    java.lang.Object[][] data)
             throws ReportException

Sets the report data with external data without the use of a JDBC driver. You only need this function if you do not use a JDBC driver. You can create a rpt template with the report designer on dummy tables. At the runtime you do not have database access.
If a record or group selection formula is set, it will still be evaluated after reading the ResultSet. If you do not wish this, you should remove these formulas with setSF(String) and/or setGF(String). Note that this does not work when using a "query file"; fetching data via a query file takes always precedence even if you call setData().
For example:


         Engine eng = new Engine();

         eng.setReportFile( "file:C:/report/MySample.rpt" );

         String[] columns = {"TestTable.ID", "TestTable.Name"};

         Object[][] data =                           

                        {{new Integer(10), "John"},

                        {new Integer(20), "Peter"},

                        {new Integer(23), "Ana"}};

         eng.setData( columns, data );

         eng.execute();

Parameters:: columns - The names of the columns in the report template. This names are by default case in-sensitiv.; data - the report data.
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: ReportProperties.setIgnoreFiltering(boolean), ReportProperties.setIgnoreSorting(boolean), setSF(String), setGF(String)

setConnection

public void setConnection(java.sql.Connection con)
                   throws ReportException

Sets the connection object to the engine of the main- or subreport.
You can use this method for instance if you have your own pool of database connections so that you can take the advantage of your own pooled connections.
The i-net Clear Reports engine will close the connection after using it, thus indicating to the pool manager that the connection is no longer in use. The pool manager can then re-use the real connection.
The main report and each subreport need it's own connection so you need to set separate connections for the main and the subreport(s).

Please note:
1. This method set the catalog to Null. Therefore it is only possible to execute a main or subreport to one database (catalog).
2. The method setConnection() replace the database connection, only. It does not change the settings of the Data Source Configuration on that the report was designed. The driver for a given Data Source Configuration need to be configured as if setConnection() were not used.
3. The properties (like "supports SQL92", "supports brackets in join", "alias keyword", ...) on the Data Source Manager tab "Compatibility Settings" can be used to configure the set connections.

You can find more information about the Data Source Manager in the documentation (click here to read it online).

Code Example:


         Class.forName("com.inet.ora.OraDriver");

         Engine eng = new Engine();

         eng.setReportFile( "file:C:/report/MySample.rpt" );

         Connection con = DriverManager.getConnection("jdbc:inetora:host:port:sid?user=USRName&password=PWD");

         eng.setConnection( con );

         eng.setCatalog(con.getCatalog()); 

         eng.execute();

Parameters:: con - The database connection object
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: setConnectionCloseOnFinishing(boolean), Datasource.setConnection(Connection)

setConnectionCloseOnFinishing

public void setConnectionCloseOnFinishing(boolean closeConnectionOnFinishing)

Sets if the set connection should be closed or not be closed after the report executing has been finished.

Parameters:: closeConnectionOnFinishing - if set to false, the set connection will not be closed when the report execution was completed.
Since:: 6.0
See Also:: setConnection(Connection)

stopAfterPage

public void stopAfterPage(int maxPageNo)

Sets the maximum number of report pages rendered by these engine. This method need to be called after setReportFile(...) and before the execution of the engine is finsihed otherwise it has no effect.

Parameters:: maxPageNo - The last page that should be rendered. 0 means "unlimited".
See Also:: stop()

stop

public void stop()

Stops the execution of the report after the rendering of the current page was finished. This method need to be called after setReportFile(...) and before the execution of the engine is finished otherwise it has no effect.

See Also:: stop(String), stopAfterPage(int), stopAll()

stop

public void stop(java.lang.String message)

Parameters:: message - a message for the debug log.
Since:: 7.7
See Also:: stopAfterPage(int), stopAll()

isPageLimitExceeded

public boolean isPageLimitExceeded()

Check if the rendering of the report ran into a page limit. This means does not all possible pages exist.

Returns:: true, if there is a limit
Since:: 10.0

stopAll

public static void stopAll()

Stops all Engines in this JVM or container.

See Also:: stop()

setData

public void setData(java.sql.ResultSet resultSet)
             throws java.lang.NullPointerException,
                    java.sql.SQLException,
                    ReportException

Sets the report data with an ResultSet. You can create a report file with the report designer on dummy tables (i.e. create a report file that accesses a database). At runtime you can set different ResultSet's for the same report template.
If a record or group selection formula is set, it will still be evaluated after reading the ResultSet. If you do not wish this, you should remove these formulas with setSF(String) and/or setGF(String).
Note: This does not work when using a "query file";
To fetching data via a query file takes always precedence even if you call setData().
Example:


   Engine eng = new Engine();
 
   eng.setReportFile("file:C:/report/MySample.rpt" );
 
   eng.setData( resultSet );
 
   eng.execute();

Parameters:: resultSet - The resultset that contains the data for the report.
Throws:: java.sql.SQLException - If a database access error occurs or the ResultSet is closed; ReportException - If the Engine is not initialized or finished; java.lang.NullPointerException - Rarely, if there are internal problems with the database connection. Should never occur.
See Also:: Database.getReportData(Engine, String), ReportProperties.setIgnoreFiltering(boolean), ReportProperties.setIgnoreSorting(boolean), setSF(String), setGF(String)

setLogStream

public static void setLogStream(java.io.PrintStream stream)

Sets the logging/tracing PrintStream that is used by the Engine and Viewer.

Parameters:: stream - Print Stream

setLogLevel

public static void setLogLevel(int level)

Sets the logging/tracing level that is used by the Engine. This value will be override if i-net Clear Reports is initialize. The inialisation is trigger from creating the first Engine, setting a Configuration in the ConfigurationManager and some other API calls.

Parameters:: level - the log level
See Also:: setLogStream(java.io.PrintStream), getLogLevel(), LOG_STATUS, LOG_ERROR, LOG_WARN, LOG_INFO, LOG_DEBUG

getLogStream

public static java.io.PrintStream getLogStream()

Returns the logging/tracing PrintStream that is used by the Engine.

Returns:: Print Stream

getLogLevel

public static int getLogLevel()

Returns the logging/tracing level that is used by the Engine.

Returns:: log level
See Also:: setLogLevel(int)

setGF

public void setGF(java.lang.String gf)
           throws ReportException

Specifies a group selection formula. This parameter is similar to the SF command (selection formula). What you assign here are CrystalReports expressions. For example:

engine.setGF("if ({table.row} = 1) then true else
 false");

The expression is never evaluated on the database server. It is evaluated by the report engine after all records have been fetched and grouped. The formula must return true or false.

Parameters:: gf - group selection formula
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: getGF(), setSF(java.lang.String), getSF()

getGF

public java.lang.String getGF()
                       throws ReportException

Returns the group selection formula used in the current main or subreport.
This could be specified in the report template (rpt file) at design time, with the method setGF or with the report url parameter "gf", see: URL Parameters. *

Returns:: group selection formula
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: setGF(java.lang.String), setSF(java.lang.String), getSF()

getGFField

public FormulaField getGFField()
                        throws ReportException

Returns the group selection formula used in the current main or subreport as a field.
This could be specified in the report template (rpt file) at design time, with the method setGF or with the report url parameter "gf", see: URL Parameters. *

Returns:: group selection formula as a field
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: getGF(), setGF(java.lang.String), setSF(java.lang.String)

setSF

public void setSF(java.lang.String sf)
           throws ReportException

Specifies a record selection formula. Use it to select the records that you want included in your report; of course only if you do not want all records.
If the record selection formula is executable on the database (e.g. a record selection formula that contains an if then construct is not executable on the database) then it will be appended to the 'Where'-clause of the SQL statement.
If it is not executable on the database then i-net Clear Reports will execute it after the data was fetched from the database.
The result of the selection formula need to be a boolean, that means 'true' or 'false'.
If you want to use a database field in the new selection formula that was not added to your report at design time or that was not used in the old selection formula, then you have to add it into your report design.
The record selection formula need to be in Crystal Syntax for formulas.
For example:

engine.setSF("if ({table.row} = 1) then true
 else false");

The expression is evaluated either on the database server when the expression could be translated into a where ... clause or by the report engine when fetching records. The formula must return true or false.

Parameters:: sf - record selection formula to use, null if record selection is to be removed.
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: getSF(), setGF(java.lang.String), getGF()

getSF

public java.lang.String getSF()
                       throws ReportException

Returns the record selection formula used in the current main or subreport.
This could be specified in the report template (rpt file) at design time, with the method setSF or with the report url parameter "sf", see: URL Parameters.

Returns:: selection formula or null if no selection formula is set
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: setSF(java.lang.String), setGF(java.lang.String), getGF()

getSFField

public FormulaField getSFField()
                        throws ReportException

Returns the record selection formula used in the current main or subreport as a formula field.
This could be specified in the report template (rpt file) at design time, with the method setSF or with the report url parameter "sf", see: URL Parameters.

Returns:: selection formula as a formula field or null if no record selection formula is set
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: getSF(), setSF(java.lang.String)

setPrompt

public void setPrompt(java.lang.String prompt,
                      int i)
               throws ReportException

Specifies the value for a parameter field in the report. Parameter field values are assigned to parameter fields in that order the parameter field exists in the report.

For example: engine.setPrompt("Date(2001,01,01)", 0);
To set the value for a parameter field with multiple values use the array syntax, e.g.:
engine.setPrompt("[Date(2001,01,01),Date(2007,05,15)]", 0);
To set a string value with quotation marks at the beginning and at the end which should be displayed in the report, you need to add additional quotation marks, e.g.:
engine.setPrompt("MyStringPrompt","\"\"string-value\"\"");.

Note: The expression will be executed before any data will be fetched from the database.

Parameters:: prompt - value for parameter field i; i - index in the parameter list
Throws:: ReportException - if Engine is not initialized or finished.; java.lang.IllegalStateException - If no prompt could be found at the given index
See Also:: setPrompts(java.util.Vector), getPrompts(), getPrompt(int), getFields(), Fields.getPromptField(int)

setPrompt

public void setPrompt(java.lang.String name,
                      java.lang.String prompt)
               throws ReportException

Specifies the value for a parameter field in the report.
If the name is not in the parameter list the call is ignored.

For example: engine.setPrompt("MyDatePrompt","Date(2006,01,03)");
To set the value for a parameter field with multiple values use the array syntax, e.g.:
engine.setPrompt("MyDatePrompt","[Date(2001,01,01),Date(2007,05,15)]");.
To set a value with quotation marks at the beginning and at the end which should be displayed in the report, you need to add additional quotation marks, e.g.:
engine.setPrompt("MyStringPrompt","\"\"string-value\"\"");.

Note: The expression will be executed before any data will be fetched from the database.

Note also that if you want to set the value of a prompt in a subreport, you should use the following syntax: #SubreportID#Name
For example: #2#TestName would address a prompt called "TestName" in the second subreport.

Parameters:: name - the name of the parameter field; prompt - value for parameter field as String
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: setPrompts(java.util.Vector), getPrompts(), getPrompt(int), getFields(), Fields.getPromptField(int)

setPrompts

public void setPrompts(java.util.Vector prompts)
                throws ReportException

Specifies value for parameter fields in the report. Only String values are accepted in the Vector. If you want set Object values then you need to do this with getFields().getPromptField(x).setPromptValue(value). Parameter field values are assigned to parameter fields in that order the parameter field exists in the report.
Make sure that parameter field values appear in the Vector in the same order the parameter fields appears in the report.

For example:


 Vector prompts = new Vector();

 prompts.add("Date(2006,01,03)");

 ...

 engine.setPrompt(prompts);

Note: The expression will be executed before any data will be fetched from the database.

Parameters:: prompts - Vector containing parameter field values as String objects, e.g.: "Date(2005,31,12)"
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: getPrompts(), getFields(), Fields.getPromptField(int)

getPrompt

public java.lang.Object getPrompt(int i)
                           throws ReportException

Returns the current value for a parameter field in the report.

Parameters:: i - index in the parameter list
Returns:: parameter field value
Throws:: ReportException - if Engine is not initialized or finished.; java.lang.IndexOutOfBoundsException - if there is no parameter field at the index i.
See Also:: setPrompts(java.util.Vector)

getPrompts

public java.util.Vector getPrompts()
                            throws ReportException

Returns the current values for parameter fields in the report.

Returns:: parameter field values
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: setPrompts(java.util.Vector)

setSproc

public void setSproc(java.lang.String sproc,
                     int i)
              throws ReportException

Sets the value for a stored procedure parameter accessed by the report. Values are assigned to stored procedure parameters in that order the stored procedure is accessed by the report.
This method can be used with reports designed with Crystal Reports, 6.x, only.

Parameters:: sproc - stored procedure parameters; i - index of the stored procedure parameter
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: getSprocs()

setSprocs

@Deprecated
public void setSprocs(java.util.Vector sprocs)
               throws ReportException

Deprecated. As of i-net Crystal-Clear 10.1, use setSproc(String, int)

Sets the values for stored procedure parameters accessed by the report. Values are assigned to stored procedure parameters in that order the stored procedure is accessed by the report.
This method can be used with reports designed with Crystal Reports, 6.x, only.

Parameters:: sprocs - stored procedure parameters
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: getSprocs()

getSproc

@Deprecated
public java.lang.String getSproc(int i)
                          throws ReportException

Deprecated. As of i-net Crystal-Clear 10.1, use TableSource.getInputParameters()

Returns the current value for a stored procedure parameter accessed by the report.
This method can be used with reports designed with Crystal Reports, 6.x, only.

Parameters:: i - index of the stored procedure parameter
Returns:: stored procedure parameters
Throws:: ReportException - if Engine is not initialized or finished.; java.lang.ArrayIndexOutOfBoundsException - If no stored procedure with the given index exists
See Also:: getSprocs(), setSproc(String, int), setSprocs(Vector)

getSprocs

@Deprecated
public java.util.Vector getSprocs()
                           throws ReportException

Deprecated. As of i-net Crystal-Clear 10.1, use TableSource.getInputParameters()

Returns the current values for stored procedure parameters accessed by the report.
This method can be used with reports designed with Crystal Reports, 6.x, only.

Returns:: stored procedure parameters
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: getSproc(int), setSproc(String, int), setSprocs(Vector)

setSql

public void setSql(java.lang.String statement)
            throws ReportException

Replaces all defined tables and joins by this SQL statement. If a record or group selection formula is set, it will still be evaluated after reading the ResultSet. If you do not wish this, you should remove these formulas with setSF(String) and/or setGF(String). This will cause a query to the database for the meta data of the supplied SQL statement. If not all required columns have been specified in the supplied SQL statement this will throw a ReportException with error code 1212.
Note: This can cause a loss of performance or fail for complex SQL statements. If you experience any problem with this method you should use setSqlIgnoreMetaData(String) instead which will not query the meta data for the SQL statement. Please also note that in this case no ReportException will be thrown if the SQL statement does not contain all required columns for the report. The error will occur at execution then. (error code 14)

Parameters:: statement - The SQL statement
Throws:: ReportException - If not all required columns have been specified in the supplied SQL statement (error code 1212) or an error occurred during setting the SQL statement.
See Also:: TableSource.getSql(), setSF(String sf), setSqlIgnoreMetaData(String), ReportProperties.setIgnoreFiltering(boolean), ReportProperties.setIgnoreSorting(boolean)

setSqlIgnoreMetaData

public void setSqlIgnoreMetaData(java.lang.String statement)
                          throws ReportException

Replaces all defined tables and joins of this report with the supplied sql statement. In contrast to setSql(String) this call will not check the supplied sql statement to return all required columns for the report. This means that no request for meta data information will be sent to the database.
If a record or group selection formula is set, it will still be evaluated after reading the ResultSet. If you do not wish this, you should remove these formulas with setSF(String) and/or setGF(String).
Note: As this will not check if all required columns have been specified in the supplied sql statement it is not guaranteed that the report will work with the sql statement. If not all required columns have been specified this will cause a ReportExeption with error code 14 after the engine has been executed with execute(). You can check if an error occurred during rendering by calling getErrorMsg() after execution.

Parameters:: statement - The sql statement which should be executed for this report.
Throws:: ReportException - If an error occured during setting the sql statement.
Since:: 7.5
See Also:: setSql(String), ReportProperties.setIgnoreFiltering(boolean), ReportProperties.setIgnoreSorting(boolean), setSF(String), setGF(String)

setSql

public void setSql(java.lang.String statement,
                   boolean useColumnIndexFromReportDesign)
            throws ReportException

Manually sets the SQL statement that will be send to the database to fetch the report data. If you set a sql statement then this statement will work like a stored procedure that means that the long names "table.column" are not available but only the short name "column".
Instead of using setSql directly, it often can make more sense to call engine.setSF() which overrides the record selection formula ("where ...").
If you want to use long column names (for example table1.field1), then you should set useColumnIndexFromReportDesign to true. This method is meant for advanced users who wish to manually enter their own SQL statment. Note that this is only possible if the report design contains the column names specified in your statement. Furthermore you must create a select statement that matches the column index in the report design (for example you could use the original select statement from the report designer and then modify the where and order by clause only).

Parameters:: statement - The SQL statement; useColumnIndexFromReportDesign - is obsolete.
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: TableSource.getSql(), setSF(String sf)

getDefaultSql

@Deprecated
public java.lang.String getDefaultSql()
                               throws ReportException

Deprecated. As of i-net Crystal-Clear 10.0, use getDefaultSqlOfAllStatements(boolean)

Returns the SQL statement that i-net Clear Reports will generate and send to the database. If the report is based on a stored procedure or a view, then this method does not return a meaningful result.

Returns:: SQL statement for command of datasource connection 0; or SQL statement for entire connection if only tables and views are in the connection.
Throws:: ReportException - if Engine is not initialized or finished, or if there are not only tables/views in the connection, or if
See Also:: setSql(String), TableSource.getSql()

getDefaultSqlOfAllStatements

public java.lang.String[] getDefaultSqlOfAllStatements(boolean leavePrompts)
                                                throws ReportException

Returns the statements that will be send to the database.

Parameters:: leavePrompts - If true, PromptFields used in the statement will be replaced by its placeholder.
Returns:: The statements that will be send to the database.
Throws:: ReportException - If creating the statements failed or the engine is finished.
Since:: 6.0

setUser

public void setUser(java.lang.String user)
             throws ReportException

Sets the same username for all reports (main and subreports) for logging on to password protected databases used by the report.
This function is a convenience function that sets the username for the main and all sub reports. Please see the appopriate function in DataSourcConfiguration which only modifies the username of the current datasource.
Note that this method only points to the first Datasource of the report and sub reports.

Parameters:: user - username for all reports (inclusive subreports)
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: setPassword(String), getDatabaseTables(), DataSourceConfiguration.setUser(String)

setPassword

public void setPassword(java.lang.String password)
                 throws ReportException

Sets the password for the main and all subreports for logging on to SQL, ODBC, or password protected databases used by the report.
This function is a convenience function that also sets the password for the main and all sub reports. Please see the appopriate function in DataSourceConfiguration which only modifies the parameters of the current datasource.
Note that this method only points to the first Datasource of the report and sub reports.

Parameters:: password - password(s)
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: setUser(String), getDatabaseTables(), DataSourceConfiguration.setPassword(String)

setErrorMsg

public void setErrorMsg(java.lang.String msg)

Sets an error message. This error message can be requested with getErrorMsg().

Parameters:: msg - the error message.
See Also:: getErrorMsg()

getErrorMsg

public java.lang.String getErrorMsg()

Returns the error message as string. If there is no error or if the report has not been completely finished, null is returned. To check whether the engine is done, use isFinish().

Returns:: error message, or null if the report was not finished or there was no error.
See Also:: setErrorMsg(java.lang.String)

getFields

public Fields getFields()
                 throws ReportException

Returns a new Fields Object.

Example: getting names and values of all parameterfields (prompts) and printing them to stdout


 // getting all fields, where eng referenzes your Engine - instance, you want to use 

 Fields fields = eng.getFields();

 // getting count of prompts 

 int promptsCount = fields.getPromptFieldsCount();

 PromptField promptField = null;

 // for all prompts in fields

 for (int i=0;i<promptsCount;i++){

   // getting single PromptField at position i

   promptField = (PromptField)getPromptField( i );

   // print name and value to stdout

   System.out.println(promptField.getName() + " : " + promptField.getPrompValue());

 }

Note that PromptField.getPromptValue() returns an Object, so check whether you need to cast or not.

Returns:: new Fields Object
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: Fields, PromptField, FormulaField, DatabaseField, SQLField, SortField, GroupField, SummaryField

getSubReport

public Engine getSubReport(int idx)
                    throws ReportException

Every engine object of a main report may have several subreport engines. This method returns the i'th subreport engine of the current main report. The range is from 0..n.

Parameters:: idx - The 0-based index of subreport
Returns:: the subreport engine
Throws:: ReportException - will thrown if no subreport is available, or idx is greater than size of subreport set or if Engine is not initialized or finished.
See Also:: getSubReportCount()

getSubReportElement

public Subreport getSubReportElement()
                              throws ReportException

Returns the subreport element of the main report. Use this method to get the corresponding element of the current subengine. If the current engine is a main report this methode will return null.

Returns:: subreport element of this engine or null if current engine is a main report engine.
Throws:: ReportException - if Engine is not initialized or engine is finished

getSubReportCount

public int getSubReportCount()
                      throws ReportException

Returns the number of sub-reports.

Returns:: the number of sub-reports
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: getSubReport(int idx)

setDataSourceConfigurationName

public void setDataSourceConfigurationName(java.lang.String datasourceName)
                                    throws ReportException

Sets the name of datasource configuration. All information to create the Connection will be used from this configuration. This function is a convenience function that sets the datasource name for the main report and all sub reports. Please see the appopriate function in DatabaseTables which only modifies the parameters of the current report. You can also set not existing values and save the report before you deploy it in an enviroment.

This method only points to the first Datasource of the report and sub reports.

Parameters:: datasourceName - Name of the datasource configuration
Throws:: ReportException - if Engine is not initialized or finished.
Since:: 9.0
See Also:: setCatalog(String), Datasource.setDataSourceConfigurationName(String), getDatabaseTables(), DatabaseTables.getDatasource(int)

getMajorVersion

public static int getMajorVersion()

Returns the Engine's major version number.

Returns:: Major version of the engine
See Also:: getMinorVersion(), getVersion()

getMinorVersion

public static int getMinorVersion()

Returns the Engine's minor version number.

Returns:: Minor version of the engine
See Also:: getMajorVersion(), getVersion()

getVersion

public static java.lang.String getVersion()

Returns the release version of this i-net Clear Reports installation, e.g. "8.1.24"

Returns:: Version of the engine as a String
See Also:: getMajorVersion(), getMinorVersion()

getReportFile

public java.net.URL getReportFile()
                           throws ReportException

Returns the url of the report template file.

Returns:: URL of the report template file
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: setReportFile(String), setReportFile(java.net.URL)

getSummaryInfo

public SummaryInfo getSummaryInfo()
                           throws ReportException

Returns the SummaryInfo class with that you can get/set the report summary info specified in the "Summary Info" of the Reports Designer or with the setXXX methods in the class SummaryInfo.
For example:

Engine eng = new Engine();
eng.setReportFile( "file:C:/MyReports/Report1.rpt" );
SummaryInfo su = eng.getSummaryInfo();
System.out.println("created: "+su.getCreated());
System.out.println("LastSaved: "+su.getLastSaved());
System.out.println("Author: "+su.getAuthor());
System.out.println("Subject: "+su.getSubject());
System.out.println("ReportTitle: "+su.getReportTitle());

Returns:: SummaryInfo object of this report with information about when the report was created, last saved, as well as other information
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: SummaryInfo

getTranslations

public Translations getTranslations()
                             throws ReportException

Get the Translations of the report.

Returns:: the Translations associate with the current report, never null
Throws:: ReportException - if Engine is not initialized or finished.
Since:: 9.1

getReportTitle

public java.lang.String getReportTitle()
                                throws ReportException

Returns the title of the report specified either in the "Summary Info" dialog of the report designer or with the method setReportTitle.
You need to set the report name with the method setReportFile before you can call this method.

Returns:: the value of the report title.
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: setReportTitle(String), setReportFile(String)

setReportTitle

public void setReportTitle(java.lang.String title)
                    throws ReportException

Sets the title of the report. This overrides the title in the rpt file summary. You can use this value in the report template with the Special Field "Report Title".
You need to call this method after the call of setReportFile.

Parameters:: title - the value of the new title.
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: getReportTitle()

getQueryFile

public java.lang.String getQueryFile()
                              throws ReportException

Returns the name of the query file that was specified at design time, in the report url or with the method setQueryFile.

Returns:: the name of the query file.
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: setQueryFile(java.net.URL, int)

setQueryFile

public void setQueryFile(java.net.URL url,
                         int i)
                  throws ReportException

Sets the name of the query file for subreport $n$. This overrides the name of the subreport's query file in the rpt file. Use this if you've moved your subreport's query file to a different name/location.
You need to call this method right before the call of setReportFile.

Parameters:: i - the id of the corresponding report; url - the name of the new query file.
Throws:: ReportException - if Engine is finished.
See Also:: setQueryFile(java.net.URL url), getQueryFile()

setQueryFile

public void setQueryFile(java.net.URL url)
                  throws ReportException

Sets the name of the query file in main report. This overrides the name in the rpt file summary. Use this if you've moved your query file to a different name/location on your hard disc.
You need to call this method right before the call of setReportFile.

Parameters:: url - the name of the new query file.
Throws:: ReportException - if Engine is finished.
See Also:: setQueryFile(java.net.URL url, int i), getQueryFile()

setTime

public void setTime(long time)

Sets a timestamp. This function can be used to make a timestamp for the last request. This can be used to manage an engine pool in a webserver. This has no effect to the engine.

Parameters:: time - the time in millis.
See Also:: getTime(), getCacheSize()

getTime

public long getTime()

Returns the timestamp that was set with setTime.

Returns:: time in millis.
See Also:: setTime(long), getCacheSize()

getCacheSize

public int getCacheSize()

This function returns the current cache size. This is the size of the binary page data. A servlet or a report server (for example the com.inet.report.Listener) can use it to limit the size of all cached reports for all users.

Returns:: number of bytes of the binary data.

setReportFile

public void setReportFile(java.lang.String url)
                   throws ReportException

Sets the report template file. This is the main method. You need to call this method at first after you have instanciated the engine. If the URL does not include a protocol then it will be encoded. If the URL include a protocol then it must already be encoded, if needed.
For example:

 Engine engine = new Engine( ... );
 engine.setReportFile( ... );
 ...

Parameters:: url - the url of the report template file.
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: setReportFile(java.net.URL), RDC.loadEngine(File), RDC.loadEngine(File, String), RDC.loadEngine(URL, java.io.InputStream, String, Properties)

setReportFile

public void setReportFile(java.net.URL url)
                   throws ReportException

Sets the report file URL. This is the main method. You need to call this method at first after you have instanciated the engine.
For example:

 Engine eng = new Engine(...);
 eng.setReportFile( ... );
 ...

Parameters:: url - the url of the report template file.
Throws:: ReportException - if Engine is not initialized or finished.
See Also:: setReportFile(String), RDC.loadEngine(File), RDC.loadEngine(File, String), RDC.loadEngine(URL, java.io.InputStream, String, Properties)

getGroupTree

public byte[] getGroupTree()
                    throws ReportException

Returns the group tree which can be sent to the java viewer as a byte array.

Returns:: byte[] Group Tree as byte array.
Throws:: ReportException - If a problem occurs while group tree creation

getSections

public java.util.Vector getSections()
                             throws ReportException

Returns a vector containing all sections the report consists of.

Returns:: java.util.Vector A set of all sections contained in the report or null if no sections are contained.
Throws:: ReportException - if Engine is finished

getArea

public Area getArea(int idx)
             throws ReportException

Returns an AreaElement of the Area set. The index specifies the returned Area-Element, where
0 - report header,
1 - page header,
2 - details,
3 - reports footer and
4 - page footer.

if this report is a main report.
Group/Summary area pairs are inserted from position 5. So if your report contains two groups, the areas 5/6 and 7/8 hold the group header/footer for the two groups.
Note: If this report is an embedded subreport the indicies 1 (for page header) and 4 (for page footer) does not exists and null will returned. To get group 1 header use idx=5. To get group 1 footer use idx=6, to get group 2 header use idx=7 etc. (same as main reports).

Parameters:: idx - The 0-based index of returned Area in set.
Returns:: Area object specified by the given index
Throws:: ReportException - if Engine is finished; java.lang.IndexOutOfBoundsException - If there is no area specified by the given index
See Also:: PAGE_FOOTER, PAGE_HEADER, DETAILS, REPORT_HEADER, REPORT_FOOTER, Area

getArea

public Area getArea(java.lang.String item)
             throws ReportException

Returns an area element of the set of areas. The item specifies the returned area element.

Parameters:: item - Specifies the returned area (using the AREA_TYPE constants)
Note: If this report is an embedded subreport, AREA_TYPE_PAGE_HEADER and AREA_TYPE_PAGE_FOOTER will not work, since these areas do not exist and null will returned.
Returns:: Area object of the area type specified
Throws:: ReportException - if Engine is finished; java.lang.IllegalArgumentException - If the given area type is not valid. Valid types are defined by the AREA_TYPE constants
See Also:: getArea(int), AREA_TYPE_REPORT_HEADER, AREA_TYPE_PAGE_HEADER, AREA_TYPE_GROUP_HEADER_PREFIX, AREA_TYPE_DETAIL, AREA_TYPE_GROUP_FOOTER_PREFIX, AREA_TYPE_REPORT_FOOTER, AREA_TYPE_PAGE_FOOTER

getAreaCount

public int getAreaCount()
                 throws ReportException

Returns the number of Areas of the report. A report can consist of a page area (except sub reports), a report area, a detail area and as many group areas as there are groups in the report.

Returns:: the number of Areas of this report
Throws:: ReportException - if Engine is finished or no report is set.

getDatabaseTables

public DatabaseTables getDatabaseTables()
                                 throws ReportException

Returns the DatabaseTables object for this report. You need this object if you want to modify the data source and/or if you want to add or remove tables, stored procedures, joins or if you want to read the data source from a query file.

Returns:: DatabaseTables object for this report, containing information about datasources and table sources referenced and used by this report.
Throws:: ReportException - if Engine is finished or no report is set.
See Also:: DatabaseTables

addGroup

public Group addGroup(Field groupField)
               throws ReportException

Adds a newly created grouping into the grouping set and returns it. The data in this grouping will be sorted by the specified field.

Parameters:: groupField - Field to group the data in the newly created group by.
Returns:: The newly created Group object.
Throws:: ReportException - if the engine is finished, or the report structure is corrupt
See Also:: Group, addGroup(Field), getGroup(int), getGroupCount(), removeGroup(Group), removeGroup(int)

getGroupCount

public int getGroupCount()
                  throws ReportException

Returns the count of groupings in report without the count of page, report and detail area pairs.

Returns:: The count of groupings in report.
Throws:: ReportException - if Engine is not initialized or finished.; java.lang.IllegalStateException - If the Engine has not been initialized correctly
See Also:: Group, addGroup(Field), getGroup(int), removeGroup(Group), removeGroup(int)

removeGroup

public void removeGroup(Group group)
                 throws ReportException

Removes the given group object from engine.

Parameters:: group - The group which should be removed.
Throws:: ReportException - Thrown if the group is not in engine or the engine is finished

removeGroup

public void removeGroup(int grNum)
                 throws ReportException

Remove the group specified with parameter grNum. The value of the paramter must be between 1 and count of groups in the report. Otherwise, and if no group was specified, an exception will be thrown.

Parameters:: grNum - The 1-based number of the group which should be removed. Must be between 1 and count of groups. At least one group should be defined in the report. Use Group.indexOf() when having the group object.
Throws:: ReportException - will be thrown if the value of the parameter is greater than count of groups defined in the report, if no groups were defined in the report or if the value of the parameter is less than 1. If the Engine is finished.
See Also:: Group, addGroup(Field), getGroup(int), getGroupCount(), Group.indexOf(), removeGroup(Group)

getGroup

public Group getGroup(int grNum)
               throws ReportException,
                      java.lang.IndexOutOfBoundsException

Returns the grouping with the specified number, where number is greater than 1 or lesser than count of groupings.

Parameters:: grNum - The 1-based number of the grouping which should be returned. Must be between 1 and count of groupings in report.
Returns:: With parameter grNum specified grouping.
Throws:: ReportException - if Engine is not initialized or finished.; java.lang.IndexOutOfBoundsException - If the given index does not specify an actual group
See Also:: Group, addGroup(Field), getGroupCount(), removeGroup(Group)

getGroupByField

public Group getGroupByField(Field field)
                      throws ReportException

Returns the group which is based on the parameter field if exists - otherwise null is returned.

Parameters:: field - The field the Group is based on.
Returns:: Group
Throws:: ReportException - if the engine is finished

moveGroup

public void moveGroup(int source,
                      int dest)
               throws ReportException

Moves the group with group number source to target.

Parameters:: source - the 1-based number of the group which should moved to target.; dest - the 1-based destination of moving.
Throws:: ReportException - if the engine is finished

isXml

@Deprecated
public boolean isXml()

Deprecated. As of i-net Clear Reports, use ReportProperties.isCCFormat().

Returns true if the report comes from i-net Clear Reports file format, else false.

Returns:: Whether or not the report is based on a template in i-net Clear Reports RPT format.

setPrintDate

public void setPrintDate(java.util.Date date)
                  throws ReportException

Sets the print date for this report.

Parameters:: date - Date object to use as the current point in time
Throws:: ReportException - if Engine is finished

getPrintDate

public java.util.Date getPrintDate()
                            throws ReportException

Returns the print date for this report.

Returns:: The printing time of this report. Might have been changed with setPrintDate(java.util.Date)
Throws:: ReportException - if Engine is finished

getLoadExceptions

public java.lang.Exception[] getLoadExceptions()

If one or more errors occurred while loading a report template, you can get this error(s) as Exception[] from engine. If no errors has occurred null will be returned.

Returns:: Exception[] if an exception has occurred or null

setMsgListener

public void setMsgListener(com.inet.report.RDC.MsgListener msgl)

Sets the MsgListener for RDC.

Parameters:: msgl - The object which implements the RDC.MsgListener interface and should handle the queries from RDC to the user.

getMsgListener

public com.inet.report.RDC.MsgListener getMsgListener()

Returns the MsgListener for RDC.

Returns:: The object which implements the RDC.MsgListener interface and should handle the queries from RDC to the user.

isSubEngine

public boolean isSubEngine()
                    throws ReportException

Returns whether this engine is an engine of a subreport (true) or not (false).

Returns:: boolean
Throws:: ReportException - if the engine has already been executed.

getStatus

public EngineStatus getStatus()

Returns an EngineStatus object including information about the status of this Engine . If this is a sub report Engine this will throw an ReportException.

Returns:: The !EngineStatus object for this Engine .
Throws:: java.lang.IllegalStateException - If this Engine is a sub report Engine
Since:: 8.2
See Also:: getParent()

getReportProperties

public ReportProperties getReportProperties()
                                     throws ReportException

Returns the reports global properties.

Returns:: Returns the report properties.
Throws:: ReportException - if Engine is not initialized or finished

getEmbeddableFontNames

public static java.util.List getEmbeddableFontNames()

Returns true type font names for all fonts from fontPath (set in the i-net Clear Reports configuration) that are licensed for embedding.

Note 1: true type collection file (.ttc) can contain multiple true type fonts
Note 2: each true type font can have one or more font names and all these names will be listed
Note 3: as a result the number of true type font names returned does not coincide with the number of font files in font directory.

Returns:: the list with font names as strings or empty list, if fontPath is not defined or if the font directory contains no true type fonts
Since:: 6.0

addClippingListener

public void addClippingListener(ClippingListener listener)

Registers a clipping listener with the engine - any time an element is clipped while rendering, this listener's method "clippingOnElement" is called

Parameters:: listener - Listener to be registered.
Since:: 6.1
See Also:: ClippingListener, ClippingEvent

removeClippingListener

public void removeClippingListener(ClippingListener listener)

Unregisters a clipping listener with the engine.

Parameters:: listener - Listener to be unregistered.
Since:: 6.1
See Also:: ClippingListener, ClippingEvent

addFinishListener

public void addFinishListener(EngineFinishListener listener)

Add a EngineFinishListener to this engine. The Listener will be informed if the engine is finish.

Parameters:: listener - EngineFinishListener to notify when the engine is finished rendering.
Since:: 6.1
See Also:: removeFinishListener(com.inet.report.event.EngineFinishListener), EngineFinishListener

removeFinishListener

public void removeFinishListener(EngineFinishListener listener)

Remove a EngineFinishListener that was added with addFinishListener.

Parameters:: listener - EngineFinishListener to no longer notify when the engine is done rendering
Since:: 6.1
See Also:: addFinishListener(com.inet.report.event.EngineFinishListener), EngineFinishListener

getVariableReferences

public FormulaField[] getVariableReferences(java.lang.String varName)
                                     throws ReportException

Returns an array of all FormulaFields referencing the variable with the name varName - this array is empty if there is no such FormulaField referencing the variable. Note that only global and shared variables are searched for references, since local variables are only referenced from within a single formula.

Parameters:: varName - The name of the variable to search for references. Case-insensitive.
Returns:: An array of all formula fields referencing this variable.
Throws:: ReportException - if Engine is finished

getMetaProperties

public java.util.Properties getMetaProperties()

Returns any meta properties belonging to this engine. This is NOT a copy but the actual Properties itself - adding or removing properties to this Properties object will add or remove them for this engine. Note that these properties will have NO effect on the rendering of a report. Note also that properties with the prefix "designer" are reserved for use by i-net Designer and should therefore not be used or manipulated. Properties should be string pairs of keys and values: non-string values will lead to issues when saving. See the documentation for Properties

Returns:: purely design-time meta properties of this engine. never null.
Since:: 10.0

setMetaProperties

public void setMetaProperties(java.util.Properties props)

Sets (and overwrites!) the meta properties which will be stored in the report file if the engine is saved and retrieved if this report file is loaded. Note that these properties will have NO effect on the rendering of a report. Note also that properties with the prefix "designer" are reserved for use by i-net Designer and should therefore not be used or manipulated. Finally, note that any existing meta properties will be overwritten by this method. If you only want to add properties to the report, use getMetaProperties() instead and add your properties to the Properties object.

Parameters:: props - Properties to set. May not be null.
Throws:: java.lang.IllegalArgumentException - if props is null
Since:: 10.0

getReportID

public int getReportID()

Returns the identifier of this report element. In case 0 is returned, this is the main report. If the value is greater zero, it is a subreport.
Please note that this ID is save/load persistant while the subreport index is not. DO NOT use this ID with the function getSubReport(int) since ID and index are different.

Returns:: the ID of this report element
Since:: 10.0

getTrigger

public Trigger getTrigger()

Request the Trigger object of this Engine. You need to set the Trigger Formula before you execute the report.

Returns:: the Trigger
Since:: 11.1

Overview

Package

Class

Use

Deprecated

Help

i-net Clear Reports

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.inet.report Class Engine

AREA_TYPE_REPORT_HEADER

AREA_TYPE_PAGE_HEADER

AREA_TYPE_GROUP_HEADER_PREFIX

AREA_TYPE_DETAIL

AREA_TYPE_GROUP_FOOTER_PREFIX

AREA_TYPE_REPORT_FOOTER

AREA_TYPE_PAGE_FOOTER

REPORT_HEADER

PAGE_HEADER

DETAILS

REPORT_FOOTER

PAGE_FOOTER

NO_EXPORT

EXPORT_PDF

EXPORT_RTF

EXPORT_HTML

EXPORT_XLS

EXPORT_XML

EXPORT_TXT

EXPORT_CSV

EXPORT_PS

EXPORT_PS2

EXPORT_PS3

EXPORT_DATA

EXPORT_SVG

EXPORT_PNG

EXPORT_GIF

EXPORT_JPG

EXPORT_BMP

LOG_STATUS

LOG_ERROR

LOG_WARN

LOG_INFO

LOG_DEBUG

Engine

Engine

shutdown

getRecordCount

getCreator

setCreator

setLocale

setClientLocale

getLocale

setNumeralLanguage

getNumeralLanguage

setUserProperties

getUserProperties

getUserData

setUserData

getParent

execute

getPageData

getFontData

getPageCount

getDocumentPageCount

setCatalog

setSchema

setData

setData

setData

setConnection

setConnectionCloseOnFinishing

stopAfterPage

stop

stop

isPageLimitExceeded

stopAll

setData

setLogStream

setLogLevel

getLogStream

getLogLevel

setGF

getGF

getGFField

setSF

getSF

getSFField

setPrompt

com.inet.report
Class Engine