nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Error when producing PDF report

donwood

Using the Report Engine API, I am producing a report from a rptdesign file which works great when I render it as HTML. However, if I try to render it to PDF I receive the error copied at the end of this post. 
 
The set up of our application is as follows: 
EAR 
WAR - containing JSP pages to which BIRT reports are rendered and BIRT rptdesign files. This also contains the report engine's lib directory (for some reports that are rendered via the BIRT viewer) and the platform/plugins directory for reports rendered via the API. 
Utility project - contains action classes and business classes 
 
FYI - I am using BIRT 2.3.2. 
 
I apologize that this is a post similar to one I posted last week on the Eclipse forums. Does anyone know what has happened to them? When I click on the <a class='bbc_url' href='http://www.eclipse.org/forums/'>http://www.eclipse.org/forums/</a> link, there is nothing there. Have they been moved? deleted? 
 
 
ERROR 
java.lang.NoClassDefFoundError: org.eclipse.birt.report.engine.api.script.instance.IScriptStyle 
at java.lang.ClassLoader.defineClassImpl(Native Method) 
at java.lang.ClassLoader.defineClass(ClassLoader.java:274) 
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:69) 
at com.ibm.ws.classloader.CompoundClassLoader._defineClass(CompoundClassLoader.java:768) 
at com.ibm.ws.classloader.CompoundClassLoader.localFindClass(CompoundClassLoader.java:687) 
at com.ibm.ws.classloader.CompoundClassLoader.loadClass(CompoundClassLoader.java:510) 
at java.lang.ClassLoader.loadClass(ClassLoader.java:618) 
at org.eclipse.birt.core.framework.osgi.OSGILauncher$ChildFirstURLClassLoader.loadClass(OSGILauncher.java:680) 
at java.lang.ClassLoader.loadClass(ClassLoader.java:618) 
at org.eclipse.osgi.framework.internal.core.SystemBundleLoader.findLocalClass(SystemBundleLoader.java:114) 
at org.eclipse.osgi.framework.internal.core.SingleSourcePackage.loadClass(SingleSourcePackage.java:33) 
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClassInternal(BundleLoader.java:443) 
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:399) 
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:387) 
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:87) 
at java.lang.ClassLoader.loadClass(ClassLoader.java:618) 
at org.eclipse.birt.report.engine.toc.TOCStyleUtil.getTOCStyle(TOCStyleUtil.java:45) 
at org.eclipse.birt.report.engine.toc.TOCView.getTOCStyle(TOCView.java:269) 
at org.eclipse.birt.report.engine.toc.ViewNode.<init>(ViewNode.java:44) 
at org.eclipse.birt.report.engine.toc.ViewNode.createGroupNode(ViewNode.java:136) 
at org.eclipse.birt.report.engine.toc.ViewNode.addViewNode(ViewNode.java:113) 
at org.eclipse.birt.report.engine.toc.ViewNode.createViewChildren(ViewNode.java:83) 
at org.eclipse.birt.report.engine.toc.ViewNode.getChildren(ViewNode.java:67) 
at org.eclipse.birt.report.engine.emitter.pdf.PDFPageDevice.createTOC(PDFPageDevice.java:172) 
at org.eclipse.birt.report.engine.emitter.pdf.PDFRender.createTOC(PDFRender.java:248) 
at org.eclipse.birt.report.engine.emitter.pdf.PDFRender.end(PDFRender.java:120) 
at org.eclipse.birt.report.engine.layout.emitter.PageEmitter.end(PageEmitter.java:61) 
at org.eclipse.birt.report.engine.layout.pdf.emitter.PDFLayoutEmitter.end(PDFLayoutEmitter.java:100) 
at org.eclipse.birt.report.engine.layout.pdf.emitter.WrappedPDFLayoutEmitter.end(WrappedPDFLayoutEmitter.java:69) 
at org.eclipse.birt.report.engine.layout.pdf.emitter.PDFLayoutEmitterProxy.end(PDFLayoutEmitterProxy.java:218) 
at org.eclipse.birt.report.engine.emitter.CompositeContentEmitter.end(CompositeContentEmitter.java:64) 
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:153) 
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:72) 
at us.pa.state.dot.mpms.birt.TestReport.previewReport(TestReport.java:80) 
at us.pa.state.dot.mpms.action.BirtAction.previewBirtTestRpt(BirtAction.java:134) 
at us.pa.state.dot.mpms.action.BirtAction.performAction(BirtAction.java:49) 
at us.pa.state.dot.mpms.servlet.AjaxServlet.performPDTask(AjaxServlet.java:134)

Find more posts tagged with

Comments

JasonW

If you have everything from the webviewer in the war you should be able to use the engine api or the web viewer.

Jason

donwood

Jason, 
 
