Hi,

On running the below code, you get borders around all data values.

But, when you make 'AS name' as Blank for the fields, the borders around the data values are incomplete.

Code that works fine,
TABLE FILE CAR
PRINT
CAR MODEL OVER
BODYTYPE SEATS
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=DATA,BORDER=LIGHT,$
ENDSTYLE
END

Code having border issue,
TABLE FILE CAR
PRINT
CAR AS '' MODEL AS '' OVER
BODYTYPE AS '' SEATS AS ''
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=DATA,BORDER=LIGHT,$
ENDSTYLE
END


Thanks,
Hari
WF-769

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

Borders in PDF can always be a challenge!

Does this do what you need?

TABLE FILE CAR
PRINT CAR AS ' '
      MODEL AS '' OVER
      BODYTYPE AS ' '
      SEATS AS ''
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $
TYPE=DATA, BORDER=LIGHT, $
ENDSTYLE
END

T

No Tony, i need the borders between the values.
Is there any way to get it?

-Hari
WH-769

Hi Hari,

Has this issue been resolved on your side?

I passed this one to our internals and was told that Tony's code should work fine to give what you need, just be careful that there should be spaces between AS ' ' (inside the single quote).

TABLE FILE CAR
PRINT CAR AS ' '
      MODEL AS '' OVER
      BODYTYPE AS ' '
      SEATS AS ''
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $
TYPE=DATA, BORDER=LIGHT, $
ENDSTYLE
END

Cheers,

Kerry

Try something like this..

Its a bit crude, but this code forcing each column to have a border.
The COMPUTE NULL fields should resolve the first column appearing with a blank left border, and by making the top, bottom, and left borders white, it won't appear on your report.

 
TABLE FILE CAR
PRINT
COMPUTE NULL/A1=''; AS '' CAR AS '' MODEL AS '' OVER
COMPUTE NULL2/A1=''; AS '' BODYTYPE AS '' SEATS AS ''
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$

TYPE=DATA,
COLUMN=N1,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=SOLID,
     BORDER-BOTTOM-STYLE=SOLID,
     BORDER-LEFT-STYLE=SOLID,
     BORDER-RIGHT-STYLE=SOLID,
     BORDER-TOP-COLOR='WHITE',
     BORDER-BOTTOM-COLOR='WHITE',
     BORDER-LEFT-COLOR='WHITE',
     BORDER-RIGHT-COLOR='BLACK',
$
TYPE=DATA,
COLUMN=N2,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=SOLID,
     BORDER-BOTTOM-STYLE=SOLID,
     BORDER-LEFT-STYLE=SOLID,
     BORDER-RIGHT-STYLE=SOLID,
     BORDER-TOP-COLOR='BLACK',
     BORDER-BOTTOM-COLOR='BLACK',
     BORDER-LEFT-COLOR='BLACK',
     BORDER-RIGHT-COLOR='BLACK',
$
TYPE=DATA,
COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=SOLID,
     BORDER-BOTTOM-STYLE=SOLID,
     BORDER-LEFT-STYLE=SOLID,
     BORDER-RIGHT-STYLE=SOLID,
     BORDER-TOP-COLOR='BLACK',
     BORDER-BOTTOM-COLOR='BLACK',
     BORDER-LEFT-COLOR='BLACK',
     BORDER-RIGHT-COLOR='BLACK',
$
TYPE=DATA,
COLUMN=N4,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=SOLID,
     BORDER-BOTTOM-STYLE=SOLID,
     BORDER-LEFT-STYLE=SOLID,
     BORDER-RIGHT-STYLE=SOLID,
     BORDER-TOP-COLOR='WHITE',
     BORDER-BOTTOM-COLOR='WHITE',
     BORDER-LEFT-COLOR='WHITE',
     BORDER-RIGHT-COLOR='BLACK',
$
TYPE=DATA,
COLUMN=N5,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=SOLID,
     BORDER-BOTTOM-STYLE=SOLID,
     BORDER-LEFT-STYLE=SOLID,
     BORDER-RIGHT-STYLE=SOLID,
     BORDER-TOP-COLOR='BLACK',
     BORDER-BOTTOM-COLOR='BLACK',
     BORDER-LEFT-COLOR='BLACK',
     BORDER-RIGHT-COLOR='BLACK',
$
TYPE=DATA,
COLUMN=N6,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=SOLID,
     BORDER-BOTTOM-STYLE=SOLID,
     BORDER-LEFT-STYLE=SOLID,
     BORDER-RIGHT-STYLE=SOLID,
     BORDER-TOP-COLOR='BLACK',
     BORDER-BOTTOM-COLOR='BLACK',
     BORDER-LEFT-COLOR='BLACK',
     BORDER-RIGHT-COLOR='BLACK',
$
ENDSTYLE
END

Erfan
WF 7.6.5 / BID / Info Assist / Report Caster

Hey Kerry,

The borders are seen , but they appear as seperate blocks. I want them to look like a single report.

Erfan, same with your code too.
Is there anyway or remove the TITLES space or get the data values together?


Thankyou both for your responses.

-Hari
WF-769

Hari, maybe this is what you wanted? I try using grid instead of border

TABLE FILE CAR
PRINT
CAR/A15 AS '' MODEL AS '' OVER
BODYTYPE/A15 AS '' SEATS AS ''
ON TABLE PCHOLD FORMAT PDF
-*ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
-*SQUEEZE=ON,
GRID=ON,
ORIENTATION=PORTRAIT,
$
-*TYPE=DATA,BORDER=LIGHT,$
ENDSTYLE
END
  

Hua

Hey Hua,

Works perfectly. Never used GRID with PDF.
Looking for this solution for long time.

Thanks a lot.

-Hari