Focal Point
[CLOSED] Autodrill and include

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

March 20, 2019, 06:26 PM
Siva1925
[CLOSED] Autodrill and include
Hi,
I have two procedures(procedure1 and procedure2) with auto-drill enabled.I am including these procedures in another procedure(procedure3).
Now when i execute procedure3 the code works fine but i am not getting the auto-drill.

Code Structure:

-SET &USER = &FOCSECUSER

IF &USER EQ 'USER1' THEN GOTO LABEL1 ELSE GOTO LABLEL2

:-LABEL1
-INCLUDE procedure1
-EXIT

:-LABEL2
-INCLUDE procedure2
-EXIT

Any ideas?

WF8205
windows 10

This message has been edited. Last edited by: FP Mod Chuck,
March 21, 2019, 04:22 AM
Frans
The labels are not right:

   
-IF &FOCSECUSER.QUOTEDSTRING NE 'USER1' THEN GOTO  :LABLEL2;

-:LABEL1
-INCLUDE procedure1
-EXIT

-:LABEL2
-INCLUDE procedure2
-EXIT



Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
March 21, 2019, 10:18 AM
Siva1925
Thank you for correcting.
But it runs the report without auto-drill.
Any idea on how i can bring the auto-drill.

Thank you
Sivakumar Gopi
March 22, 2019, 02:46 AM
Rajesh Singh Negi
I have tried it many times , but the fact is when you make any changes in the fex the procedure looses its autodrill property.


Webfocus 8.x
Windows
PDF,HTML,XLSX
March 25, 2019, 01:42 PM
FP Mod Chuck
This sounds like a bug that should be reported. You shouldn't have to go back and re-edit the fex to make sure autodrill is turned on.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
March 26, 2019, 01:46 PM
Siva1925
Thanks Rajesh and Chuck.
I guess i will have to do normal drill downs now.