Using two datasets in a report

Hi All,

I need to use two data sets having two dofferent tables.

When tried this , it fetches values only for the first dataset values.

Can I use two datasets and two tables in a report..

Need your suggestions.

Thanks,

Sankar ganesh

Find more posts tagged with

Comments

mwilliams

Hi Sankar,

Yes, you can have multiple dataSources and multiple dataSets within BIRT. Did you make sure to bind the second dataSet to the second table? You may try selecting the table and looking at teh binding tab in the property editor. Let me know.

BIRTing

Hi Michael,

I did the same as you said.I used two data sets binded with two tables.

But it fetches records only for the first dataset.

Actually i am not using the default template provided by maximo.

I am using maximo template(needed in our project) and maximo datasource..

Is it because of that i am not getting the result..

Waiting for your reply...

Thanks,

Sankar Ganesh

mwilliams

Sankar,

In the second dataSet, are you able to see the results in the dataSet editor under "Preview Results"? If so, where are you running the report? In the preview screen or the web viewer? The preview screen only pulls in a certain amount of data, so if your first dataSet has a lot of data, you may not see the second table in this case because the preview won't accept that much data. If you're using the preview screen, try the web viewer. Let me know.