Using Birt with Jide/Jformdesigner

I would like to integrate birt inside of an another application which uses jide. Currently below code will display pictures but no graphs at all. is there any other way to use birt more efficiently inside jide.

i am using birt 2.6.1 with eclipse helios.

public class HtmlReport2 extends JPanel

{
JEditorPane myEditorPane = new JEditorPane() ;
IReportRunnable design = null;
HtmlReport2()
{
initComponents();

}
/**
* Initialize the components.
*/
protected void initComponents() {
setLayout(new FormLayout("fill:p:grow", "fill:p:grow"));
setBackground(new Color(216, 228, 248));
startPlatform();
runReport();
stopPlatform();
}

public void runReport()

{
try {

CellConstraints cc = new CellConstraints();
setBorder(Borders.DLU4_BORDER);
// Open the report design
design = engine.openReportDesign("C:\\Projects\\loki\\Tracs8.0\\new_report.rptdesign");
// Create task to run and render the report,
IRunAndRenderTask task = engine.createRunAndRenderTask(design);
HTMLRenderOption options = new HTMLRenderOption();
ByteArrayOutputStream bos = new ByteArrayOutputStream();
options.setOutputStream(bos);
options.setSupportedImageFormats( "PNG;GIF;JPG;BMP;SWF");
options.setOutputFormat("html");
options.setEmbeddable(true);
options.setEnableInlineStyle(true);
task.setRenderOption(options);
task.run();
task.close();
myEditorPane.setContentType("text/html");
myEditorPane.setText(bos.toString());
myEditorPane.setBackground(new Color(216, 228, 248));
myEditorPane.setEditable(false);
JScrollPane scrollPane = new JScrollPane(myEditorPane);
add(myEditorPane, cc.xy(1, 1));
} catch (Exception ex) {
ex.printStackTrace();
}

}

public void startPlatform() {
try {
config = new EngineConfig();
config.setBIRTHome("C:\\birt-runtime-2_6_1\\ReportEngine");
Platform.startup(config);
IReportEngineFactory factory = (IReportEngineFactory) Platform
.createFactoryObject(IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY);
engine = factory.createReportEngine(config);
} catch (Exception e) {
e.printStackTrace();
}
}

public void stopPlatform() {
engine.destroy();
Platform.shutdown();

}}

