[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
[birt-report-designer-dev] There are errors on the report page
|
Hi all,
Hopefully this is the correct list to be posting to. I am testing out BIRT as a replacement for Crystal Reports within our organization and have run into a snag. I am attempting to connect to a Progress 9.1C database via JDBC and believe I have everything set up correctly. I was able to create a new report, create a data source (Test Connection says "Connection Sucessful), and create a data set (Preview Results shows the data as expected). I then added a table and dropped three fields into the Detail section. However, when I go to preview the report I get the following error:
There are errors on the report page:
+ There are error(s) in Table:null
Per another thread on this topic, I looked at the bindings for my table and it appears to be correctly linked to my data set. Does anybody have any other suggestions for me to try? Here is my report design:
---
<?xml version="1.0" encoding="UTF-8"?>
<!-- Written by Eclipse BIRT 1.0 -->
<report xmlns=" http://www.eclipse.org/birt/2005/design"; version="2">
<property name="createdBy">Eclipse BIRT Designer Version 1.0.1 Build <20050729-0746></property>
<property name="units">in</property>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Vantage 5.0 Data Source">
<property name="odaDriverClass">com.progress.sql.jdbc.JdbcProgressDriver</property>
<property name="odaURL">jdbc:jdbcprogress:T:oc_apps1:2550:vantage</property>
<property name="odaUser">sysprogress</property>
<encrypted-property name="odaPassword">REMOVED FROM POST</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Employees">
<property name="dataSource">Vantage 5.0 Data Source</property>
<property name="queryText">select *
from pub.empbasic
where company = 'OCW'</property>
</oda-data-set>
</data-sets>
<page-setup>
<simple-master-page name="Simple MasterPage">
<page-footer>
<text>
<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>
<property name="width">100%</property>
<property name="dataSet">Employees</property>
<column/>
<column/>
<column/>
<header>
<row>
<cell>
<label>
<text-property name="text">EmpID</text-property>
</label>
</cell>
<cell>
<label>
<text-property name="text">Name</text-property>
</label>
</cell>
<cell>
<label>
<text-property name="text">JCDept</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row>
<cell>
<data>
<expression name="valueExpr">row["EmpID"]</expression>
</data>
</cell>
<cell>
<data>
<expression name="valueExpr">row["Name"]</expression>
</data>
</cell>
<cell>
<data>
<expression name="valueExpr">row["JCDept"]</expression>
</data>
</cell>
</row>
</detail>
<footer>
<row>
<cell/>
<cell/>
<cell/>
</row>
</footer>
</table>
</body>
</report>
---
Thanks in advance,
Adam