Apparently, I've been fooled into thinking that the setup of the EAR/WAR/etc is what is causing my issues. Here's why I say this. 
 
I created a BIRT report containing a simple SQL statement, one table, and three fields from the resultset. Using this report, I successfully rendered both an HTML and a PDF version of the report. However, I then added a group to the table and attempted to re-run the report. It ran successfully when rendered as HTML but failed when rendered as PDF. Below, I've included the report and the error that occurred when attempting to render the report as PDF. 
 
Do you have any idea why this would happen? I guess it's possible that there's still something about the setup of the EAR/WAR/etc but you would know better than me. 
 
Thanks for your time with this. 
 
-Don 
 
REPORT 
<?xml version="1.0" encoding="UTF-8"?> 
<report xmlns="<a class='bbc_url' href='http://www.eclipse.org/birt/2005/design'>http://www.eclipse.org/birt/2005/design"</a> version="3.2.17" id="1"> 
<property name="createdBy">Eclipse BIRT Designer Version 2.3.2.r232_20090202 Build <2.3.2.v20090218-0730></property> 
<property name="units">in</property> 
<property name="iconFile">/templates/blank_report.gif</property> 
<property name="bidiLayoutOrientation">ltr</property> 
<data-sources> 
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="7"> 
<property name="odaDriverClass">com.ibm.db2.jcc.DB2Driver</property> 
<property name="odaURL">jdbc:db2://pddevgwdsnd2k01:50000/DSN</property> 
<property name="odaUser">mpmspgm</property> 
<encrypted-property name="odaPassword" encryptionID="base64">bXBtczAx</encrypted-property> 
<property name="odaJndiName">jdbc/MPMS</property> 
</oda-data-source> 
</data-sources> 
<data-sets> 
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Data Set" id="8"> 
<list-property name="columnHints"> 
<structure> 
<property name="columnName">PRG_ID</property> 
<property name="displayName">PRG_ID</property> 
</structure> 
<structure> 
<property name="columnName">PLAN_PRTNR_ID</property> 
<property name="displayName">PLAN_PRTNR_ID</property> 
</structure> 
<structure> 
<property name="columnName">PRNT_PRG_ID</property> 
<property name="displayName">PRNT_PRG_ID</property> 
</structure> 
<structure> 
<property name="columnName">PRG_TYPE_CD</property> 
<property name="displayName">PRG_TYPE_CD</property> 
</structure> 
<structure> 
<property name="columnName">PRG_TITL_TX</property> 
<property name="displayName">PRG_TITL_TX</property> 
</structure> 
<structure> 
<property name="columnName">PRG_STS_CD</property> 
<property name="displayName">PRG_STS_CD</property> 
</structure> 
<structure> 
<property name="columnName">PRG_STRT_YR</property> 
<property name="displayName">PRG_STRT_YR</property> 
</structure> 
<structure> 
<property name="columnName">PRG_END_YR</property> 
<property name="displayName">PRG_END_YR</property> 
</structure> 
<structure> 
<property name="columnName">PRG_SCNR_NM</property> 
<property name="displayName">PRG_SCNR_NM</property> 
</structure> 
<structure> 
<property name="columnName">PRG_DC</property> 
<property name="displayName">PRG_DC</property> 
</structure> 
<structure> 
<property name="columnName">LAST_USER_ID</property> 
<property name="displayName">LAST_USER_ID</property> 
</structure> 
<structure> 
<property name="columnName">LAST_PRG_ID</property> 
<property name="displayName">LAST_PRG_ID</property> 
</structure> 
<structure> 
<property name="columnName">LAST_MDFY_TS</property> 
<property name="displayName">LAST_MDFY_TS</property> 
</structure> 
<structure> 
<property name="columnName">OBLGT_CTF_DT</property> 
<property name="displayName">OBLGT_CTF_DT</property> 
</structure> 
<structure> 
<property name="columnName">PRG_CMBN_FL</property> 
<property name="displayName">PRG_CMBN_FL</property> 
</structure> 
<structure> 
<property name="columnName">NO_OF_PERIODS</property> 
<property name="displayName">NO_OF_PERIODS</property> 
</structure> 
</list-property> 
<structure name="cachedMetaData"> 
<list-property name="resultSet"> 
<structure> 
<property name="position">1</property> 
<property name="name">PRG_ID</property> 
<property name="dataType">integer</property> 
</structure> 
<structure> 
<property name="position">2</property> 
<property name="name">PLAN_PRTNR_ID</property> 
<property name="dataType">integer</property> 
</structure> 
<structure> 
<property name="position">3</property> 
<property name="name">PRNT_PRG_ID</property> 
<property name="dataType">integer</property> 
</structure> 
<structure> 
<property name="position">4</property> 
<property name="name">PRG_TYPE_CD</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">5</property> 
<property name="name">PRG_TITL_TX</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">6</property> 
<property name="name">PRG_STS_CD</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">7</property> 
<property name="name">PRG_STRT_YR</property> 
<property name="dataType">integer</property> 
</structure> 
<structure> 
<property name="position">8</property> 
<property name="name">PRG_END_YR</property> 
<property name="dataType">integer</property> 
</structure> 
<structure> 
<property name="position">9</property> 
<property name="name">PRG_SCNR_NM</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">10</property> 
<property name="name">PRG_DC</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">11</property> 
<property name="name">LAST_USER_ID</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">12</property> 
<property name="name">LAST_PRG_ID</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">13</property> 
<property name="name">LAST_MDFY_TS</property> 
<property name="dataType">date-time</property> 
</structure> 
<structure> 
<property name="position">14</property> 
<property name="name">OBLGT_CTF_DT</property> 
<property name="dataType">date</property> 
</structure> 
<structure> 
<property name="position">15</property> 
<property name="name">PRG_CMBN_FL</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">16</property> 
<property name="name">NO_OF_PERIODS</property> 
<property name="dataType">integer</property> 
</structure> 
</list-property> 
</structure> 
<property name="dataSource">Data Source</property> 
<list-property name="resultSet"> 
<structure> 
<property name="position">1</property> 
<property name="name">PRG_ID</property> 
<property name="nativeName">PRG_ID</property> 
<property name="dataType">integer</property> 
<property name="nativeDataType">4</property> 
</structure> 
<structure> 
<property name="position">2</property> 
<property name="name">PLAN_PRTNR_ID</property> 
<property name="nativeName">PLAN_PRTNR_ID</property> 
<property name="dataType">integer</property> 
<property name="nativeDataType">5</property> 
</structure> 
<structure> 
<property name="position">3</property> 
<property name="name">PRNT_PRG_ID</property> 
<property name="nativeName">PRNT_PRG_ID</property> 
<property name="dataType">integer</property> 
<property name="nativeDataType">4</property> 
</structure> 
<structure> 
<property name="position">4</property> 
<property name="name">PRG_TYPE_CD</property> 
<property name="nativeName">PRG_TYPE_CD</property> 
<property name="dataType">string</property> 
<property name="nativeDataType">12</property> 
</structure> 
<structure> 
<property name="position">5</property> 
<property name="name">PRG_TITL_TX</property> 
<property name="nativeName">PRG_TITL_TX</property> 
<property name="dataType">string</property> 
<property name="nativeDataType">12</property> 
</structure> 
<structure> 
<property name="position">6</property> 
<property name="name">PRG_STS_CD</property> 
<property name="nativeName">PRG_STS_CD</property> 
<property name="dataType">string</property> 
<property name="nativeDataType">12</property> 
</structure> 
<structure> 
<property name="position">7</property> 
<property name="name">PRG_STRT_YR</property> 
<property name="nativeName">PRG_STRT_YR</property> 
<property name="dataType">integer</property> 
<property name="nativeDataType">5</property> 
</structure> 
<structure> 
<property name="position">8</property> 
<property name="name">PRG_END_YR</property> 
<property name="nativeName">PRG_END_YR</property> 
<property name="dataType">integer</property> 
<property name="nativeDataType">5</property> 
</structure> 
<structure> 
<property name="position">9</property> 
<property name="name">PRG_SCNR_NM</property> 
<property name="nativeName">PRG_SCNR_NM</property> 
<property name="dataType">string</property> 
<property name="nativeDataType">12</property> 
</structure> 
<structure> 
<property name="position">10</property> 
<property name="name">PRG_DC</property> 
<property name="nativeName">PRG_DC</property> 
<property name="dataType">string</property> 
<property name="nativeDataType">12</property> 
</structure> 
<structure> 
<property name="position">11</property> 
<property name="name">LAST_USER_ID</property> 
<property name="nativeName">LAST_USER_ID</property> 
<property name="dataType">string</property> 
<property name="nativeDataType">12</property> 
</structure> 
<structure> 
<property name="position">12</property> 
<property name="name">LAST_PRG_ID</property> 
<property name="nativeName">LAST_PRG_ID</property> 
<property name="dataType">string</property> 
<property name="nativeDataType">12</property> 
</structure> 
<structure> 
<property name="position">13</property> 
<property name="name">LAST_MDFY_TS</property> 
<property name="nativeName">LAST_MDFY_TS</property> 
<property name="dataType">date-time</property> 
<property name="nativeDataType">93</property> 
</structure> 
<structure> 
<property name="position">14</property> 
<property name="name">OBLGT_CTF_DT</property> 
<property name="nativeName">OBLGT_CTF_DT</property> 
<property name="dataType">date</property> 
<property name="nativeDataType">91</property> 
</structure> 
<structure> 
<property name="position">15</property> 
<property name="name">PRG_CMBN_FL</property> 
<property name="nativeName">PRG_CMBN_FL</property> 
<property name="dataType">string</property> 
<property name="nativeDataType">12</property> 
</structure> 
<structure> 
<property name="position">16</property> 
<property name="name">NO_OF_PERIODS</property> 
<property name="nativeName">NO_OF_PERIODS</property> 
<property name="dataType">integer</property> 
<property name="nativeDataType">5</property> 
</structure> 
</list-property> 
<property name="queryText">select * 
from mpmsprod.t001program 
order by prg_type_cd</property> 
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?> 
<model:DesignValues xmlns:design="<a class='bbc_url' href='http://www.eclipse.org/datatools/connectivity/oda/design'>http://www.eclipse.org/datatools/connectivity/oda/design"</a> xmlns:model="<a class='bbc_url' href='http://www.eclipse.org/birt/report/model/adapter/odaModel">'>http://www.eclipse.org/birt/report/model/adapter/odaModel"></a> 
<Version>1.0</Version> 
<design:ResultSets derivedMetaData="true"> 
<design:resultSetDefinitions> 
<design:resultSetColumns> 
<design:resultColumnDefinitions> 
<design:attributes> 
<design:name>PRG_ID</design:name> 
<design:position>1</design:position> 
<design:nativeDataTypeCode>4</design:nativeDataTypeCode> 
<design:precision>10</design:precision> 
<design:scale>0</design:scale> 
<design:nullability>NotNullable</design:nullability> 
<design:uiHints> 
<design:displayName>PRG_ID</design:displayName> 
</design:uiHints> 
</design:attributes> 
<design:usageHints> 
<design:label>PRG_ID</design:label> 
<design:formattingHints> 
<design:displaySize>11</design:displaySize> 
</design:formattingHints> 
</design:usageHints> 
</design:resultColumnDefinitions> 
<design:resultColumnDefinitions> 
<design:attributes> 
<design:name>PLAN_PRTNR_ID</design:name> 
<design:position>2</design:position> 
<design:nativeDataTypeCode>5</design:nativeDataTypeCode> 
<design:precision>5</design:precision> 
<design:scale>0</design:scale> 
<design:nullability>Nullable</design:nullability> 
<design:uiHints> 
<design:displayName>PLAN_PRTNR_ID</design:displayName> 
</design:uiHints> 
</design:attributes> 
<design:usageHints> 
<design:label>PLAN_PRTNR_ID</design:label> 
<design:formattingHints> 
<design:displaySize>6</design:displaySize> 
</design:formattingHints> 
</design:usageHints> 
</design:resultColumnDefinitions> 
<design:resultColumnDefinitions> 
<design:attributes> 
<design:name>PRNT_PRG_ID</design:name> 
<design:position>3</design:position> 
<design:nativeDataTypeCode>4</design:nativeDataTypeCode> 
<design:precision>10</design:precision> 
<design:scale>0</design:scale> 
<design:nullability>Nullable</design:nullability> 
<design:uiHints> 
<design:displayName>PRNT_PRG_ID</design:displayName> 
</design:uiHints> 
</design:attributes> 
<design:usageHints> 
<design:label>PRNT_PRG_ID</design:label> 
<design:formattingHints> 
<design:displaySize>11</design:displaySize> 
</design:formattingHints> 
</design:usageHints> 
</design:resultColumnDefinitions> 
<design:resultColumnDefinitions> 
<design:attributes> 
<design:name>PRG_TYPE_CD</design:name> 
<design:position>4</design:position> 
<design:nativeDataTypeCode>12</design:nativeDataTypeCode> 
<design:precision>5</design:precision> 
<design:scale>0</design:scale> 
<design:nullability>NotNullable</design:nullability> 
<design:uiHints> 
<design:displayName>PRG_TYPE_CD</design:displayName> 
</design:uiHints> 
</design:attributes> 
<design:usageHints> 
<design:label>PRG_TYPE_CD</design:label> 
<design:formattingHints> 
<design:displaySize>5</design:displaySize> 
</design:formattingHints> 
</design:usageHints> 
</design:resultColumnDefinitions> 
<design:resultColumnDefinitions> 
<design:attributes> 
<design:name>PRG_TITL_TX</design:name> 
<design:position>5</design:position> 
<design:nativeDataTypeCode>12</design:nativeDataTypeCode> 
<design:precision>50</design:precision> 
<design:scale>0</design:scale> 
<design:nullability>NotNullable</design:nullability> 
<design:uiHints> 
<design:displayName>PRG_TITL_TX</design:displayName> 
</design:uiHints> 
</design:attributes> 
<design:usageHints> 
<design:label>PRG_TITL_TX</design:label> 
<design:formattingHints> 
<design:displaySize>50</design:displaySize> 
</design:formattingHints> 
</design:usageHints> 
</design:resultColumnDefinitions> 
<design:resultColumnDefinitions> 
<design:attributes> 
<design:name>PRG_STS_CD</design:name> 
<design:position>6</design:position> 
<design:nativeDataTypeCode>12</design:nativeDataTypeCode> 
<design:precision>5</design:precision> 
<design:scale>0</design:scale> 
<design:nullability>NotNullable</design:nullability> 
<design:uiHints> 
<design:displayName>PRG_STS_CD</design:displayName> 
</design:uiHints> 
</design:attributes> 
<design:usageHints> 
<design:label>PRG_STS_CD</design:label> 
<design:formattingHints> 
<design:displaySize>5</design:displaySize> 
</design:formattingHints> 
</design:usageHints> 
</design:resultColumnDefinitions> 
<design:resultColumnDefinitions> 
<design:attributes> 
<design:name>PRG_STRT_YR</design:name> 
<design:position>7</design:position> 
<design:nativeDataTypeCode>5</design:nativeDataTypeCode> 
<design:precision>5</design:precision> 
<design:scale>0</design:scale> 
<design:nullability>NotNullable</design:nullability> 
<design:uiHints> 
<design:displayName>PRG_STRT_YR</design:displayName> 
</design:uiHints> 
</design:attributes> 
<design:usageHints> 
<design:label>PRG_STRT_YR</design:label> 
<design:formattingHints> 
<design:displaySize>6</design:displaySize> 
</design:formattingHints> 
</design:usageHints> 
</design:resultColumnDefinitions> 
<design:resultColumnDefinitions> 
<design:attributes> 
<design:name>PRG_END_YR</design:name> 
<design:position>8</design:position> 
<design:nativeDataTypeCode>5</design:nativeDataTypeCode> 
<design:precision>5</design:precision> 
<design:scale>0</design:scale> 
<design:nullability>NotNullable</design:nullability> 
<design:uiHints> 
<design:displayName>PRG_END_YR</design:displayName> 
</design:uiHints> 
</design:attributes> 
<design:usageHints> 
<design:label>PRG_END_YR</design:label> 
<design:formattingHints> 
<design:displaySize>6</design:displaySize> 
</design:formattingHints> 
</design:usageHints> 
</design:resultColumnDefinitions> 
<design:resultColumnDefinitions> 
<design:attributes> 
<design:name>PRG_SCNR_NM</design:name> 
<design:position>9</design:position> 
<design:nativeDataTypeCode>12</design:nativeDataTypeCode> 
<design:precision>50</design:precision> 
<design:scale>0</design:scale> 
<design:nullability>Nullable</design:nullability> 
<design:uiHints> 
<design:displayName>PRG_SCNR_NM</design:displayName> 
</design:uiHints> 
</design:attributes> 
<design:usageHints> 
<design:label>PRG_SCNR_NM</design:label> 
<design:formattingHints> 
<design:displaySize>50</design:displaySize> 
</design:formattingHints> 
</design:usageHints> 
</design:resultColumnDefinitions> 
<design:resultColumnDefinitions> 
<design:attributes> 
<design:name>PRG_DC</design:name> 
<design:position>10</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>PRG_DC</design:displayName> 
</design:uiHints> 
</design:attributes> 
<design:usageHints> 
<design:label>PRG_DC</design:label> 
<design:formattingHints> 
<design:displaySize>100</design:displaySize> 
</design:formattingHints> 
</design:usageHints> 
</design:resultColumnDefinitions> 
<design:resultColumnDefinitions> 
<design:attributes> 
<design:name>LAST_USER_ID</design:name> 
<design:position>11</design:position> 
<design:nativeDataTypeCode>12</design:nativeDataTypeCode> 
<design:precision>8</design:precision> 
<design:scale>0</design:scale> 
<design:nullability>NotNullable</design:nullability> 
<design:uiHints> 
<design:displayName>LAST_USER_ID</design:displayName> 
</design:uiHints> 
</design:attributes> 
<design:usageHints> 
<design:label>LAST_USER_ID</design:label> 
<design:formattingHints> 
<design:displaySize>8</design:displaySize> 
</design:formattingHints> 
</design:usageHints> 
</design:resultColumnDefinitions> 
<design:resultColumnDefinitions> 
<design:attributes> 
<design:name>LAST_PRG_ID</design:name> 
<design:position>12</design:position> 
<design:nativeDataTypeCode>12</design:nativeDataTypeCode> 
<design:precision>8</design:precision> 
<design:scale>0</design:scale> 
<design:nullability>NotNullable</design:nullability> 
<design:uiHints> 
<design:displayName>LAST_PRG_ID</design:displayName> 
</design:uiHints> 
</design:attributes> 
<design:usageHints> 
<design:label>LAST_PRG_ID</design:label> 
<design:formattingHints> 
<design:displaySize>8</design:displaySize> 
</design:formattingHints> 
</design:usageHints> 
</design:resultColumnDefinitions> 
<design:resultColumnDefinitions> 
<design:attributes> 
<design:name>LAST_MDFY_TS</design:name> 
<design:position>13</design:position> 
<design:nativeDataTypeCode>93</design:nativeDataTypeCode> 
<design:precision>26</design:precision> 
<design:scale>6</design:scale> 
<design:nullability>NotNullable</design:nullability> 
<design:uiHints> 
<design:displayName>LAST_MDFY_TS</design:displayName> 
</design:uiHints> 
</design:attributes> 
<design:usageHints> 
<design:label>LAST_MDFY_TS</design:label> 
<design:formattingHints> 
<design:displaySize>26</design:displaySize> 
</design:formattingHints> 
</design:usageHints> 
</design:resultColumnDefinitions> 
<design:resultColumnDefinitions> 
<design:attributes> 
<design:name>OBLGT_CTF_DT</design:name> 
<design:position>14</design:position> 
<design:nativeDataTypeCode>91</design:nativeDataTypeCode> 
<design:precision>10</design:precision> 
<design:scale>0</design:scale> 
<design:nullability>Nullable</design:nullability> 
<design:uiHints> 
<design:displayName>OBLGT_CTF_DT</design:displayName> 
</design:uiHints> 
</design:attributes> 
<design:usageHints> 
<design:label>OBLGT_CTF_DT</design:label> 
<design:formattingHints> 
<design:displaySize>10</design:displaySize> 
</design:formattingHints> 
</design:usageHints> 
</design:resultColumnDefinitions> 
<design:resultColumnDefinitions> 
<design:attributes> 
<design:name>PRG_CMBN_FL</design:name> 
<design:position>15</design:position> 
<design:nativeDataTypeCode>12</design:nativeDataTypeCode> 
<design:precision>1</design:precision> 
<design:scale>0</design:scale> 
<design:nullability>Nullable</design:nullability> 
<design:uiHints> 
<design:displayName>PRG_CMBN_FL</design:displayName> 
</design:uiHints> 
</design:attributes> 
<design:usageHints> 
<design:label>PRG_CMBN_FL</design:label> 
<design:formattingHints> 
<design:displaySize>1</design:displaySize> 
</design:formattingHints> 
</design:usageHints> 
</design:resultColumnDefinitions> 
<design:resultColumnDefinitions> 
<design:attributes> 
<design:name>NO_OF_PERIODS</design:name> 
<design:position>16</design:position> 
<design:nativeDataTypeCode>5</design:nativeDataTypeCode> 
<design:precision>5</design:precision> 
<design:scale>0</design:scale> 
<design:nullability>Nullable</design:nullability> 
<design:uiHints> 
<design:displayName>NO_OF_PERIODS</design:displayName> 
</design:uiHints> 
</design:attributes> 
<design:usageHints> 
<design:label>NO_OF_PERIODS</design:label> 
<design:formattingHints> 
<design:displaySize>6</design:displaySize> 
</design:formattingHints> 
</design:usageHints> 
</design:resultColumnDefinitions> 
</design:resultSetColumns> 
</design:resultSetDefinitions> 
</design:ResultSets> 
</model:DesignValues>]]></xml-property> 
</oda-data-set> 
</data-sets> 
<styles> 
<style name="report" id="4"> 
<property name="fontFamily">"Verdana"</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> 
</styles> 
<page-setup> 
<simple-master-page name="Simple MasterPage" id="2"> 
<property name="topMargin">0.25in</property> 
<property name="leftMargin">0.25in</property> 
<property name="bottomMargin">0.25in</property> 
<property name="rightMargin">0.25in</property> 
<page-footer> 
<text id="3"> 
<property name="contentType">html</property> 
<text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property> 
</text> 
</page-footer> 
</simple-master-page> 
</page-setup> 
<body> 
<table id="9"> 
<property name="width">100%</property> 
<property name="dataSet">Data Set</property> 
<list-property name="boundDataColumns"> 
<structure> 
<property name="name">PRG_ID</property> 
<property name="displayName">PRG_ID</property> 
<expression name="expression">dataSetRow["PRG_ID"]</expression> 
<property name="dataType">integer</property> 
</structure> 
<structure> 
<property name="name">PRG_TITL_TX</property> 
<property name="displayName">PRG_TITL_TX</property> 
<expression name="expression">dataSetRow["PRG_TITL_TX"]</expression> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="name">PRG_STS_CD</property> 
<property name="displayName">PRG_STS_CD</property> 
<expression name="expression">dataSetRow["PRG_STS_CD"]</expression> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="name">PRG_TYPE_CD</property> 
<property name="displayName">PRG_TYPE_CD</property> 
<expression name="expression">dataSetRow["PRG_TYPE_CD"]</expression> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="name">prgTypeCdGroupTitle</property> 
<property name="displayName">PRG_TYPE_CD</property> 
<expression name="expression">"The Program Type is: "+ dataSetRow["PRG_TYPE_CD"]</expression> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="name">ProgramTypeCodeGroupTitle</property> 
<property name="displayName">PRG_TYPE_CD</property> 
<expression name="expression">"Program Type is: "+ dataSetRow["PRG_TYPE_CD"]</expression> 
<property name="dataType">string</property> 
</structure> 
</list-property> 
<list-property name="sort"> 
<structure> 
<expression name="key">row["PRG_TYPE_CD"]</expression> 
<property name="direction">asc</property> 
</structure> 
</list-property> 
<column id="43"/> 
<column id="22"/> 
<column id="23"/> 
<column id="24"/> 
<header> 
<row id="10"> 
<cell id="40"> 
<label id="44"> 
<text-property name="text">PRG_TYPE_CD</text-property> 
</label> 
</cell> 
<cell id="11"> 
<label id="25"> 
<text-property name="text">PRG_ID</text-property> 
</label> 
</cell> 
<cell id="12"> 
<label id="27"> 
<text-property name="text">PRG_TITL_TX</text-property> 
</label> 
</cell> 
<cell id="13"> 
<label id="29"> 
<text-property name="text">PRG_STS_CD</text-property> 
</label> 
</cell> 
</row> 
</header> 
<group id="58"> 
<property name="groupName">NewTableGroup1</property> 
<property name="interval">none</property> 
<property name="sortDirection">asc</property> 
<expression name="keyExpr">row["PRG_TYPE_CD"]</expression> 
<structure name="toc"> 
<expression name="expressionValue">row["PRG_TYPE_CD"]</expression> 
</structure> 
<property name="repeatHeader">true</property> 
<property name="hideDetail">false</property> 
<property name="pageBreakAfter">auto</property> 
<property name="pageBreakBefore">auto</property> 
<property name="pageBreakInside">auto</property> 
<list-property name="sort"> 
<structure> 
<expression name="key">row["PRG_ID"]</expression> 
<property name="direction">asc</property> 
</structure> 
</list-property> 
<header> 
<row id="59"> 
<cell id="60"> 
<data id="70"> 
<property name="fontWeight">bold</property> 
<property name="textUnderline">underline</property> 
<property name="resultSetColumn">ProgramTypeCodeGroupTitle</property> 
</data> 
</cell> 
<cell id="61"/> 
<cell id="62"/> 
<cell id="63"/> 
</row> 
</header> 
<footer> 
<row id="64"> 
<cell id="65"/> 
<cell id="66"/> 
<cell id="67"/> 
<cell id="68"/> 
</row> 
</footer> 
</group> 
<detail> 
<row id="14"> 
<cell id="41"> 
<data id="45"> 
<property name="resultSetColumn">PRG_TYPE_CD</property> 
</data> 
</cell> 
<cell id="15"> 
<data id="26"> 
<property name="resultSetColumn">PRG_ID</property> 
</data> 
</cell> 
<cell id="16"> 
<data id="28"> 
<property name="resultSetColumn">PRG_TITL_TX</property> 
</data> 
</cell> 
<cell id="17"> 
<data id="30"> 
<property name="resultSetColumn">PRG_STS_CD</property> 
</data> 
</cell> 
</row> 
</detail> 
<footer> 
<row id="18"> 
<cell id="42"/> 
<cell id="19"/> 
<cell id="20"/> 
<cell id="21"/> 
</row> 
</footer> 
</table> 
</body> 
</report> 
 
 
 
