Passing Values to an RDF Report
DougMay 24 2012 — edited May 27 2012APEX 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¶mform=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¶mform=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