Error i am getting !!!!!!!!!!!
java.lang.NullPointerException
at org.eclipse.birt.chart.reportitem.ChartReportItemImpl.doCompatibility(ChartReportItemImpl.java:314)
at org.eclipse.birt.chart.reportitem.ChartReportItemImpl.deserialize(ChartReportItemImpl.java:294)
at org.eclipse.birt.report.model.extension.PeerExtensibilityProvider.initializeReportItem(PeerExtensibilityProvider.java:580)
at org.eclipse.birt.report.model.elements.ExtendedItem.initializeReportItem(ExtendedItem.java:307)
at org.eclipse.birt.report.model.elements.ExtendedItem.doCheck(ExtendedItem.java:642)
at org.eclipse.birt.report.model.elements.ExtendedItem.checkCompatibility(ExtendedItem.java:604)
at org.eclipse.birt.report.model.parser.ModuleParserHandler.handleExtendedItemCompatibility(ModuleParserHandler.java:455)
at org.eclipse.birt.report.model.parser.ModuleParserHandler.endDocument(ModuleParserHandler.java:417)
at org.apache.xerces.parsers.AbstractSAXParser.endDocument(Unknown Source)
at org.apache.xerces.impl.XMLDocumentScannerImpl.endEntity(Unknown Source)
at org.apache.xerces.impl.XMLEntityManager.endEntity(Unknown Source)
at org.apache.xerces.impl.XMLEntityScanner.load(Unknown Source)
at org.apache.xerces.impl.XMLEntityScanner.skipSpaces(Unknown Source)
at org.apache.xerces.impl.XMLDocumentScannerImpl$TrailingMiscDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.DTDConfiguration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at javax.xml.parsers.SAXParser.parse(Unknown Source)
at org.eclipse.birt.report.model.parser.ModuleReader.readModule(ModuleReader.java:94)
at org.eclipse.birt.report.model.parser.DesignReader.read(DesignReader.java:88)
at org.eclipse.birt.report.model.core.DesignSessionImpl.openDesign(DesignSessionImpl.java:315)
at org.eclipse.birt.report.model.api.SessionHandleImpl.openDesign(SessionHandleImpl.java:294)
at org.eclipse.birt.report.engine.parser.ReportParser.getDesignHandle(ReportParser.java:158)
at org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.getReportDesignHandle(ReportEngineHelper.java:255)
at org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.openReportDesign(ReportEngineHelper.java:274)
at org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.openReportDesign(ReportEngineHelper.java:196)
at org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.openReportDesign(ReportEngineHelper.java:130)
at org.eclipse.birt.report.engine.api.impl.ReportEngine.openReportDesign(ReportEngine.java:295)
at tracs.ticket.ui.reports.AlarmSummaryReportPanel$HtmlReport2.runReport(AlarmSummaryReportPanel.java:299)
at tracs.ticket.ui.reports.AlarmSummaryReportPanel$HtmlReport2.initComponents(AlarmSummaryReportPanel.java:286)
at tracs.ticket.ui.reports.AlarmSummaryReportPanel$HtmlReport2.<init>(AlarmSummaryReportPanel.java:276)
at tracs.ticket.ui.reports.AlarmSummaryReportPanel.initComponents(AlarmSummaryReportPanel.java:224)
at tracs.ticket.ui.reports.AlarmSummaryReportPanel.init(AlarmSummaryReportPanel.java:203)
at tracs.ticket.ui.reports.AlarmSummaryReportPanel.<init>(AlarmSummaryReportPanel.java:94)
at tracs.uiticketframework.TicketViewController.openAlarmReportPanel(TicketViewController.java:1351)
at tracs.ticket.ui.reports.TracsReportsDialog.okSelected(TracsReportsDialog.java:210)
at tracs.ticket.ui.reports.TracsReportsDialog.access$100(TracsReportsDialog.java:50)
at tracs.ticket.ui.reports.TracsReportsDialog$2.actionPerformed(TracsReportsDialog.java:140)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.Dialog$1.run(Unknown Source)
at java.awt.Dialog$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Dialog.show(Unknown Source)
at com.jidesoft.dialog.StandardDialog.show(Unknown Source)
at java.awt.Component.show(Unknown Source)
at java.awt.Component.setVisible(Unknown Source)
at java.awt.Window.setVisible(Unknown Source)
at java.awt.Dialog.setVisible(Unknown Source)
at tracs.uiticketframework.TicketViewController.openTracsReportsDialog(TicketViewController.java:1604)
at tracs.uiticketframework.TicketTaskListDialog.openTracsReports(TicketTaskListDialog.java:216)
at tracs.uiticketframework.TicketTaskListDialog.access$1700(TicketTaskListDialog.java:40)
at tracs.uiticketframework.TicketTaskListDialog$9.actionPerformed(TicketTaskListDialog.java:131)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at com.jidesoft.plaf.basic.BasicJideButtonListener.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

Find more posts tagged with

Comments

JasonW

If you are using 2.6.2 why are you setting BIRT home to 2.6.1. Does your application continue to run after generating the report? If so you should start the platform up when your app starts and shut it down when your app shuts down.

In your render options where are you setting the image directory?
htmlOptions.setImageDirectory("output/image");

Jason

asilo1

sorry about typo i am using 2.6.1

void runReport()