ERROR 
java.lang.NoClassDefFoundError: org/eclipse/birt/report/engine/api/TOCStyle 
at org.eclipse.birt.report.engine.toc.TOCStyleUtil.getTOCStyle(TOCStyleUtil.java:45) 
at org.eclipse.birt.report.engine.toc.TOCView.getTOCStyle(TOCView.java:269) 
at org.eclipse.birt.report.engine.toc.ViewNode.<init>(ViewNode.java:44) 
at org.eclipse.birt.report.engine.toc.ViewNode.createGroupNode(ViewNode.java:136) 
at org.eclipse.birt.report.engine.toc.ViewNode.addViewNode(ViewNode.java:113) 
at org.eclipse.birt.report.engine.toc.ViewNode.createViewChildren(ViewNode.java:83) 
at org.eclipse.birt.report.engine.toc.ViewNode.getChildren(ViewNode.java:67) 
at org.eclipse.birt.report.engine.emitter.pdf.PDFPageDevice.createTOC(PDFPageDevice.java:172) 
at org.eclipse.birt.report.engine.emitter.pdf.PDFRender.createTOC(PDFRender.java:248) 
at org.eclipse.birt.report.engine.emitter.pdf.PDFRender.end(PDFRender.java:120) 
at org.eclipse.birt.report.engine.layout.emitter.PageEmitter.end(PageEmitter.java:61) 
at org.eclipse.birt.report.engine.layout.pdf.emitter.PDFLayoutEmitter.end(PDFLayoutEmitter.java:100) 
at org.eclipse.birt.report.engine.layout.pdf.emitter.WrappedPDFLayoutEmitter.end(WrappedPDFLayoutEmitter.java:69) 
at org.eclipse.birt.report.engine.layout.pdf.emitter.PDFLayoutEmitterProxy.end(PDFLayoutEmitterProxy.java:218) 
at org.eclipse.birt.report.engine.emitter.CompositeContentEmitter.end(CompositeContentEmitter.java:64) 
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:153) 
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:72)

