building a single table from different data sets.

Hello,

I'm trying to build a single table from different data sets. This is because the needed queries can't be preformed at the same time. I noticed that I can't pull in fields from different queries and I'm not sure why. Can someone speak on this?

-Will

Find more posts tagged with

Comments

mwilliams

Hi Will,

The reason for this is that you can only associate a data item with one other report item or dataSet. What you'll need to do is create a joint dataSet with the data that you want to include in the table.

Another possibility, if it works for you, is you could also embed a table in another table and bind them to different dataSets and use filters to get the right data on the inner table. This would obviously only work for certain setups.

Hope this helps. Let me know if you have any questions.

MarcinK

Will,
the best way to do it is dataset join like mwilliams suggested.
If you need just 2 datasets then you can bind one to table and the other to cell only. This worked for me in few simple examples.

Kind regards,
Marcin K.

wjblack

Thanks for the info. Ok, I tried using the joint data set. I have three data sets I need to join. I was able to create one based off a field called 'key' (jointds1). I then tried to create another joint data set from the first created (jointds1) and another data set, but there's not field options to select on to join the tables. Am I doing something wrong or can the joint data set only have 2 data sets?

mwilliams

Will,

What version of BIRT are you using? That way I can just try it in your version.

mwilliams

Will,

I created a joint dataSet in BIRT 2.2.2 and then joined that dataSet with another dataSet and it worked as expected. What do your 3 dataSets look like?

wjblack

I'm using BIRT 2.2.2. Each of the dataset is expecting a passed parameter 'Date'. This is currently setup through the report parameter. It works for each of the single datasets, but when I try and create a joint dataset it doesn't even populate the drop down list. I'm thinking it has something to do with a passed parameter because when I hard code in a date the join works. Is there something special that needs to be setup when doing a join from datasets that are expecting parameters?

mwilliams

Will,

Can you re-create this issue with the sample database so I can take a look at it in a report that I can run? Thanks.