If I change the output format to EXL2K the entire line shifts to the left

Tom,

How is your PHYSICIAN field being compiled, a concatenation of other fields? If so then your concatenation is at fault and not your style sheet.

A single pipe '|' character is a soft concatentation and will concatenate fields without compressing white space to nothing, whereas a double pipe '||' is a hard concatenation that will compress white space to nothing.

If your PHYSICIAN field is made up of PHYSICIAN_LAST/A12 and PHYSICIAN_FIRST/A12 then you could concatenate them as you wish by -

PHYSICIAN/A26 = PHYSICIAN_LAST || (', ' | PHYSICIAN_FIRST);

However, if that is not how your field is compiled then please provide more info.

T

Tom

if you put your code example or output examples between

 [CODE]  

[/CODE] it would be better readable.

SQUEEZE=ON
go have a read of the 2 excellent articles by Mickey Grackin on PDF
part 1
and
part 2

Tom,

  
-* File tomsweb4.fex
TABLE FILE CAR
PRINT
     SALES
     COMPUTE HEADER/A100 = IF TABPAGENO EQ 1 THEN 'First: '|COUNTRY || ( ', '|CAR ) || ( ', '|MODEL ) ELSE ' '; NOPRINT
BY COUNTRY
BY CAR
BY MODEL
ON COUNTRY PAGE-BREAK
HEADING
"Page <TABPAGENO "
" "
"<HEADER "
" "
ON TABLE SET PAGE-NUM ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
$
ENDSTYLE
END

Notice:
SQUEEZE=ON
Strong concatenation
When you invoke TABPAGENO WF will not display page numbers, so, if you want them you have to code it in the HEADING.
Be sure to have the HEADING placed after the COMPUTE statement.

danny, i have no problems with the tabpageno in the footer, with squeeze on.
what i do have is a problem with the total page count
My point, to danny below, is that the

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

Susannah,

Of course you can place TABPAGENO in the FOOTING.
As for the total number of pages, I added this to my example and it worked fine:

  
FOOTING BOTTOM
"Page <TABPAGENO of <TABLASTPAGE "

Danny,
I have added your suggestion to my fex and I still see that there is no space between Provider: and Drname.

Code captioned in []:
[COMPUTE HEADER3/A200 = IF TABPAGENO EQ 1 THEN 'Provider: ' |(' ') || PHYSICIAN ELSE ' '; NOPRINT]

It displays like this:
Provider:Cooper,[about 6 spaces]Joseph
Provider:Smith,[about 6 spaces]Greg
Provider:Hasselkus,[about 6 spaces]Herman

I would like to see it display like this:
Provider:[1 or 2 spaces] Hasselkus,[1 space]Herman

Thanks

I also coded this:
[
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.152778,
RIGHTMARGIN=0.152778,
TOPMARGIN=0.138889,
BOTTOMMARGIN=0.138889,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.125000,
$
]

Tom,

If you see 6 spaces between physician's last name and first name it shows that that is how it is stored in the field PHYSICIAN... So I would take a look at that first. Maybe you should use the function SQUEEZ.

So, your code could be:

IF TABPAGENO EQ 1 THEN 'Provider: ' | SQUEEZ(n, PHYSICIAN, 'An') ELSE ' ';

Where n is the length of PHYSICIAN.

To check the spaces, do a dry run with font Courier New.

Danny,

I tried the IF TABPAGENO EQ 1 THEN 'Provider: ' | SQUEEZ(n, PHYSICIAN, 'An') ELSE ' '; code and
I have gotten the header display that I want. However, I am using the stylesheet settings below, I am getting a second page (i.e. page 1.2) with this display:

HEADER3

Provider: Cooper, Joseph
Provider: Cooper, Joseph

So, as I have coded, 'ON PHYSICIAN PAGE-BREAK REPAGE', this happens for every doctor in the report. Ergo, my report has grown from 13 pages to 26 pages.

Could this be an issue with my stylesheet?

[
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.152778,
RIGHTMARGIN=0.152778,
TOPMARGIN=0.138889,
BOTTOMMARGIN=0.138889,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.125000,
$
]
???

Tom,

When you get pages numbers such as 1.2 that means your information does not fit on one page wide and therefore WebFOCUS created a second page to the RIGHT to place the rest of the information on and numbered it 1.2. It will do this for every page therefore doubling your pages.

You may want to look at adjusting your report so it fits on one page width. This might be as easy as shrinking the font, reducing the margins or changing the ORIENTATION to LANDSCAPE.

I solved this problem by realizing that I forgot to end the line with NOPRINT!

COMPUTE HEADER3/A40 = IF TABPAGENO EQ 1 THEN 'Provider: ' | SQUEEZ(30, PHYSICIAN, 'A30') ELSE ' '; NOPRINT

Sometimes the eyes just glaze over

Good to hear it worked out to be that simple.