Focal Point
The Value Passed in Drill Down May Contain an Apostrophe

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3707074476

January 27, 2015, 05:30 PM
Joni Campbell - Europa Sports
The 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.


8009
Windows, HTML, AHTML, Excel
In FOCUS since 1983
January 27, 2015, 05:49 PM
Francis Mariani
Joni, 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