Focal Point
[CLOSED] Conditional Drill Down GUI Defines Column Twice

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

August 09, 2012, 01:44 PM
Kevin Patterson
[CLOSED] Conditional Drill Down GUI Defines Column Twice
When I try to apply a condition to a drill down the code that is generated does not seem to work for me:
=====================================================
TYPE=DATA,
COLUMN=N7,
TARGET='_blank',
FOCEXEC=app/sidebysideyeartoyeartransdets( \
ACCOUNT=N1 \
FUND=N2 \
FISCAL_YEAR='2011' \
FISCAL_YEAR_LESS1='2010' \
),
$
TYPE=DATA,
COLUMN=N7,
MACRO=RULE_CLASS_5CRT,
=====================================================


It defines column 7 twice. I changed it to the following and it worked as expected for me:
=====================================================
TYPE=DATA,
COLUMN=N7,
TARGET='_blank',
FOCEXEC=app/sidebysideyeartoyeartransdets( \
ACCOUNT=N1 \
FUND=N2 \
FISCAL_YEAR='2011' \
FISCAL_YEAR_LESS1='2010' \
),
MACRO=RULE_CLASS_5CRT,
=====================================================

Is my correction correct? Is there truly a "bug" in the GUI or am I just misusing it?

This message has been edited. Last edited by: Kerry,


Kevin Patterson
Appalachian State University
WebFOCUS 7.7.03
Windows, All Outputs
August 13, 2012, 04:14 PM
Doug
What is the "condition" which you are trying to apply? Consider the use of "WHEN", i.e.:

... WHEN=FIELD_NAME EQ 'THIS', ...

within the associated "TYPE=DATA" statement.




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
August 14, 2012, 12:05 PM
Kerry
Thanks Doug for the input.

Kevin, have you got a chance to try Doug's suggestion? If you still think this may be a bug, the proper channel for assistance would be to open a case with Customer Support Services for further research. You may 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.