Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     displaying field in footer

Read-Only Read-Only Topic
Go
Search
Notify
Tools
displaying field in footer
 Login/Join
 
Aditya
Gold member
posted
Hi,

I need to display a variable value(RNO) in the footer of my report.The following is my code(I need to display RNO in the footing next to the 'Date: &DATEMDYYYY' value) - 

-SET &RNO = IF (&RNO EQ '') THEN NULL ELSE &RNO;

EX procedure1 &RNO;

TABLE FILE SQLOUT
PRINT
AAA
BBB
CCC
DDD
BY XXX NOPRINT BY YYY NOPRINT PAGE-BREAK SUBHEAD
""
"COMMENT"
"COMMENT"
""
ON GGG SUBFOOT
""
"**************"
"**************"

HEADING
"____________________________________<0X
_________________________"

FOOTING BOTTOM
"____________________________________<0X
_________________________"
"  Date:  &DATEMDYYYY <+0>xxxxxxx <0X
xxxxxxxxxxx<+0> Page: <TABPAGENO of <TABLASTPAGE"

ON TABLE HOLD AS REPORT FORMAT HTMTABLE
END
-RUN

-IF &LINES GT 0 THEN :SReport;
-INCLUDE wferr.fex
-EXIT
-:SReport
-HTMLFORM BEGIN
<html>
<body>
<br>
 <div align="center">
  !IBI.FIL.REPORT;
 </div>
</body>
</HTML>
-HTMLFORM END


Kindly help me.
 
Posts: 84 | Registered: June 05, 2006Report This Post
Alan B
Virtuoso
posted Hide Post
When you call a procedure with EX procname value, the procname has no knowledge of &variable names within the calling procedure, only that a value has been passed.

You can use &&variables, these will be passed through, or refer to the values in the order that they are referenced on the call line as &1, &2 etc.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
Aditya
Gold member
posted Hide Post
Hi Alan,

I didn't get you.Could you please elaborate.

Thanks and regards,
Aditya
 
Posts: 84 | Registered: June 05, 2006Report This Post
Alan B
Virtuoso
posted Hide Post
Sorry,

When you use

EX procedure1 &RNO;

procedure1 receives only the value of &RNO, not it's name. So to refer to the value of &RNO use &1, not &RNO, as it is the first value on the EX line.

You could use

EX procedure1 RNO=&RNO;

and then refer to &RNO in procedure1 because you are passing a name over with the value, or use

-SET &&RNO=&RNO;

and use &&RNO in procedure1.

Hope that is clearer.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
Aditya
Gold member
posted Hide Post
Hi Alan,

procedure1 here is the database procedure i am refering to.

Regards,
Aditya
 
Posts: 84 | Registered: June 05, 2006Report This Post
Alan B
Virtuoso
posted Hide Post
In which case I am not understanding what you are after.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
Aditya
Gold member
posted Hide Post
No problem.thanks for your help.

Regards,
Aditya
 
Posts: 84 | Registered: June 05, 2006Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Hi Aditya,
I see you are running an SQL stored procedure from within a FOCEXEC.
Your parameter &RNO is local to your FOCEXEC so you should be able to write your FOOTING:
quote:

FOOTING BOTTOM
"____________________________________<0X
_________________________"
" Date: &DATEMDYYYY &RNO <+0>xxxxxxx <0X
xxxxxxxxxxx<+0> Page:


Did this help?


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Leah
Virtuoso
posted Hide Post
quote:
quote:

FOOTING BOTTOM
"____________________________________<0X
_________________________"
" Date: &DATEMDYYYY &RNO <+0>xxxxxxx <0X
xxxxxxxxxxx<+0> Page:



As Daniel indicated, should work.


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
Aditya
Gold member
posted Hide Post
Hi Danny-SRL and Leah,

It's working.Never though that it would be that simple.

Thanks vm.

Regards,
Aditya
 
Posts: 84 | Registered: June 05, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     displaying field in footer

Copyright © 1996-2020 Information Builders