how to pass a result set to birt?

Hi,all
how can i pass a result set to birt, and display it in a table?

Find more posts tagged with

Comments

Hi stf,

What format is the result set in? Is it in a flat file of some sort? Please explain a little more in detail. Thanks.

stf

<blockquote class='ipsBlockquote' data-author="mwilliams">Hi stf, 
 
What format is the result set in? Is it in a flat file of some sort? Please explain a little more in detail. Thanks.</blockquote>
 
It's a java object generated in a service. For example: 
public class UserServiceImpl implements IUserService{ 
private List<User> userList; 
public void searchUserList(some params from the request) 
{ 
..... 
userList=query.getResultList();//get the result through JPA 
} 
public List<User> getUserList(){ 
return userList; 
} 
} 
The service is defined in application.xml. 
I want to get the userList from the defined service,Not by using new Packages...UserServiceImpl. getUserList(),for the userList has data only after i transfer params to searchUserList() and call this function.

CBR

Do you use the BIRT WebViewer or do have you integrated the Report Engine API directly in your application. 
If you use Report Engine API you can set the ApplicationContext before executing a report. The ApplicationContext is a HashMap<String, Object> 
where you can put any object identified by a key. 
In your report you can then get the HashMap with 
reportContext.getAppContext(); (see: <a class='bbc_url' href='http://www.birt-exchange.org/documentation/BIRT_231/EngineJavadoc/enginescript/api/index.html'>Birt Script API 2.3.0</a>) 
 
Do you run your services inside of Spring or EJB3?

stf

<blockquote class='ipsBlockquote' data-author="CBR">Do you use the BIRT WebViewer or do have you integrated the Report Engine API directly in your application. 
If you use Report Engine API you can set the ApplicationContext before executing a report. The ApplicationContext is a HashMap<String, Object> 
where you can put any object identified by a key. 
In your report you can then get the HashMap with 
reportContext.getAppContext(); (see: <a class='bbc_url' href='http://www.birt-exchange.org/documentation/BIRT_231/EngineJavadoc/enginescript/api/index.html'>Birt Script API 2.3.0</a>) 
 
Do you run your services inside of Spring or EJB3?</blockquote>
 
 
I use BIRT WebViewer,did't use Report Engine API directly. 
The services run inside of Spring. 
What i do is: 
1)design a report ****.rptdesign,use scripted data source,scripted data set 
2)in the jsp,click Submit, go to a servlet 
3)the servlet search satisfied records from db,and generate a List 
//I want to know how to pass the List to ****.rptdesign and the bind the List to the scripted data set. 
Is it possible to use ApplicationContext in the controller?