Eclipse Community Forums: BIRT » SQL Server 2000 - There are error(s) in Table:null

Home » Archived » BIRT » SQL Server 2000 - There are error(s) in Table:null

SQL Server 2000 - There are error(s) in Table:null [message #90165]

Fri, 11 November 2005 10:37

Eclipse User

Like a couple other posts... I am able to view preview my result set in my
data set's "Preview Results". However, previewing as HTML or PDF results in
and error:

There are errors on the report page:
+ There are error(s) in Table:null

Thanks
- Justin

Re: SQL Server 2000 - There are error(s) in Table:null [message #90196 is a reply to message #90165]

Fri, 11 November 2005 10:41

Eclipse User

Here is my .rptdesign... Also I'm using Birt RCP

xml version="1.0" encoding="UTF-8"?>

<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="Data Source">
<property
name="odaDriverClass">com.microsoft.jdbc.sqlserver.SQLServerDriver </property>
<property
name="odaURL">jdbc:microsoft:sqlserver://crntds20:1433;databasename=PREP_DEV2</property>
<property name="odaUser">PR_Admin</property>
<encrypted-property
name="odaPassword">cHJwcnBy</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="PersonList">
<property name="dataSource">Data Source</property>
<property name="queryText">select * from
dbo.PersonList</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">PersonList</property>
<column/>
<column/>
<column/>
<header>
<row>
<cell>
<label>
<text-property name="text">PID</text-property>
</label>
</cell>
<cell>
<label>
<text-property name="text">Login</text-property>
</label>
</cell>
<cell>
<label>
<text-property name="text">Name</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row>
<cell>
<data>
<expression
name="valueExpr">row["PID"]</expression>
</data>
</cell>
<cell>
<data>
<expression
name="valueExpr">row["Login"]</expression>
</data>
</cell>
<cell>
<data>
<expression
name="valueExpr">row["Name"]</expression>
</data>
</cell>
</row>
</detail>
<footer>
<row>
<cell/>
<cell/>
<cell/>
</row>
</footer>
</table>
</body>
</report>

Re: SQL Server 2000 - There are error(s) in Table:null [message #90287 is a reply to message #90165]

Fri, 11 November 2005 15:08

Eclipse User

Please make sure you put the jdbc driver in both directories below:

C:\eclipse-SDK-3.1-win32\eclipse\plugins\org.eclipse.birt.re port.data.oda.jdbc_1.0.1\drivers

C:\eclipse-SDK-3.1-win32\eclipse\plugins\org.eclipse.birt.re port.viewer_1.0.1\birt\plugins\org.eclipse.birt.report.data. oda.jdbc\drivers

Kelvin

Justin Toennies wrote:
> Like a couple other posts... I am able to view preview my result set in my
> data set's "Preview Results". However, previewing as HTML or PDF results in
> and error:
>
> There are errors on the report page:
> + There are error(s) in Table:null
>
> Thanks
> - Justin
>
>

Previous Topic:	Report viewer problem with frameset
Next Topic:	BIRT Report Designer log file location

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jun 13 10:08:14 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter