APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to call a report with a bind variable from a multi-record block

497509Dec 11 2008

Hi,

I have created a report using the BI Publisher functionality. I did all the integration, created the SQL Query and uploaded the template. Up till here everythings fine!
My SQL Query has 2 bind variables.

I will call my report from a multi record block, at the end of each record an icon is shown which the user can click to open the report.

I created a column link for this item (PRINT_REPORT=Inschrijvingsformulier) but I do not manage to pass the parameters to my report. The parameters I want to pass are 2 columns in this Multi Record block.

I created 2 hidden fields on the page P9_PARAMETER1, P9_PARAMETER2 with the same names as my bind variables and fill this in with the values #PARAMETER1#, #PARAMETER2# from the multi record block.
It seems it does not work as my report stays empty. (also XML file stays empty).

Am I trying the wrong way?

Thanks for any advice,

Kris