Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Name of Fex in a Report Heading ???
Go
New
Search
Notify
Tools
Reply
  
Name of Fex in a Report Heading ???
 Login/Join
 
Master
posted
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
 
Posts: 573 | Location: Baltimore, MD | Registered: July 06, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
You can use &FOCFOCEXEC or &FOCINCLUDE.

Ref:
Using the system variable &FOCFOCEXEC

Regards,
Mikel


WebFOCUS 8.1.05, 8.2.01
 
Posts: 173 | Location: Madrid, Spain | Registered: May 09, 2003Reply With QuoteReport This Post
Master
posted Hide Post
Thanks Mikel


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
 
Posts: 573 | Location: Baltimore, MD | Registered: July 06, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Master
posted Hide Post
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
 
Posts: 573 | Location: Baltimore, MD | Registered: July 06, 2006Reply With QuoteReport This Post
Master
posted Hide Post
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
 
Posts: 573 | Location: Baltimore, MD | Registered: July 06, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Tomsweb,

Try using &FOCFEXNAME instead of &FOCFOCEXEC.

&FOCFEXNAME does not have the underscore at the beginning.


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Reply With QuoteReport This Post
Virtuoso
posted Hide Post
To see the values for all & variables, issue a

-? &

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


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Reply With QuoteReport This Post
Expert
posted Hide Post
&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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 173 | Location: Madrid, Spain | Registered: May 09, 2003Reply With QuoteReport This Post
Master
posted Hide Post
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
 
Posts: 573 | Location: Baltimore, MD | Registered: July 06, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Name of Fex in a Report Heading ???

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.