January 27, 2015, 05:30 PM
Joni Campbell - Europa SportsThe Value Passed in Drill Down May Contain an Apostrophe
We have a data value that contains an apostrophe, and when that value is selected for a drill down from a dashboard routine, an error is returned and the drill down report is not produced. I've found some discussion about QUOTEDSTRING related to apostrophes, but am not sure that it would be a fix in a drill down process. Is this an appropriate use of QUOTEDSTRING? Thank you.
January 27, 2015, 05:49 PM
Francis MarianiJoni, yes, I think this will work for the drilldown code and the filter in the drilldown report. In your case, since it's in the data, you only need to worry about the drilldown report.
one report example:
TYPE=DATA, ACROSSCOLUMN=AMOUNT, TARGET=drilldownReport, WHEN=ACTIVITY_SORT NE '1',
FOCEXEC=IBFS:/WFC/Repository/reports/forecast/report_dd1.fex (\
TYPE = 'DATA' \
BUS_DTE = '&BUS_DTE' \
PMTDATE = PMTDATE \
BANK_ACC = BANK_ACC \
NODE_2 = &NODE_2.QUOTEDSTRING \
another drilldown report example:
WHERE ( FUND.GROUP EQ &GROUP.QUOTEDSTRING );
WHERE ( FUND.FUND EQ &FUND.QUOTEDSTRING );
WHERE FUND.CLASS EQ &CLASS.QUOTEDSTRING ;
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server