Controlling Drilldown Hyperlink

Hi guys and gals.

I’m trying to create a drilldown report that calls itself. I have run into a problem; when the report reaches the lowest level you can drill down on, I want to display a different title (I’m drilling down on the title). I’ve tried to use When Statement but it doesn’t seem to be working correctly; or I’m not using correct syntax. Below is a snippet of code that I’ve tried. Can any point in the correct direction here?

Thanks

TYPE=HEADING,
BORDER=LIGHT,
BORDER-STYLE=RIDGE,
BORDER-COLOR=RGB(51 51 153),
SIZE=12,
BACKCOLOR=RGB(198 211 236),
STYLE=BOLD,
TARGET='_blank',
JUSTIFY=CENTER,
FOCEXEC=app/l2c49znz(ParentGeoKey = '&ParentGeoKey' StartDate = '&StartDate' EndDate = '&EndDate' LevelFlag = 'DLVL2'),
WHEN = &LVLCOUNT LE 3,
$
TYPE=HEADING,
WHEN = &LVLCOUNT LT 0,
BORDER=LIGHT,
BORDER-STYLE=RIDGE,
BORDER-COLOR=RGB(51 51 153),
SIZE=12,
BACKCOLOR=RGB(198 211 236),
STYLE=BOLD,
JUSTIFY=CENTER,
WHEN = &LVLCOUNT GT 3,

Dev 7.1.4 WinNT SQL Server 2005 DB
Prod 7.1.4 WinNT SQL Server 2000 DB

Posts: 24 | Location: Nashville TN | Registered: May 18, 2006

Tony A

Expert

posted

Hide Post

Why not try it using dialogue manager to skip those parts that you don't want?

TYPE=HEADING,
BORDER=LIGHT,
BORDER-STYLE=RIDGE,
BORDER-COLOR=RGB(51 51 153),
SIZE=12,
BACKCOLOR=RGB(198 211 236),
STYLE=BOLD,
JUSTIFY=CENTER,
-IF &LVLCOUNT GT 3 THEN :No_Drill;
FOCEXEC=app/l2c49znz(ParentGeoKey = '&ParentGeoKey' StartDate = '&StartDate' EndDate = '&EndDate' LevelFlag = 'DLVL2'),
TARGET='_blank',
-:No_Drill
$

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Show Post

ETLProg

Member

posted

Hide Post

I've tried to use that syntax and I'm getting an error that says there is a unknown command in the stylesheet. I've also played around with the syntax and keep getting the error. Can anybody help me out with the syntax on this?

Thanks guys

Dev 7.1.4 WinNT SQL Server 2005 DB
Prod 7.1.4 WinNT SQL Server 2000 DB

Posts: 24 | Location: Nashville TN | Registered: May 18, 2006

Ignored post by ETLProg posted

Show Post

Tony A

Expert

posted

Hide Post

Here is an example of it working. I've set a variable (&Cnt) to increment by 1 each time the fex is drilled into. I've then set the dialogue manager test to by pass the drilldown when the variable is greater than 3, so you will only ever get 3 reports from where you can drilldown.

-DEFAULT &Cnt = 0
-SET &Cnt = &Cnt + 1;
TABLE FILE CAR
SUM RCOST
    DCOST
BY COUNTRY
BY CAR
BY MODEL
HEADING
"Click here to drilldown"
ON TABLE SET STYLE *
TYPE=HEADING,
BORDER=LIGHT,
BORDER-STYLE=RIDGE,
BORDER-COLOR=RGB(51 51 153),
SIZE=12,
BACKCOLOR=RGB(198 211 236),
STYLE=BOLD,
JUSTIFY=CENTER,
-IF &Cnt GT 3 THEN :No_Drill;
FOCEXEC=newfex-1(Cnt=&Cnt),
TARGET='_blank',
-:No_Drill
$
ENDSTYLE
END
-RUN