Hi
Having issue with Headers.. its not adding a space where I need and adding spaces where I don't need. Sounds simple, but driving me crazy..

Can someone tell me what I am missing? THANKS


** OUTPUT looks like below **
MAYSVILLE,KY
Financial Impact Evaluation - July 2013

** Code **
-* year from Launch Page
-DEFAULT &FISC_YEAR = '2013';
..
DEFINE ...
-*City, State
LNAME/A35=LOC_NAME||', '||LOCATION_STATE;
-* Mon
EMO/Mtr=&PROC_MONTH;
END

TABLE FILE ..
SUM
MTD_AMT1 NOPRINT
BY LINE_DESCRIPT NOPRINT
ON LINE_DESCRIPT SUBHEAD
"Financial Analysi.." (WORKS)
"Income" (WORKS)
" Net Income Resources.." (WORKS)
ON TABLE SUBHEAD
"" (NO SPACE AFTER COMMA,see above)
"Financial Impact Evaluation - <+0><+0>&FISC_YEAR" (ADDS SPACES AFTER - AND MON" - July 2013
FOOTING
""
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.500000,
RIGHTMARGIN=0.500000,
TOPMARGIN=0.500000,
BOTTOMMARGIN=0.500000,
SQUEEZE=ON,
GRID=ON,
ORIENTATION=LANDSCAPE,$

TYPE=REPORT,
FONT='ARIAL',
SIZE=9,
$
-* HEADING
TYPE=TABHEADING,
HEADALIGN=BODY,
$
TYPE=TABHEADING,
LINE=1,
SIZE=8,
COLOR='RED',
STYLE=BOLD,
POSITION=4,
$
-*"Financial Impact Evaluation <+0><+0>&FISC_YEAR"
TYPE=TABHEADING,
LINE=2,
ITEM=1,
POSITION=3.5,
SIZE=8,
STYLE=BOLD,
COLSPAN=1,
$
TYPE=TABHEADING,
LINE=2,
ITEM=2,
SIZE=8,
STYLE=BOLD,
COLSPAN=1,
$
TYPE=TABHEADING,
LINE=2,
ITEM=3,
SIZE=8,
STYLE=BOLD,
COLSPAN=1,
$

This message has been edited. Last edited by: <Kathryn Henning>,

quote:

LNAME/A35=LOC_NAME||', '||LOCATION_STATE;

The double pipe || removes spaces at the end of the left concatenated field, use :

LNAME/A35=LOC_NAME || ', ' | LOCATION_STATE;  

Thanks MartinY.. I had already tried that with the following results.. HTML adds spaces

LNAME/A35=LOC_NAME || ', ' | LOCATION_STATE;
MAYSVILLE, KY

LNAME/A35=LOC_NAME | ', ' || LOCATION_STATE;
MAYSVILLE ,KY

In the HTML Report 1st Example Spaces are lot more than whats shows here... 10 spaces AFTER the comma

the same in the sample two 10 spaces BEFORE the comma

I selected from the heading and pasted in notepad to remove the extra lines that are not relevant here , then cut and pasted here.. its normal but in html report it has 10 spaces

quote:

LNAME/A35=LOC_NAME || ', ' | LOCATION_STATE;
MAYSVILLE, KY

HTML doesn't add space, you have a space after the coma which is the left side field of the concatenation using the single pipe.

quote:

LNAME/A35=LOC_NAME | ', ' || LOCATION_STATE;
MAYSVILLE ,KY

HTML doesn't add space, LOC_NAME definition is longer than the field value, maybe something like A10 where MAYSVILLE is 9 long, so you have a space which is the left side field of the concatenation using the single pipe.

Single pipe ( | ) concatenate WITHOUT removing trailing space on the left side field of the concatenation.

Double pipe ( || ) concatenate WITH removing trailing space on the left side field of the concatenation.

Please provide sample a is and input field definition (MFD).

Please! Always put your code between code tags, like this:

[CODE]

LNAME/A35=LOC_NAME || ', ' | LOCATION_STATE;

[/CODE]

(That's what </> is for)

Try:

LNAME/A35 = LOC_NAME || (', ' | LOCATION_STATE);

The brackets are important.

Thanks Martin and Francis
brackets solved the issue of the 1st Line.. Thanks

2nd line of the heading its Adding space BEFORE July and also before 2013

Thanks

here is the code

ON TABLE SUBHEAD
"<LNAME>"
"Financial Impact Evaluation - <+0><EMO><FY>"
FOOTING
""
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
           UNITS=IN,
           PAGESIZE='Letter',
           LEFTMARGIN=0.500000,
           RIGHTMARGIN=0.500000,
           TOPMARGIN=0.500000,
           BOTTOMMARGIN=0.500000,
           SQUEEZE=ON,
           GRID=OFF,
           ORIENTATION=LANDSCAPE,
		   $

TYPE=REPORT,FONT='ARIAL',SIZE=9,$
-* HEADING
TYPE=TABHEADING,HEADALIGN=BODY,$
TYPE=TABHEADING,LINE=1,SIZE=8,COLOR='RED',STYLE=BOLD,POSITION=3.5,$
-*"Financial Impact Evaluation <+0><EMO><+0>&FISC_YEAR"
TYPE=TABHEADING,LINE=2,ITEM=1,POSITION=3,SIZE=8,STYLE=BOLD,SQUEEZE=ON,$
TYPE=TABHEADING,LINE=2,ITEM=2,SIZE=8,STYLE=BOLD,COLSPAN=1,SQUEEZE=ON,$
TYPE=TABHEADING,LINE=2,ITEM=3,SIZE=8,STYLE=BOLD,COLSPAN=1,SQUEEZE=ON,$
TYPE=TABHEADING,LINE=2,ITEM=4,SIZE=8,STYLE=BOLD,COLSPAN=1,SQUEEZE=ON,$
-*

 

TYPE=TABHEADING,HEADALIGN=BODY,$

You're aligning each element of the heading to a report column - that's why there appears to be space between each element