Eclipse Community Forums: BIRT » Problem with scripted Dataset

Help

Home

Home » Archived » BIRT » Problem with scripted Dataset(passing the list from classfile to scripted dataset)

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

Problem with scripted Dataset [message #999010]

Fri, 11 January 2013 06:33

ranjith kumar

Messages: 1
Registered: January 2013

Junior Member

hello everyone,
I am new to birt.I just created a class consist of jdbc connectivity to execute query.and convert the resultset to lists .for Eg select id,name from table is the query.
from the resultset,I get two columns in different lists(eg String input=resultset.getString(1) and String input2=resultset.getString(2) and put those string values in lists).and getId() and getName() returns the lists.
In report on open() i coded like sha=new Packages.classname();inputId=sha.getId();inputName.getName();then in fetch() row["id"]=inputId;row["name"]=inputName;i gave inputs to the columns.but when i preview the report no data is displayed on viewer.

please check out the attached class file and help to solve this issue...

Attachment: ConnectionTest.class
(Size: 1.89KB, Downloaded 127 times)

Report message to a moderator

Re: Problem with scripted Dataset [message #1000901 is a reply to message #999010]

Tue, 15 January 2013 16:48

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

So, sha.getID() and sha.getName() will each return a list? If so, you would need to use your fetch script to iterate through the returned lists, not just assign the list to a column.

Michael

Developer Evangelist, Silanis

[Updated on: Tue, 15 January 2013 16:49]

Report message to a moderator

Previous Topic:	Html reports without charts
Next Topic:	specify alternate JDBC drivers folder

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 27 02:34:27 GMT 2023

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter