Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Problem with scripted Dataset(passing the list from classfile to scripted dataset)
Problem with scripted Dataset [message #999010] Fri, 11 January 2013 06:33 Go to next message
ranjith kumar is currently offline ranjith kumarFriend
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...
Re: Problem with scripted Dataset [message #1000901 is a reply to message #999010] Tue, 15 January 2013 16:48 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1878
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.


Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.

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

Current Time: Sun Mar 29 17:35:14 GMT 2015

Powered by FUDForum. Page generated in 0.01593 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software