nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Passing a value to a child data set

megabri

How do I pass a value from a main dataset to a child data set? I'm using a JDBC connection. My main data set is SELECT CLAIMID, PERSONID FROM CLAIM and my child data set is SELECT PERSONID, FIRSTNAM, LASTNAME FROM PERSON. I want to show the child data set in a table under the main data set so it will show claim information then under it person information. I need to pass the PERSONID from the main data set to the child. Any ideas?

Find more posts tagged with

Comments

GLO_FR

Hi,
 
why didn't you join your two query in one or use a nested table ?

megabri

I'm trying to do a nested table but i need the value from the main table passed to the child table.

GLO_FR

No problem.
I will send you an example.
 
what version of BIRT are you using ?

GLO_FR

Here is an example made with BIRT 3.7.2
 
The trick is to give a name to your master table and your child table.
Once you have created the group inside your master table, on the group section, place your child table and on this table, on the filter sheet, create a link between master and child 'see screenshot)

megabri

That's just what i was looking for! Thank you so much!

GLO_FR

you're welcome