{
try {

CellConstraints cc = new CellConstraints();
setBorder(Borders.DLU4_BORDER);
// Open the report design
design = engine.openReportDesign("C:\\Projects\\loki\\Tracs8.0\\gmsSelfCare.rptdesign");
// Create task to run and render the report,
IRunAndRenderTask task = engine.createRunAndRenderTask(design);
HTMLRenderOption options = new HTMLRenderOption();
ByteArrayOutputStream bos = new ByteArrayOutputStream();
options.setOutputStream(bos);
options.setSupportedImageFormats( "PNG;GIF;JPG;BMP;SWF");
options.setOutputFormat("html");
options.setEmbeddable(true);
options.setImageDirectory("output/image");
options.setEnableInlineStyle(true);
task.setRenderOption(options);
task.run();
task.close();
myEditorPane.setContentType("text/html");
myEditorPane.setText(bos.toString());
myEditorPane.setBackground(new Color(216, 228, 248));
myEditorPane.setEditable(false);
JScrollPane scrollPane = new JScrollPane(myEditorPane);
add(myEditorPane, cc.xy(1, 1));
}

i made the change but i still get the same error. i can show pictures and tables fine. only graphs seems to be problem.

thanks in advance

JasonW

Set the image directory to a full path ie c:/temp and see if the image for the chart gets generated. From the stack trace it looks like something is wrong with the chart model. Can you post the report?

Jason

asilo1

this will be the xml source for the report without the graph i can get the info and print a table. i have a feeling it has to do with libraries but at the same time. i just start using birt.

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.6.2.r262_v20110209 Build <2.6.2.v20110219-1842></property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="layoutPreference">fixed layout</property>
<property name="bidiLayoutOrientation">ltr</property>
<property name="imageDPI">96</property>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="GMS_performance" id="31">
<list-property name="privateDriverProperties">
<ex-property>
<name>contentBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
<ex-property>
<name>metadataBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
</list-property>
<property name="odaDriverClass">oracle.jdbc.driver.OracleDriver</property>
<property name="odaURL">jdbc:oracle:thin:@ogo:1521:sioraprd</property>
<property name="odaUser">tr071prf</property>
<encrypted-property name="odaPassword" encryptionID="base64">dHIwNzFwcmY=</encrypted-property>
</oda-data-source>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Tracs Demo" id="43">
<list-property name="privateDriverProperties">
<ex-property>
<name>contentBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
<ex-property>
<name>metadataBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
<ex-property>
<name>disabledMetadataBidiFormatStr</name>
</ex-property>
<ex-property>
<name>disabledContentBidiFormatStr</name>
</ex-property>
</list-property>
<property name="odaDriverClass">oracle.jdbc.driver.OracleDriver</property>
<property name="odaURL">jdbc:oracle:thin:@ogo:1521:sioraprd</property>
<property name="odaUser">tr071dmo</property>
<encrypted-property name="odaPassword" encryptionID="base64">dHIwNzFkbW8=</encrypted-property>
</oda-data-source>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="99">
<list-property name="privateDriverProperties">
<ex-property>
<name>contentBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
<ex-property>
<name>metadataBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
</list-property>
<property name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver</property>
<property name="odaURL">jdbc:classicmodels:sampledb</property>
<property name="odaUser">ClassicModels</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="gms_data_set" id="32">
<list-property name="columnHints">
<structure>
<property name="columnName">TKT_ID</property>
<text-property name="displayName">TKT_ID</text-property>
<text-property name="heading">TKT_ID</text-property>
</structure>
<structure>
<property name="columnName">CONTACT_NAME</property>
<text-property name="displayName">CONTACT_NAME</text-property>
<text-property name="heading">CONTACT_NAME</text-property>
</structure>
<structure>
<property name="columnName">CONTACT_NUMBER</property>
<text-property name="displayName">CONTACT_NUMBER</text-property>
<text-property name="heading">CONTACT_NUMBER</text-property>
</structure>
<structure>
<property name="columnName">SERVICE_GROUP_DESCRIPTION</property>
<text-property name="displayName">SERVICE_GROUP_DESCRIPTION</text-property>
<text-property name="heading">SERVICE_GROUP_DESCRIPTION</text-property>
</structure>
<structure>
<property name="columnName">SERVICE_DESCRIPTION</property>
<text-property name="displayName">SERVICE_DESCRIPTION</text-property>
<text-property name="heading">SERVICE_DESCRIPTION</text-property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">TKT_ID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CONTACT_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CONTACT_NUMBER</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">SERVICE_GROUP_DESCRIPTION</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">SERVICE_DESCRIPTION</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">GMS_performance</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">TKT_ID</property>
<property name="nativeName">TKT_ID</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CONTACT_NAME</property>
<property name="nativeName">CONTACT_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CONTACT_NUMBER</property>
<property name="nativeName">CONTACT_NUMBER</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">SERVICE_GROUP_DESCRIPTION</property>
<property name="nativeName">SERVICE_GROUP_DESCRIPTION</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">SERVICE_DESCRIPTION</property>
<property name="nativeName">SERVICE_DESCRIPTION</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select TR071PRF.VTM024TROUBLE_TKT.TKT_ID,TR071PRF.VTM078TKT_CONTACT_INFO.CONTACT_NAME, TR071PRF.VTM078TKT_CONTACT_INFO.CONTACT_NUMBER, TR071PRF.VTM021SERVICE_GRP.SERVICE_GROUP_DESCRIPTION, TR071PRF.VTM022SERVICE.SERVICE_DESCRIPTION from TR071PRF.VTM024TROUBLE_TKT,TR071PRF.VTM078TKT_CONTACT_INFO,TR071PRF.VTM021SERVICE_GRP, TR071PRF.VTM022SERVICE WHERE TR071PRF.VTM078TKT_CONTACT_INFO.UNQ_TASK_ID=TR071PRF.VTM024TROUBLE_TKT.UNQ_TASK_ID AND TR071PRF.VTM024TROUBLE_TKT.SERVICE_ID=TR071PRF.VTM022SERVICE.SERVICE_ID AND TR071PRF.VTM024TROUBLE_TKT.SERVICE_GROUP_ID=TR071PRF.VTM021SERVICE_GRP.SERVICE_GROUP_ID AND TR071PRF.VTM024TROUBLE_TKT.SOURCE_CD='Web Portal' ORDER BY TKT_ID]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>TKT_ID</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>11</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>TKT_ID</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>TKT_ID</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CONTACT_NAME</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>25</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>CONTACT_NAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>CONTACT_NAME</design:label>
<design:formattingHints>
<design:displaySize>25</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CONTACT_NUMBER</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>CONTACT_NUMBER</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>CONTACT_NUMBER</design:label>
<design:formattingHints>
<design:displaySize>10</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>SERVICE_GROUP_DESCRIPTION</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>100</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>SERVICE_GROUP_DESCRIPTION</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>SERVICE_GROUP_DESCRIPTION</design:label>
<design:formattingHints>
<design:displaySize>100</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>SERVICE_DESCRIPTION</design:name>
<design:position>5</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>100</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>SERVICE_DESCRIPTION</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>SERVICE_DESCRIPTION</design:label>
<design:formattingHints>
<design:displaySize>100</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="gms_data_set1" id="44">
<list-property name="columnHints">
<structure>
<property name="columnName">TKT_ID</property>
<text-property name="displayName">TKT_ID</text-property>
<text-property name="heading">TKT_ID</text-property>
</structure>
<structure>
<property name="columnName">CONTACT_NAME</property>
<text-property name="displayName">CONTACT_NAME</text-property>
<text-property name="heading">CONTACT_NAME</text-property>
</structure>
<structure>
<property name="columnName">CONTACT_NUMBER</property>
<text-property name="displayName">CONTACT_NUMBER</text-property>
<text-property name="heading">CONTACT_NUMBER</text-property>
</structure>
<structure>
<property name="columnName">SERVICE_GROUP_DESCRIPTION</property>
<text-property name="displayName">SERVICE_GROUP_DESCRIPTION</text-property>
<text-property name="heading">SERVICE_GROUP_DESCRIPTION</text-property>
</structure>
<structure>
<property name="columnName">SOURCE_CD</property>
<text-property name="displayName">SOURCE_CD</text-property>
<text-property name="heading">SOURCE_CD</text-property>
</structure>
<structure>
<property name="columnName">SERVICE_DESCRIPTION</property>
<text-property name="displayName">SERVICE_DESCRIPTION</text-property>
<text-property name="heading">SERVICE_DESCRIPTION</text-property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">TKT_ID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CONTACT_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CONTACT_NUMBER</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">SERVICE_GROUP_DESCRIPTION</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">SOURCE_CD</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">SERVICE_DESCRIPTION</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">GMS_performance</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">TKT_ID</property>
<property name="nativeName">TKT_ID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CONTACT_NAME</property>
<property name="nativeName">CONTACT_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CONTACT_NUMBER</property>
<property name="nativeName">CONTACT_NUMBER</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">SERVICE_GROUP_DESCRIPTION</property>
<property name="nativeName">SERVICE_GROUP_DESCRIPTION</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">SOURCE_CD</property>
<property name="nativeName">SOURCE_CD</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">SERVICE_DESCRIPTION</property>
<property name="nativeName">SERVICE_DESCRIPTION</property>
<property name="dataType">string</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select VTM024TROUBLE_TKT.TKT_ID,VTM078TKT_CONTACT_INFO.CONTACT_NAME, VTM078TKT_CONTACT_INFO.CONTACT_NUMBER, VTM021SERVICE_GRP.SERVICE_GROUP_DESCRIPTION,VTM024TROUBLE_TKT.SOURCE_CD, VTM022SERVICE.SERVICE_DESCRIPTION from VTM024TROUBLE_TKT,VTM078TKT_CONTACT_INFO,VTM021SERVICE_GRP, VTM022SERVICE WHERE VTM078TKT_CONTACT_INFO.UNQ_TASK_ID=VTM024TROUBLE_TKT.UNQ_TASK_ID AND VTM024TROUBLE_TKT.SERVICE_ID=VTM022SERVICE.SERVICE_ID AND VTM024TROUBLE_TKT.SERVICE_GROUP_ID=VTM021SERVICE_GRP.SERVICE_GROUP_ID AND VTM024TROUBLE_TKT.SOURCE_CD IS NOT NULL ORDER BY TKT_ID]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>TKT_ID</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>11</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>TKT_ID</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>TKT_ID</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CONTACT_NAME</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>25</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>CONTACT_NAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>CONTACT_NAME</design:label>
<design:formattingHints>
<design:displaySize>25</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CONTACT_NUMBER</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>CONTACT_NUMBER</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>CONTACT_NUMBER</design:label>
<design:formattingHints>
<design:displaySize>10</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>SERVICE_GROUP_DESCRIPTION</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>100</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>SERVICE_GROUP_DESCRIPTION</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>SERVICE_GROUP_DESCRIPTION</design:label>
<design:formattingHints>
<design:displaySize>100</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>SERVICE_DESCRIPTION</design:name>
<design:position>5</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>100</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>SERVICE_DESCRIPTION</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>SERVICE_DESCRIPTION</design:label>
<design:formattingHints>
<design:displaySize>100</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="pie_gms" id="46">
<list-property name="columnHints">
<structure>
<property name="columnName">COUNT(*)</property>
<text-property name="displayName">COUNT(*)</text-property>
<text-property name="heading">COUNT(*)</text-property>
</structure>
<structure>
<property name="columnName">SOURCE_CD</property>
<text-property name="displayName">SOURCE_CD</text-property>
<text-property name="heading">SOURCE_CD</text-property>
</structure>
</list-property>
<list-property name="parameters">
<structure>
<property name="name">start_create_time</property>
<property name="paramName">start_create_time</property>
<property name="dataType">string</property>
<property name="position">1</property>
<expression name="defaultValue" type="javascript">01-FEB-11</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">stop_create_time</property>
<property name="paramName">stop_create_time</property>
<property name="dataType">string</property>
<property name="position">2</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData"/>
<property name="dataSource">Tracs Demo</property>
<xml-property name="queryText"><![CDATA[select count(*), SOURCE_CD from VTM024TROUBLE_TKT WHERE CREATE_TIME BETWEEN '10-JAN-11' AND '15-JAN-11' AND SOURCE_CD IS NOT NULL GROUP BY SOURCE_CD]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>COUNT(*)</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>2</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>COUNT(*)</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>COUNT(*)</design:label>
<design:formattingHints>
<design:displaySize>22</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>SOURCE_CD</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>20</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>SOURCE_CD</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>SOURCE_CD</design:label>
<design:formattingHints>
<design:displaySize>20</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Alarms_GMS_Pickup" id="57">
<list-property name="columnHints">
<structure>
<property name="columnName">COUNT(*)</property>
<text-property name="displayName">COUNT(*)</text-property>
<text-property name="heading">COUNT(*)</text-property>
</structure>
<structure>
<property name="columnName">SOURCE_CD</property>
<text-property name="displayName">SOURCE_CD</text-property>
<text-property name="heading">SOURCE_CD</text-property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">COUNT(*)</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">SOURCE_CD</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Tracs Demo</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">COUNT(*)</property>
<property name="nativeName">COUNT(*)</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">SOURCE_CD</property>
<property name="nativeName">SOURCE_CD</property>
<property name="dataType">string</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select count(*), VTM024TROUBLE_TKT.SOURCE_CD from VTM030TROUBLE_TKT_ALARM, VTM024TROUBLE_TKT WHERE VTM030TROUBLE_TKT_ALARM.UNQ_TASK_ID=VTM024TROUBLE_TKT.UNQ_TASK_ID AND VTM030TROUBLE_TKT_ALARM.TIMER_TYPE='P' AND VTM024TROUBLE_TKT.PICKED_UP_BY_USER IS NULL AND VTM024TROUBLE_TKT.CREATE_TIME BETWEEN '10-JAN-11' AND '15-JAN-11' GROUP BY VTM024TROUBLE_TKT.SOURCE_CD]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Alarms_GMS_Escalate" id="59">
<list-property name="columnHints">
<structure>
<property name="columnName">COUNT(*)</property>
<text-property name="displayName">COUNT(*)</text-property>
<text-property name="heading">COUNT(*)</text-property>
</structure>
<structure>
<property name="columnName">SOURCE_CD</property>
<text-property name="displayName">SOURCE_CD</text-property>
<text-property name="heading">SOURCE_CD</text-property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">COUNT(*)</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">SOURCE_CD</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Tracs Demo</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">COUNT(*)</property>
<property name="nativeName">COUNT(*)</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">SOURCE_CD</property>
<property name="nativeName">SOURCE_CD</property>
<property name="dataType">string</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select count(*), VTM024TROUBLE_TKT.SOURCE_CD from VTM030TROUBLE_TKT_ALARM, VTM024TROUBLE_TKT WHERE VTM030TROUBLE_TKT_ALARM.UNQ_TASK_ID=VTM024TROUBLE_TKT.UNQ_TASK_ID AND VTM030TROUBLE_TKT_ALARM.TIMER_TYPE='E' AND VTM024TROUBLE_TKT.CREATE_TIME BETWEEN '10-JAN-11' AND '15-JAN-11' AND VTM030TROUBLE_TKT_ALARM.DATE_ALARMS_TURNED_OFF IS NULL GROUP BY VTM024TROUBLE_TKT.SOURCE_CD]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Alarms_GMS_Update" id="60">
<list-property name="columnHints">
<structure>
<property name="columnName">COUNT(*)</property>
<text-property name="displayName">COUNT(*)</text-property>
<text-property name="heading">COUNT(*)</text-property>
</structure>
<structure>
<property name="columnName">SOURCE_CD</property>
<text-property name="displayName">SOURCE_CD</text-property>
<text-property name="heading">SOURCE_CD</text-property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">COUNT(*)</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">SOURCE_CD</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Tracs Demo</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">COUNT(*)</property>
<property name="nativeName">COUNT(*)</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">SOURCE_CD</property>
<property name="nativeName">SOURCE_CD</property>
<property name="dataType">string</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select count(*), VTM024TROUBLE_TKT.SOURCE_CD from VTM030TROUBLE_TKT_ALARM, VTM024TROUBLE_TKT WHERE VTM030TROUBLE_TKT_ALARM.UNQ_TASK_ID=VTM024TROUBLE_TKT.UNQ_TASK_ID AND VTM030TROUBLE_TKT_ALARM.TIMER_TYPE='U' AND VTM030TROUBLE_TKT_ALARM.DATE_ALARMS_TURNED_OFF IS NULL AND VTM024TROUBLE_TKT.CREATE_TIME BETWEEN '10-JAN-11' AND '15-JAN-11' GROUP BY VTM024TROUBLE_TKT.SOURCE_CD]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="pie_gms2" id="64">
<list-property name="columnHints">
<structure>
<property name="columnName">COUNT(*)</property>
<text-property name="displayName">COUNT(*)</text-property>
<text-property name="heading">COUNT(*)</text-property>
</structure>
<structure>
<property name="columnName">SOURCE_CD</property>
<text-property name="displayName">SOURCE_CD</text-property>
<text-property name="heading">SOURCE_CD</text-property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">COUNT(*)</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">SOURCE_CD</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">GMS_performance</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">COUNT(*)</property>
<property name="nativeName">COUNT(*)</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">SOURCE_CD</property>
<property name="nativeName">SOURCE_CD</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select count(*), SOURCE_CD from VTM024TROUBLE_TKT WHERE CREATE_TIME BETWEEN '10-JAN-11' AND '15-JAN-11' AND SOURCE_CD IS NOT NULL GROUP BY SOURCE_CD]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>COUNT(*)</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>2</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>COUNT(*)</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>COUNT(*)</design:label>
<design:formattingHints>
<design:displaySize>22</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>SOURCE_CD</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>20</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>SOURCE_CD</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>SOURCE_CD</design:label>
<design:formattingHints>
<design:displaySize>20</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Data Set" id="100">
<structure name="cachedMetaData"/>
<property name="dataSource">Data Source</property>
<xml-property name="queryText"><![CDATA[select
from CLASSICMODELS.CUSTOMERS]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="report" id="4">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">10pt</property>
</style>
<style name="crosstab" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab-cell" id="6">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="NewStyle" id="101"/>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<property name="orientation">landscape</property>
<property name="leftMargin">0.25in</property>
<page-footer>
<text id="3">
<property name="contentType">html</property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<table id="102">
<property name="dataSet">gms_data_set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">TKT_ID</property>
<text-property name="displayName">TKT_ID</text-property>
<expression name="expression" type="javascript">dataSetRow["TKT_ID"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CONTACT_NAME</property>
<text-property name="displayName">CONTACT_NAME</text-property>
<expression name="expression" type="javascript">dataSetRow["CONTACT_NAME"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CONTACT_NUMBER</property>
<text-property name="displayName">CONTACT_NUMBER</text-property>
<expression name="expression" type="javascript">dataSetRow["CONTACT_NUMBER"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">SERVICE_GROUP_DESCRIPTION</property>
<text-property name="displayName">SERVICE_GROUP_DESCRIPTION</text-property>
<expression name="expression" type="javascript">dataSetRow["SERVICE_GROUP_DESCRIPTION"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">SERVICE_DESCRIPTION</property>
<text-property name="displayName">SERVICE_DESCRIPTION</text-property>
<expression name="expression" type="javascript">dataSetRow["SERVICE_DESCRIPTION"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<column id="131"/>
<column id="132"/>
<column id="133"/>
<column id="134"/>
<column id="135"/>
<header>
<row id="103">
<cell id="104">
<label id="105">
<text-property name="text">TKT_ID</text-property>
</label>
</cell>
<cell id="106">
<label id="107">
<text-property name="text">CONTACT_NAME</text-property>
</label>
</cell>
<cell id="108">
<label id="109">
<text-property name="text">CONTACT_NUMBER</text-property>
</label>
</cell>
<cell id="110">
<label id="111">
<text-property name="text">SERVICE_GROUP_DESCRIPTION</text-property>
</label>
</cell>
<cell id="112">
<label id="113">
<text-property name="text">SERVICE_DESCRIPTION</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="114">
<cell id="115">
<data id="116">
<property name="whiteSpace">nowrap</property>
<property name="resultSetColumn">TKT_ID</property>
</data>
</cell>
<cell id="117">
<data id="118">
<property name="whiteSpace">nowrap</property>
<property name="resultSetColumn">CONTACT_NAME</property>
</data>
</cell>
<cell id="119">
<data id="120">
<property name="whiteSpace">nowrap</property>
<property name="resultSetColumn">CONTACT_NUMBER</property>
</data>
</cell>
<cell id="121">
<data id="122">
<property name="whiteSpace">nowrap</property>
<property name="resultSetColumn">SERVICE_GROUP_DESCRIPTION</property>
</data>
</cell>
<cell id="123">
<data id="124">
<property name="whiteSpace">nowrap</property>
<property name="resultSetColumn">SERVICE_DESCRIPTION</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="125">
<cell id="126"/>
<cell id="127"/>
<cell id="128"/>
<cell id="129"/>
<cell id="130"/>
</row>
</footer>
</table>
<extended-item extensionName="Chart" id="139">
<xml-property name="xmlRepresentation"><![CDATA[<model:ChartWithAxes xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:attribute="http://www.birt.eclipse.org/ChartModelAttribute" xmlns:data="http://www.birt.eclipse.org/ChartModelData" xmlns:layout="http://www.birt.eclipse.org/ChartModelLayout" xmlns:model="http://www.birt.eclipse.org/ChartModel" xmlns:type="http://www.birt.eclipse.org/ChartModelType">
<Version>2.5.1</Version>
<Type>Bar Chart</Type>
<SubType>Side-by-side</SubType>
<Block>
<Children xsi:type="layout:TitleBlock">
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>0.0</Width>
<Height>0.0</Height>
</Bounds>
<Insets>
<Top>3.0</Top>
<Left>3.0</Left>
<Bottom>3.0</Bottom>

JasonW

What jars do you have in the classpath? Do you have all the jars from the runtime/reportengine/lib directory in the classpath? BTW the report is built using 2.6.2 which probably will not run in a 2.6.1 runtime.

Jason

asilo1

i did put all the jars from runtime 2.6.2 and change the report engine to 2.6.2 and i am still getting the same error. i am not sure if you heard anything about a jar called org.apache.xerces_2.9.0.v201005080400.jar.
in google some forums they want you to added to class path but no go as well.

JasonW

I am not certain what is happening here but if I could reproduce the problem I could probably find out. Is there a simple jide app that I could build and add birt to to reproduce the issue?

Jason

asilo1

well when i run this alone in small java application. i have no problems. Problem starts when i integrated to existed software we have. i cant seem to find any solutions at all. Its weird that everything works but graphs.

private void initComponents() {
this.setLayout(new BorderLayout());
Border raisedbevel = BorderFactory.createRaisedBevelBorder();
Border loweredbevel = BorderFactory.createLoweredBevelBorder();
Border compound = BorderFactory.createCompoundBorder(
raisedbevel, loweredbevel);
this.setBorder(compound);
// Developers Note: The layout below is the only way to get the panels to take the correct
// positions. the first 3 must be placed in one panel (topPanel) and placed North on the TicketPanel
JPanel topPanel = new JPanel(new BorderLayout());
topPanel.add(createBannerPanel(), BorderLayout.NORTH);
topPanel.add(addCommandBar(), BorderLayout.CENTER);
criteriaPanel = new AlarmSummaryCriteriaPanel();
criteriaPanel.setCriteria(criteria);
criteriaPanel.updateComponents();
topPanel.add(criteriaPanel, BorderLayout.SOUTH);

HtmlReport2 html = new HtmlReport2(); ---> thid calls the birt info

this.add(topPanel, BorderLayout.NORTH);
this.add(html, BorderLayout.CENTER);
}

public class HtmlReport2 extends JPanel

{
JEditorPane myEditorPane = new JEditorPane() ;
IReportRunnable design = null;
HtmlReport2()
{
initComponents();

}
/**
* Initialize the components.
*/
protected void initComponents() {
// setLayout(new FormLayout("fill:p:grow", "fill:p:grow"));
setBackground(new Color(216, 228, 248));
startPlatform();
runReport();
stopPlatform();
}

public void runReport()

{
try {

CellConstraints cc = new CellConstraints();
// setBorder(Borders.DLU4_BORDER);
// Open the report design
design = engine.openReportDesign("C:\\Documents and Settings\\AsilO1\\workspace2\\Tracs8.0\\ReportAlarmSummary.rptdesign");
// Create task to run and render the report,
IRunAndRenderTask task = engine.createRunAndRenderTask(design);
HTMLRenderOption options = new HTMLRenderOption();
ByteArrayOutputStream bos = new ByteArrayOutputStream();
options.setOutputStream(bos);
options.setSupportedImageFormats( "PNG;GIF;JPG;BMP;SWF");
options.setOutputFormat("html");
options.setEmbeddable(true);
options.setImageDirectory("output/image");
// options.setEnableInlineStyle(true);
task.setRenderOption(options);
task.setParameterValue("reportRunId", reportRunId);
task.run();
task.close();
myEditorPane.setContentType("text/html");
myEditorPane.setText(bos.toString());
myEditorPane.setBackground(new Color(216, 228, 248));
// JScrollPane scrollPane = new JScrollPane(myEditorPane);

add(myEditorPane, cc.xy(1, 1));
} catch (Exception ex) {
ex.printStackTrace();
}

}

public void startPlatform() {
try {
config = new EngineConfig();
config.setBIRTHome("C:\\birt-runtime-3_7_1\\ReportEngine");
Platform.startup(config);
IReportEngineFactory factory = (IReportEngineFactory) Platform
.createFactoryObject(IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY);
engine = factory.createReportEngine(config);
} catch (Exception e) {
e.printStackTrace();
}
}

public void stopPlatform() {
engine.destroy();
Platform.shutdown();

}}

JasonW

I do not think this matters in this case but remove this line:
config.setBIRTHome("C:\\birt-runtime-3_7_1\\ReportEngine");

It is not needed for version 3.7.1. For 3.7 and greater just add the jars in the reportengine/lib directory to your classpath.

Jason

asilo1

well i think it might be happening bc i am putting the birt under jide/swing. i try to push as Jframe it still gave me the same error.

it breaks down at

design = engine.openReportDesign("C:\\Documents and Settings\\AsilO1\\workspace2\\Tracs8.0\\ReportAlarmSummary.rptdesign");

JasonW

Here is an example that was done in swing.

http://www.eclipse.org/forums/index.php/m/365749/#msg_365749

Jason