Hi,

I have developed a summary report to display the data in Excel format. The report has only HEADING, SUBHEAD and SUBFOOT(no detail records). Each of Heading, SUBHEAD & SUBFOOT has 4-5 lines printing the text with ST. values, when the format of the ST. value is changed from decimal to regular numeric("SubTotal Value :
Thanks

This message has been edited. Last edited by: Kerry,

WebFOCUS 7.1.4
Windows
Both Excel & HTML

quote:

SubTotal Value : < ST.VALUE/I9

You can not do it like this.
Reformatting is only supported with PRINT or SUM, not within a subfoot/head or any other part of the report.

If you want to reformat a value in a SUBFOOT, you can use RECAP before the SUBFOOT.

  
ON sortfield RECAP
RVALUE/I9=VALUE;
ON sortfield SUBFOOT
"SubTotal value:<RVALUE "

Hi,

With RECAP i am getting the below error,

(FOC268) THE FIELD NAME IS NOT REFERENCED IN
THE REQUEST STATEMENT

The below is my sample code,

TABLE FILE CAR
BY NAME NOPRINT
BY COL2 NOPRINT
ON NAME SUBHEAD
"ON COL2 RECAP RTOT_CREATED/I9 = TOT_CREATED;
ON COL2 SUBHEAD
"ON NAME SUBFOOT
"ON TABLE FOOTING
"ON TABLE SET ONLINE-FMT EXL2K
END

Wondering RECAP works with 714 for EXCEL reports.

Please share ideas.

Thanks

WebFOCUS 7.1.4
Windows
Both Excel & HTML

Your sample code does not match the error message. There is no RECAP in it.

Sorry, some how the sample code got messed up.

Here is the code(Note: This is a sample code and i did not compile it),

TABLE FILE CAR
BY NAME NOPRINT
BY COL2 NOPRINT
ON NAME SUBHEAD 
" <NAME "
ON COL2 RECAP RTOT/I9= CRTD_TOT;
ON COL2 SUBHEAD 
" <COL2 Total: <RTOT "
ON NAME RECAP ST_RTOT/I9= ST.CRTD_TOT;
ON NAME SUBFOOT 
" <NAME Total: <ST_RTOT "
ON TABLE RECAP TOT_RTOT/I9= TOT.CRTD_TOT;
ON TABLE FOOTING 
" All Total: <TOT_RTOT "
ON TABLE SET ONLINE-FMT EXL2K
END

Thanks

The error message seems quite clear to me - it tells you that you have to use the field in the recap with a sum or print command. And since you do not have that, you get the error.

Hope this helps ...

Gerard is correct: you need to use the field in the fex. So maybe something like this:

TABLE FILE CAR
SUM CRTD_TOT NOPRINT
BY NAME NOPRINT
BY COL2 NOPRINT
ON NAME SUBHEAD 
" <NAME "
ON COL2 RECAP RTOT/I9= CRTD_TOT;
ON COL2 SUBHEAD 
" <COL2 Total: <RTOT "
ON NAME RECAP ST_RTOT/I9= CRTD_TOT;
ON NAME SUBFOOT 
" <NAME Total: <ST_RTOT "
ON TABLE RECAP TOT_RTOT/I9= CRTD_TOT;
ON TABLE SUBFOOT 
" All Total: <TOT_RTOT "
ON TABLE SET ONLINE-FMT EXL2K
END

I tried this, got the error displayed as below.

Unknown error occurred.
Agent on reporting server ABC01 may have crashed.
Please investigate reporting server log.

ERROR:

Is it necessary to print the column which is used in the RECAP.

Thanks

This works. Try it:

  
-* File Vad1.fex
TABLE FILE CAR
SUM RCOST NOPRINT
BY COUNTRY NOPRINT
BY BODYTYPE NOPRINT
ON COUNTRY SUBHEAD 
" <COUNTRY "
ON BODYTYPE RECAP RTOT/I9= RCOST;
ON BODYTYPE SUBFOOT 
" <BODYTYPE Total: <RTOT "
ON COUNTRY RECAP ST_RTOT/I9= RCOST;
ON COUNTRY SUBFOOT 
" <COUNTRY Total: <ST_RTOT "
ON TABLE RECAP TOT_RTOT/I9= RCOST;
ON TABLE SUBFOOT 
" All Total: <TOT_RTOT "
END

In your request you mention a field called CRTD_TOT. What is the definition of that field?
Danny's example works fine without any problem, and the only difference with your request is this field. So that's why I'm asking how this field is calculated.

Gam/Danny,

It worked, Thanks a lot for your assistance. I will look into my sample code to find the issue.

Appreciate your help.

Kind Regards,
Vadivel Nagaraj