JasonW

What do you have in the war/ear? Are you using just the WebViewer?

Jason

donwood

Jason, 
 
I am using the WebViewer for most reports. However, I have one report for which I ran into a bug with the WebViewer when I attempted to use the combination of a scripted dataset and DB2. (You had consulted with me on that in the Eclipse forum and finally a bug was logged for this at <a class='bbc_url' href='https://bugs.eclipse.org/bugs/show_bug.cgi?id=332462'>https://bugs.eclipse.org/bugs/show_bug.cgi?id=332462</a>.) As a result I started down the path of attempting to use the RE API, at least for this specific report. 
 
The WAR contains the JSP pages to which BIRT reports are rendered and BIRT rptdesign files. It also contains the report engine's lib directory (for the reports that are rendered via the WebViewer) and the platform/plugins directory for reports rendered via the RE API. 
 
In the EAR I have the following jars: 
engineapi.jar 
coreapi.jar 
modelapi.jar 
js.jar 
org.apache.commons.codec_1.3.0.v20080530-1600.jar 
 
I had to put these here for business and action classes that exist in a utility project. (I couldn't build a dependency from the utility project to the WAR since I already had a dependency going in the other direction.) 
 
If this isn't specifically what you are looking for, please let me know. Again, thanks for your help. 
 
Don

JasonW

Don,

The WebViewer and the RE API require the lib(all jars) and the plugins directory. Are you deploying both in the same war?

Jason

donwood

Jason,

Yes, I'm deploying both in the same WAR.

Don

JasonW

Don,

If they are both in the same war why do you have this listed separately:

engineapi.jar
coreapi.jar
modelapi.jar
js.jar
org.apache.commons.codec_1.3.0.v20080530-1600.jar

I know these are in the ear but this may cause conflicts with the ones in the WEB-INF/lib

Jason

donwood

Jason,

Our business classes needed to resolve the imports of the birt packages. The business classes are in a utility project and the BIRT packages are (currently) in my web project. We already had a dependency from the web project to the utility project and when we attempted to create the necessary dependency from the utility to the web project, I received the error "A cycle has been detected" or something to that affect...in other words, I ended up with a circular dependency.

So, in order to address this issue, I added the jars that were needed to resolve the import issues to the EAR. Most, if not all, of these were resolved by adding in the engineapi.jar. However, I was getting other errors at run time (I don't have them documented at this time) but it was easy enough to see which jars were the issue so, one by one, I added the remaining four jars so that finally I could at least render the HTML version of the reports.

I'm sure you are right that there is some sort of conflict going on here; we are just struggling with how to set up our application so that it supports the break out we put in place previously...keeping jsp/html separate from business/action classes, etc. We don't want to duplicate jars if we can prevent it. If you have suggestions, that would be great.

Thanks again,
Don

JasonW

Don,

That is a tough one. Not sure on what you should do. Have you tried to add all the jars from the reportengine/lib just to see if it worked?

Jason

donwood

Jason, 
 
I added all the jar files from the reportengine/lib directory to my EAR project but that didn't help. However, I then also created a platform directory with a linked folder to the plugins directory in my web project. (Apparently this doesn't yield a circular reference as before.) I also created a configuration folder in the EAR with a copy of config.ini and now I'm able to produce the PDF version of my report. FYI - I eventually removed the linked plugins folder and everything still works. 
 
From this I'm assuming that the platformcontext that the report engine is using is the one in the web project (the WAR). What confuses me is why it doesn't then use the configuration folder that is contained in the WAR rather than the one in the EAR. 
 
Anyway, I'm happy that it's now working. Thanks for your input throughout this. 
 
-Don