Multiple data set

hi,
I am doing Employee Info report.
My requirement is ,I want to display Company info and below that info i want to display list of employees.
I am using one data set for getting company info and another data set for displaying list of employees.
i am giving where condition clause for the first and second data sets.
My problem is : Report is displaying second data sets data.I am unable to get combined data set data.
Could you help me in solving this problem?

Thanks & regards
Kavitha

Find more posts tagged with

Comments

mwilliams

Kavitha,

I'm not sure I'm quite understanding correctly? Are you using 2 separate dataSets? Or are you joining the two into a single one? Could you explain a little more about your issue? Thanks.

KavithaD

hi,

I am trying to display drill down records in PDF format.
parent -- >
child -- >
child -->
child --> etc

can you help in doing?

Thanks & regards
Kavitha

mwilliams

Kavitha,

So, you have 2 dataSets, company and employees? You want to be able to display the results as:

Company1 Info
-C1Employee1
-C1Employee2
-C1Employee3
Company2 Info
-C2Employee1
-C2Employee2
-C2Employee3
etc. ??

Have you made this into a joint dataSet? Please explain more about your data, so I can understand better on where you're at. Thanks.

Virgil Dodson

Hi Kavitha, It sounds like the only thing missing is the binding between your outer table and the inner table. To do this, select your inner table, then binding tab on the property editor. From here, you can press the Data Set Paremater binding button and replace the default parameter value with a value belonging to the outer table... In your case, select company id which will get fed into where clause of employee query.

Enclosed is an example create with BIRT 2.3.2

KavithaD

Hi,

My requirement is,
Company is related to teams,teams has managers,managers related to leads,leads related to team members.
Its like drill down.each group has subgroups and subgroups has other subgroup.
this relation goes like that.I am able to achieve to display company and teams. but i came to know to achieve this requirement i have to create dynamic table.Is my under standing is correct?

Eg:Parent group1 --> child group1 -->subchild group1--> .......
Parent group2 --> child group2 -->subchild group2--> .......
Parent group3--> child group3 -->subchild group3--> .......

I am having entity class that has all the data I need to map that entity class to report.That may solve my problem.But I dont know how to use java class in scripted data set.I tried but Its not recognising my getter n setter method.
On scripted data set open script I am writing like
count = 0;

// Create instance of
// the GetStockHistory class
res = new Packages.com.ags.agcli.bo.report.reportServiceImpl();
//Load the List

stock = res.getStockValues("Java");

On scripted data set fetch script I am writing
row["Message"] = stock.getName();
row["Name"] = stock.getMessage();
return true;

My entity class is like this ::

count = 0;

// Create instance of
// the GetStockHistory class
res = new Packages.com.ags.agcli.bo.report.reportServiceImpl();
//Load the List

stock = res.getStockValues("Java");

My service class is like this ::

package com.ags.agcli.bo.report;

import java.util.ArrayList;
import java.util.List;

public class reportServiceImpl {
public List<reportService> getStockValues(String company) {

List<reportService> history = new ArrayList<reportService>();

reportService data = new reportService();
data.setName("name");
data.setMessage("message");
history.add(data);

return history;
}
}

On preview of data set ,I am getting error like

A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.5.0.v20090605
Error Code:A BIRT exception occurred: There are errors evaluating script "__bm_fetch()":
TypeError: Cannot find function getName in object [com.ags.agcli.bo.report.reportService@192195d]. (<inline>#2). See next exception for more information.
There are errors evaluating script "__bm_fetch()":
TypeError: Cannot find function getName in object [com.ags.agcli.bo.report.reportService@192195d]. (<inline>#2)
Error Message:A BIRT exception occurred: There are errors evaluating script "__bm_fetch()":
TypeError: Cannot find function getName in object [com.ags.agcli.bo.report.reportService@192195d]. (<inline>#2). See next exception for more information.
There are errors evaluating script "__bm_fetch()":
TypeError: Cannot find function getName in object [com.ags.agcli.bo.report.reportService@192195d]. (<inline>#2)

Plz help me

Thanks & regards
Kavitha