Any idea how to print vertical lines between columns and horizontal lines between rows? the output format is pdf and excel. is it possible in version 5.3.3? thanks

Dharma,

This was covered in a previous question with almost the same topic! Try using the search on occasion to see if your question has alread been answered.

In the topic "Vertical Lines between 2 columns" there were three different options suggested, with perhaps the most suitable solution being supplied by Susannah and involving stylesheets.

yeah, I have seen the topic "Vertical Lines between 2 columns" and solutions in it. Most of them are solutions for html output format and not for pdf or excel. Also my problem is quite complex and those solutions wont work for me. Iam using 'OVER' in my report to print columns one below the other. Now after printing for about 5 columns, they must continue from top again and these two are separated by two vertical lines. For eg:

col1 val1 | | col6 val6
col2 val2 | | col7 val7
col3 val3 | | col8 val8
col4 val4 | | col9 val9
col5 val5 | | col10 val10

i have typed '|' symbol to just indicate that its a vertical line.
can any one please help me out?
thanks

Dharma, if you edit your topic, the original post, to include the words "PDF" and "EXCEL" in the topic line, then experts in that area can come along and know they might be able to help.

Dharma,
Now that we know your report is not just a simple column report. Can you create an example of the report using the CAR table so we can see what you are trying to do.

Also do my knowledge you cannot use WebFOCUS's border function in EXCEL. So there maybe no solution for EXCEL.

Try this for PDF:

TYPE=DATA, COLUMN=col6 (*), BORDER-LEFT=0.01, BORDER-LEFT-COLOR=RGB(200 200 200), $
TYPE=TITLE, COLUMN=col6(*), BORDER-LEFT=0.01, BORDER-LEFT-COLOR=RGB(200 200 200), $
TYPE=DATA, COLUMN=col7 (*), BORDER-LEFT=0.01, BORDER-LEFT-COLOR=RGB(200 200 200), $
TYPE=TITLE, COLUMN=col7(*), BORDER-LEFT=0.01, BORDER-LEFT-COLOR=RGB(200 200 200), $
TYPE=DATA, COLUMN=col8 (*), BORDER-LEFT=0.01, BORDER-LEFT-COLOR=RGB(200 200 200), $
TYPE=TITLE, COLUMN=col8(*), BORDER-LEFT=0.01, BORDER-LEFT-COLOR=RGB(200 200 200), $
...

This will work for HTML only if you also code
ON TABLE SET HTMLCSS ON

Borders do not appear to work for Excel 2000

Hi, the vertical lines issue has been resolved. i have used images to display vertical lines.
thanks

Dharma, how did you get images to work in Excel? how did you pin them to a cell?
in my exp, they're not pinnned by default; your technique would be very useful to us all.
TIA