displaying field in footer

March 06, 2007, 06:15 AM

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.

March 06, 2007, 06:37 AM

Alan B

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.

March 06, 2007, 06:46 AM

Aditya

Hi Alan,

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

Thanks and regards,
Aditya

March 06, 2007, 07:05 AM

Alan B

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.

March 06, 2007, 07:32 AM

Aditya

Hi Alan,

procedure1 here is the database procedure i am refering to.

Regards,
Aditya

March 06, 2007, 07:36 AM

Alan B

In which case I am not understanding what you are after.

March 06, 2007, 07:39 AM

Aditya

No problem.thanks for your help.

Regards,
Aditya

March 06, 2007, 07:43 AM

Danny-SRL

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?

March 06, 2007, 09:14 AM

Leah

quote:
quote:

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

As Daniel indicated, should work.