Fill placeholder with data from another table

fryeah

Hello!


I am trying to create a report which shows the entries of a table, let's call it "text". Of course, this is working with a data set and a sql query.
But, i have a tricky requirement: in the table "text" are in several rows placeholders. these placeholders should be replaced with corresponding entries from another table "picture".
the primary key of "text" is the foreign key in "picture".
additionally, the two tables are read-only, so i have to find a way to get the information in BIRT.

i am not able (but maybe somebody) to create a sql query that facilitates that task, but maybe there is another way to achieve this.

any help is appreciated! :-)

mwilliams

Hi fryeah,

So you can bring in the data from both tables to separate SQL dataSets? If this is the case, can you join the two dataSets into a joint dataSet on the common key and then just display the columns needed from the joint dataSet in your report table? Let me know if I'm not understanding the issue correctly.