[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.