I have a request like this.
TABLE FILE CAR
SUM DEALER_COST
BY SEATS
ACROSS COUNTRY ACROSS MODEL
ON TABLE PCHOLD FORMAT EXL2K
END
I want the borders on dealer cost data when the country changes.
For example, I want to have a right border between England and Japan. I tried many ways with the style sheet attributes but no use. Border does not display at all.
Please advice.
Thank you.

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

Your style sheet is going to impact html and pdf, but not so much excel. that's not going to get much bang for the buck with html styling.

I've been working with CSV and Excel files for a little while now and I have been trying to get borders to work as well.

I have even tried the Alignment Grid and still nothing. I would be interested in knowing some answers to this as well.

susannah is right though. Styling will only work in HTML and PDF as they work great for my reports in those formats.

search thru Waz's posts, he uses microsoft office tags, writes fexes with defined text fields containing microsoft formatting... sheer genius.

Try this on for size...

SET PAGE = OFF
TABLE FILE CAR
SUM DEALER_COST
BY SEATS
ACROSS COUNTRY ACROSS MODEL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
GRID=OFF, BORDER=LIGHT, BORDER-COLOR=GREEN, BORDER-STYLE=DASHED, FONT=COURIER, SIZE=9, COLOR=BLUE, SQUEEZE=ON, ORIENTATION=LANDSCAPE,$
TYPE=HEADING, HEADALIGN=BODY, COLSPAN=8, STYLE=BOLD,$
TYPE=TITLE, STYLE=BOLD,$
ENDSTYLE
END

... and let me know your thoughts... (freebie)

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

Doug,

Beautiful! Very artistic!

Thanks Danny...

Hi ReddyP,

As per our IB Technical Staff they provided the following:

You can get the count of rows for each country and then use the count as the column number in the style section to have border-right.

This is not all the code needed but its a start

TABLE FILE CAR
COUNT *
BY COUNTRY
ON TABLE HOLD AS COLNUM
END

-READ the colnum and use the values to parameterize the styling

-EXIT

Will give you the following:
PAGE 1

COUNTRY COUNT *
COUNT
ENGLAND 4
FRANCE 1
ITALY 4
JAPAN 2
W GERMANY 7

Then you would have to read each row and create &erVariables to create the inline style section.

-*The following will create the report that they want BUT .. look at the style section
TABLE FILE CAR
SUM

CAR.BODY.DEALER_COST
BY CAR.BODY.SEATS
ACROSS CAR.ORIGIN.COUNTRY
ACROSS CAR.CARREC.MODEL
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
$


$ The code below would have to be parameterized for the column number using the count above.

TYPE=DATA, COLUMN=N5, BORDER-RIGHT=MEDIUM,$
TYPE=TITLE, COLUMN=N5, BORDER-RIGHT=MEDIUM,$
TYPE=DATA, COLUMN=N6, BORDER-RIGHT=MEDIUM,$
TYPE=TITLE, COLUMN=N6, BORDER-RIGHT=MEDIUM,$
TYPE=DATA, COLUMN=N10, BORDER-RIGHT=MEDIUM,$
TYPE=TITLE, COLUMN=N10, BORDER-RIGHT=MEDIUM,$
TYPE=DATA, COLUMN=N12, BORDER-RIGHT=MEDIUM,$
TYPE=TITLE, COLUMN=N12, BORDER-RIGHT=MEDIUM,$
TYPE=DATA, COLUMN=N19, BORDER-RIGHT=MEDIUM,$
TYPE=TITLE, COLUMN=N19, BORDER-RIGHT=MEDIUM,$
ENDSTYLE
END

*********************************

Let us know if this and the suggestions above helped to resolve your issue.


Sincerely,

Kathleen Butler
Information Builders

Thanks Doug. Your solution works beautifully.