[SOLVED]Accordion Report: How to suppress the plus sign if the fields are empty
How can I suppress the plus sign if the fields in a Accordion Report are empty?
Just as an example, in the following Code is TEMP1 and TEMP2 allways empty, so it would be nice that the plus sign in front of These 2 TEMP-Fileds would not appear or is not clickable.
Is this in some Way possible? Maybe in Styleshett?
DEFINE FILE CAR TEMP1/A1=''; TEMP2/A1=''; END
TABLE FILE CAR -*SUM BHP BY COUNTRY BY CAR BY MODEL BY BODYTYPE BY BHP BY TEMP1 BY TEMP1 ON TABLE SET EXPANDABLE ON ON TABLE SET EXPANDBYROW ALL ENDThis message has been edited. Last edited by: <Emily McAllister>,
WebFOCUS 8 Linux, All Outputs
February 03, 2016, 04:02 AM
SWES
I suggest you do not use TEMP1 as a BY field but use it as SUM field, if possible?
WebFOCUS 8105m Windows 7, All Outputs
Member of the Benelux Usergroup
February 05, 2016, 04:59 AM
Bruno Gubler
Please let me a Little precise, if TEMP1 is empty, then I want no + sign, but if filled it must have an + sign:
DEFINE FILE CAR TEMP1/A1=IF BODYTYPE EQ 'CONVERTIBLE' THEN 'X' ELSE ''; TEMP2/A1=IF BODYTYPE EQ 'CONVERTIBLE' THEN 'Y' ELSE ''; END
TABLE FILE CAR -*SUM BHP BY COUNTRY BY CAR BY MODEL BY BODYTYPE BY BHP BY TEMP1 BY TEMP1 ON TABLE SET EXPANDABLE ON ON TABLE SET EXPANDBYROW ALL END
WebFOCUS 8 Linux, All Outputs
February 10, 2016, 06:49 AM
Bruno Gubler
Like this it works:
DEFINE FILE CAR TEMP1/A1=IF BODYTYPE EQ 'CONVERTIBLE' THEN 'X' ELSE ''; TEMP2/A1=IF BODYTYPE EQ 'CONVERTIBLE' THEN 'Y' ELSE ''; END TABLE FILE CAR -*SUM BHP BY COUNTRY BY CAR BY MODEL BY BODYTYPE BY BHP BY TEMP1 BY TEMP1
ON TABLE SET EXPANDABLE ON ON TABLE SET EXPANDBYROW ALL END -RUN