APEX

My app provides end users a way to fill a transport demand via a form, seperated into about 10 regions. The demand consists of about 50 fields (from the demands table) and n number of transports, entered via a tabular form in the demand form. Once they complete it and send it to the transport department, I want them to be able to generate a Master/Detail Report of the demand, with the information of the demand on top, and all the transports in a table below.

The DBA installed Apache FOP, and it works great for report printing. We're on Apex 3.2, exploiting a 11g Oracle Database.

So I followed this guide: http://www.oracle.com/technology/products/database/application_express/howtos/howto_master_detail_pdf.html. I created a master/detail form, installed BI Publisher Desktop, created the RTF Template, everythng. But it doesn't output what I want.

When I "print" it in PDF, I only get a table with the transports, but no info on the demand at all, even though I selected "Advanced (include session state information)" and I did include session state info on all the variables I wanted to output in the PDF.

Any idea what might be causing this? Is session state cleared somehow when I print the PDF? Or is there a better way of accomplishing this? Any and all help is welcome.

Best regards,
Mathieu