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

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

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

Fri, 11 November 2005 15:37

Justin Toennies

Messages: 4
Registered: July 2009

Junior Member

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

Report message to a moderator

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

Fri, 11 November 2005 15:41

Justin Toennies

Messages: 4
Registered: July 2009

Junior Member

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>

Report message to a moderator

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

Fri, 11 November 2005 20:08

Kelvin Chu

Messages: 12
Registered: July 2009

Junior Member

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
>
>

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 17 14:45:03 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter