how to hide conditional hyperlink on heading if record EQ 0

Hi,

I am trying to find a way to hide conditional hyperlink on heading if record is showing 0. The problem is in my master fex, I have a query like:
TABLE FILE TABLE1
PRINT .....
END
HEADING '.....'

In my heading, I want to apply the conditional formatting actually from
TABLE FILE TABLE2
WHERE ....

IF &RECORDS NE 0 THEN
display 'Click here to drill down to child report' on my heading

and if &RECORDS EQ 0 THEN display blank line on heading.

Please suggest.

Julie

Posts: 28 | Registered: October 26, 2006

ypatel

Silver Member

posted

Hide Post

Julie, Try this
Step 1 do the table file that is the deciding factor in displaying hyper link or not..

TABLE FILE TABLE2
WHERE ....

Step 2 - set a variable

-SET &HLINK = IF &RECORDS NE 0 THEN
'Click here to drill down to child report'
ELSE ' ';

Now use this &HLINK in your heading of table file 1.
TABLE FILE TABLE1
PRINT .....
HEADING
"&HLINK.EVAL"
..
END

Hope this helps !!

-Yogesh Patel
------------------------------------------------------------------------
PROD: WF 764 on Linux Apache tomcat v5.5
DEV: WF 768 on Linux

Posts: 42 | Location: Edison, New Jersey | Registered: January 30, 2007

Ignored post by ypatel posted

Show Post

JZMSH

Member

posted

Hide Post

Yogesh,

It works perfectly. Thank you so much.......

Julie

Posts: 28 | Registered: October 26, 2006

Ignored post by JZMSH posted

Show Post

JZMSH

Member

posted

Hide Post

Hi again,

When I tried to apply a condition for &HLINK.EVAL in the style sheet, syntax as:
DEFMACRO=HLINKCOND1, MACTYPE=RULE, WHEN = '&HLINK2' NE ' ', $

TYPE=HEADING, LINE=1, MACRO=HLINKCOND1, FOCEXEC=CHILD_REPORT, $

It didn't work. Does anyone know how to fix it?

Posts: 28 | Registered: October 26, 2006

Ignored post by JZMSH posted

Show Post

Darin Lee

Virtuoso

posted

Hide Post

I don't know if you can do conditional styling on the HEADING like you are wanting specify. The proper format is WHEN=field1 operator {field2|value}, $
Conditional styling is based on the value of a field on a record. HEADINGs are unrelated to individual records. They appear at the top of every page regardless of record values. Try defining a field to the value of &HLINK2 (you can NOPRINT it) and then use that field in your WHEN.

Regards,

Darin

In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

Show Post

Tom Flynn

Expert

posted

Hide Post

JZMSH,

Some folk's don't like branching, I do:

quote:

DEFMACRO=HLINKCOND1, MACTYPE=RULE, WHEN = '&HLINK2' NE ' ', $
TYPE=HEADING, LINE=1, MACRO=HLINKCOND1, FOCEXEC=CHILD_REPORT, $

-IF &HLINK2 EQ '' GOTO SKIP_DRILL;

DEFMACRO=HLINKCOND1, MACTYPE=RULE, $
TYPE=HEADING, LINE=1, MACRO=HLINKCOND1, FOCEXEC=CHILD_REPORT, $

-SKIP_DRILL

Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe

Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006

Ignored post by Tom Flynn posted

Show Post

Fernando

Guru

posted

Hide Post

JZMSH,

Tom's solution will work.

quote:

-IF &HLINK2 EQ '' GOTO SKIP_DRILL;
DEFMACRO=HLINKCOND1, MACTYPE=RULE, $
TYPE=HEADING, LINE=1, MACRO=HLINKCOND1, FOCEXEC=CHILD_REPORT, $
-SKIP_DRILL

If you do not like the skip then change the when to use a field against a value (it must be a field against a value or another field, not a value against a value)