Focal Point
Formating values in the "subhead"

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

October 16, 2006, 07:34 PM
MARIELOS
Formating values in the "subhead"
Hello to everybody..!!

I need to know how can I get the values with format, wich ones are displayed in the subhead on my report.

Thank you..!!
October 17, 2006, 07:38 AM
S.J. Kadish
Marielos - we'll need some more details, specifically:

1.) Are the values that are passed from a launch screen with &variables?

2.) Are these values that are BY variables to which you have stipulated NOPRINT


Sandy Kadish
Dev: 8.2.04- PostgreSQL
Test: 8.2.04 - PostgreSQL
Prod: 8.2.04 - PostgreSQL
October 17, 2006, 11:46 AM
MARIELOS
Hi S.J.Kadish, the values that I need to get with format are called from a table and I need to print them. Like This Example:

ON CONCODAUXILIA SUBHEAD
"
CONCODAUXILIA = IS THE CODE
CONNOMAUXILIA = IS THE DESCRIPTION
CONVALORREAL = IS THE VALUE THAT I NEED FORMATTED

THE OUTPUT IS:

12563222 THE NAME OF THE COUNT $1,689.00

THIS IS WHAT I NEED...!!
THE FIELD ARE CONSIDERED IN THE SELECT OF MY REPORT

THANK YOU...!!
October 17, 2006, 11:51 AM
Kamesh
If I understand you correctly then the below code may give you the solution.

DEFINE FILE TEMP
CVAL/D12.2CM=CONVALORREAL ;
END

TABLE FILE TEMP
PRINT *
BY CONCODAUXILIA
ON CONCODAUXILIA SUBHEAD
"<CONCODAUXILIA <CONNONDESC <CVAL"
END


Hope this helps,


WFConsultant

WF 8105M on Win7/Tomcat
October 17, 2006, 12:17 PM
MARIELOS
Thank you Kamesh and S.J. Kadish for your help,
it really worked..!!!!!