How using ireport designer can I include 2 related records from the same table to output on one report. I have a table that contains marriage data so in one row will be the groom data and the other the bride data (field names are the same).
I have got one record displaying on the jasper report using WHERE ID = $P{marriageid}
But how would I adapt this and the report to display both the bride and the groom details on the same report. The where clause would be marriagedate, bookid,booknumber
I would also need to have 2 lots of each text fields displayed on the form because the positioning of the output data for the groom is in a different position on the form to the bride.
Hope someone can shed some light on this and the best solution please
Displaying 2 related records from the same table on the same Jasper form
in Products
Posted
Hi
How using ireport designer can I include 2 related records from the same table to output on one report. I have a table that contains marriage data so in one row will be the groom data and the other the bride data (field names are the same).
I have got one record displaying on the jasper report using WHERE ID = $P{marriageid}
But how would I adapt this and the report to display both the bride and the groom details on the same report. The where clause would be marriagedate, bookid,booknumber
I would also need to have 2 lots of each text fields displayed on the form because the positioning of the output data for the groom is in a different position on the form to the bride.
Hope someone can shed some light on this and the best solution please