November 30, 2006, 04:56 PM
spdam0Drilldown Reports with text parameters
I am having problems with drill down reports that have text for fields other than the field being drilled on. I have a selfservice app that creates the following URL
http://webfadhsec01.target.com/ibi_apps/WFServlet?IBIF_..._PROB_CATG_I%20EQ%20'PCAT-00007779')
This works fine until I click on the field to be drilled on. In this case RCC=Administrations. This is the URL that is in the excel cell.
http://webfadhsec01.target.com/ibi_apps/WFServlet?IBIF_...0EQ%20&PCAT-00007779')'=
It changes the ' to a & in front of PCAT and adds '= at the end.
Here is the snipet of code that is used for the drilldown
TYPE=DATA,
COLUMN=N2,
FOCEXEC=rcc_breakdown_detail(RCC=N2 WHERE_CLAUSE='&WHERECLAUSE'),
$
I need to pass the same whereclause to my drilldown as to my parent report but if it contains ' the drilldown doesn't work.
Thank you for the help in advance.
November 30, 2006, 08:56 PM
susannahDean,
excel is tripping you up, can you simplify your code to pass a single code element and then in your guest fex, tranlate that single code element into the corresponding WHERE statement. That would be the bullet-proof way to do it, imho.
-S.