Focal Point
Name of Fex in a Report Heading ???

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

November 13, 2006, 06:36 PM
Tomsweb
Name of Fex in a Report Heading ???
I am trtying to remember an old technique I used in MF FOCUS where I could say something like this in a report heading:

heading center
"Date: &DATEtrMDYY Report Name &fexwhatever"
-------------------------------
and the &fexwhatever var contained the name of the actual focexec I was running to create this report.

So if fex was named "May_Payroll" the report would say...
Date: May 31, 2006 Report: May_Payroll

Right now I just coded it in an Amper variable
and placed in the heading code

Does WF 5.3.3 use a system variable for this feature?

Thanks! Razzer


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
November 13, 2006, 06:57 PM
Mikel
You can use &FOCFOCEXEC or &FOCINCLUDE.

Ref:
Using the system variable &FOCFOCEXEC

Regards,
Mikel


WebFOCUS 8.1.05, 8.2.01
November 13, 2006, 07:54 PM
Tomsweb
Thanks Mikel


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
November 14, 2006, 12:17 PM
Francis Mariani
This may not work in MRE.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
November 14, 2006, 12:19 PM
Tomsweb
Thanks Mikel, for your help.

As I tested this, I realized that &FOCFOCEXEC placed an underscore "_" in front of the variable name.
So I have written this little snippet to delete the unsightly "_" from the front of the fex name as it
displays in the report header or footer. Note use of the UPCASE function to convert this case-sensitive
file names on a UNIX server.

-SET &A = ABS(&FOCFOCEXEC.LENGTH);
-SET &C = (&A - 1);
-SET &RPTNM = STRIP(&A, &FOCFOCEXEC , '_' , '&C');
-SET &RPTNM = UPCASE(&RPTNM.LENGTH , &RPTNM , &RPTNM.LENGTH );

Cool addios amigos!


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
November 14, 2006, 12:48 PM
Tomsweb
In MRE, I believe it would be like this

table file car
"&mrefex"
print car
end

Idea


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
November 14, 2006, 12:57 PM
mgrackin
Tomsweb,

Try using &FOCFEXNAME instead of &FOCFOCEXEC.

&FOCFEXNAME does not have the underscore at the beginning.


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
November 14, 2006, 01:03 PM
mgrackin
To see the values for all & variables, issue a

-? &

command. you will see &FOCFOCEXEC, & FOCFEXNAME, &FOCINCLUDE, etc.


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
November 14, 2006, 01:16 PM
Francis Mariani
&FOCFEXNAME must be a new v7 variable.

On my v5.3.2 server, &FOCFOCEXEC is without an "_". It may be how the program is being executed.

Does anyone know why there's an "_" in the first place? Now that we've all figured out how to strip the leading underscore, a new system variable is created, without the underscore. Go figure!


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
November 14, 2006, 02:01 PM
Mikel
Yes, &FOCFEXNAME works fine for me on WF7. Curiously, I don't find documentation about this ¿new? system variable.

Other way to retrieve focexec name is set sendvar variable to &IBIF_focexec in ibicommd.wfs file.

ibicommd.wfs:

FEXNAME=&IBIF_focexec


focexec:
-TYPE &FEXNAME

Regards,
Mikel


WebFOCUS 8.1.05, 8.2.01
November 14, 2006, 02:22 PM
Tomsweb
I bet the '_' appended to the fexname comes from the way it is called in a config file on the server...

Could it be?
Winky


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36