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
