Skip to Main Content

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!

Passing Values to an RDF Report

DougMay 24 2012 — edited May 27 2012
APEX is too damn finicky when it comes to passing values to an rdf report run from an apex page. This problem perhaps needs attention from the upper eschelon gerus. It is a time killer, and it should not happen.

The problem: I have two page items ("P102_CALCDATE" and "P102_LOANTYPES"). Both are populated. I want to pass their values via parameters to a report. Here is the url calling the report:

javascript:popupURL('&P2_HOST_NAME./reports/rwservlet?sf2key&destype=cache&desformat=PDF&paramform=no&report=FFintcalculator&xdateparam=&P102_CALCDATE.&dktnrparam=&P102_LOANTYPES.');

The P102_CALCDATE item (a date picker item) has the date "24-May-12" in it; the P102_LOANTYPES item is a radio group with the Quota Share option selected which returns a value of "FFQ". But here is what I get when the report runs (empty, of course):

https://www.st-dev.xxxxxx.xxx/reports/rwservlet?sf2key&destype=cache&desformat=PDF&paramform=no&report=FFintcalculator&xdateparam=&dktnrparam=

As I say, the report runs, but since the parameters are not passed, it comes up empty. I have had this same problem with other reports, and it is really getting frustrating. I have one report for which the items for the passed values were populated by javascript dynamic actions, but the values would not pass. So I wrote PLSQL functions to populate the items, and then 3 out of 5 passed successfully. Why only 3? Why would they not pass when the items were populated by the dynamic action? The values were the same as those from the PLSQL.

This makes me cuss. Please help.

Edited by: Doug on May 24, 2012 10:20 AM
This post has been answered by VC on May 25 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 24 2012
Added on May 24 2012
11 comments
1,179 views