Hi, could anyone show me how to add spaces between the columns in the across statement?

below is the code,

=============================
TABLE FILE CAR
SUM
FIGURE
ACROSS NAME COLUMNS 'TOYOTA' AND 'HONDA' AND 'LEXUS' AND 'BMW'
FOR
etc......
=============================

What i would like to do is to ad spaces between "TOYOTA', 'HONDA', 'LEXUS' and 'BMW'. Can anyone help?

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

There are several ways to increase the spacing in between columns, but they are either global (SET SPACES = 3) that affect spacing between columns, or require identification of a specific column (either with a IN +3 when used as a verb object or in the stylesheet. You could use TYPE=REPORT, ACROSSCOLUMN=P1, and then play with the LEFTGAP or RIGHTGAP settings and possibly combine with conditional styling.

Another way is to use relative column addressing like the following example:

TABLE FILE CAR
PRINT MODEL
BY CAR
ACROSS COUNTRY COLUMNS 'ENGLAND' AND 'FRANCE' AND 'JAPAN'
ON TABLE NOTOTAL
ON TABLE SET ONLINE-FMT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=10,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
TYPE=HEADING,
     LINE=2,
     OBJECT=TEXT,
     ITEM=1,
     FONT='ARIAL',
$
TYPE=DATA, COLUMN=CAR, COLOR=YELLOW,$
TYPE=REPORT, COLUMN=C1, COLOR=RED, POSITION=+.25,$
TYPE=REPORT, COLUMN=C2, COLOR=BLUE, POSITION=+.5,$
TYPE=REPORT, COLUMN=C3, COLOR=BLUE, POSITION=+.75,$
ENDSTYLE
END

The problem with that is that you have to specify each column, but then you've already done that in your ACROSS COLUMNS statement.

Hi Darin,

Thank you very much for your reply and suggestion.

I tried

TYPE=REPORT, COLUMN=C1, COLOR=RED, POSITION=+.25,$
TYPE=REPORT, COLUMN=C2, COLOR=BLUE, POSITION=+.5,$
TYPE=REPORT, COLUMN=C3, COLOR=BLUE, POSITION=+.75,$

but I can only see the font color change but the positions stay the same, no matter what number i put it in.

Then I tried

TYPE=REPORT, ACROSSCOLUMN=P1, COLOR=RED,$
TYPE=REPORT, ACROSSCOLUMN=P2, COLOR=BLUE,$
TYPE=REPORT, ACROSSCOLUMN=P3, COLOR=BLUE,$

this time the color of the fonts stay the same as well as the positions.

Am i missing something?

Simon

Darin was specifically showing PDF format control.
In HTML spaces are automatically compressed and you need to specify a WRAP value in the stylesheet
to force a cell width.

You can also use SET SHOWBLANKS = ON to stop the compression of blanks in HTML

After each field put a plus sign (+) and the number of spaces you want between the columns.

The default spacing between columns is 2 spaces so if you want more thane 2 spaces between columns add a +3 after NAME adds 1 space in addition to the 2 default spaces. If you want less than 2 spaces between columns add a +1 after NAME and then you will only have 1 space between columns.

Hope this helps.

Rick Barnett

TABLE FILE CAR
SUM
FIGURE
ACROSS NAME +3 COLUMNS 'TOYOTA' AND 'HONDA' AND 'LEXUS' AND 'BMW'
FOR
etc......

Sorry - My solution was for PDF as noted by JG. I knew that the column spacing was ignored in HTML, so I just jumped straight to the PDF without stating the assumption.

As for

quote:

After each field put a plus sign (+) and the number of spaces you want between the columns

Don't know if you tested this or not, but it isn't correct syntax and even with correct syntax, it doesn't work. When specifying individual column you can use IN +3 after the field, but this doesn't seem to work the same for spaces between columns contained in an ACROSS statement. If you did test this and it worked, please post your code. Thanks.

quote:

COLUMNS 'TOYOTA' AND 'HONDA' AND 'LEXUS' AND 'BMW'

Try adding the following in the 'Stylesheet'


TYPE=ACROSSVALUE,
SIZE=9,
WRAP=1.0,
JUSTIFY=RIGHT,
$

WIDTH= could also be used. In essence, ACROSSVALUE is affecting the column-titles, but since the column width must match the width of the widest value including the column title, you get exactly what you need.

First of all, thank you so very much for all the responses. They are very much appreciated.

I have tried all the suggestions, but they don't seem to be able to add the spaces between columns. Let me show you what i have tried.

--Attempt 1
ACROSS COUNTRY COLUMNS 'ENGLAND' IN +3 AND 'FRANCE' AND 'JAPAN'
==result== Error message: A WORD IS NOT RECOGNIZED: IN+3

--Attempt 2
ACROSS COUNTRY COLUMNS 'ENGLAND' +3 AND 'FRANCE' AND 'JAPAN'
==result== Error message: A WORD IS NOT RECOGNIZED: +3


--Attempt 3
SET SHOWBLANKS = ON
TABLE FILE CAR
PRINT MODEL
BY CAR
ACROSS COUNTRY COLUMNS 'ENGLAND' AND 'FRANCE' AND 'JAPAN'
..........
ON TABLE PCHOLD FORMAT HTML
..........
$
TYPE=DATA, COLUMN=CAR, COLOR=YELLOW,$
TYPE=REPORT, COLUMN=C1, COLOR=RED, POSITION=+.25,$
TYPE=REPORT, COLUMN=C2, COLOR=BLUE, POSITION=+.5,$
TYPE=REPORT, COLUMN=C3, COLOR=BLUE, POSITION=+.75,$
ENDSTYLE
END
==result== The color of the fonts shows correctly but the spaces don't seem to be added even if i put a big number.

--Attempt 4
SET SHOWBLANKS = ON
TABLE FILE CAR
PRINT MODEL
BY CAR
ACROSS COUNTRY +3 COLUMNS 'ENGLAND' AND 'FRANCE' AND 'JAPAN'
..........
ON TABLE PCHOLD FORMAT HTML
..........
==result== Error message: A WORD IS NOT RECOGNIZED: +3


Not sure if there is something in the style code that prevents from adding the spaces between the columns. So, I am attaching the completed code.

TABLE FILE CAR
PRINT MODEL
BY CAR
ACROSS COUNTRY COLUMNS 'ENGLAND' AND 'FRANCE' AND 'JAPAN'
FOR
..................
OVER
..................
HEADING
"Test"
ON TABLE SET PAGE-NUM OFF
ON TABLE SET FORMULTIPLE ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET BLANKINDENT ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,LEFTMARGIN=0.750000,RIGHTMARGIN=0.750000,TOPMARGIN=0.750000,BOTTOMMARGIN=0.750000,SQUEEZE=ON,ORIENTATION=PORTRAIT,$
DEFMACRO=HEADING1,FONT='TIMES NEW ROMAN',SIZE=18,COLOR='BLUE',STYLE=BOLD+ITALIC,LINES-PER-PAGE=20,$
DEFMACRO=HEADING2,FONT='TIMES NEW ROMAN',SIZE=14,COLOR='BLUE',STYLE=BOLD+ITALIC,INES-PER-PAGE=20,$
DEFMACRO=TITLES,FONT='TIMES NEW ROMAN',SIZE=12,COLOR='BLUE',STYLE=BOLD+ITALIC,LINES-PER-PAGE=20,$
DEFMACRO=BODY,FONT='ARIAL',SIZE=10,LINES-PER-PAGE=20,$
TYPE=REPORT,SIZE=9,COLOR='BLACK',BACKCOLOR='NONE',STYLE=NORMAL,TOPGAP=0.000000,LINES-PER-PAGE=20,MACRO=BODY,$
TYPE=DATA,MACRO=BODY,$
TYPE=TITLE,MACRO=TITLES,TYPE=TABHEADING,BORDER=LIGHT,MACRO=HEADING1,$
TYPE=TABFOOTING,MACRO=HEADING2,$
TYPE=HEADING,MACRO=HEADING1,$
TYPE=FOOTING,MACRO=TITLES,$
TYPE=SUBHEAD,MACRO=HEADING2,$
TYPE=SUBHEAD,LINE=1,MACRO=HEADING2,$
TYPE=SUBFOOT,BACKCOLOR='SILVER',STYLE=BOLD,MACRO=BODY,$
TYPE=SUBFOOT,LINE=1,MACRO=BODY,$
TYPE=SUBTOTAL,BACKCOLOR='SILVER',STYLE=BOLD,MACRO=BODY,$
TYPE=ACROSSVALUE,MACRO=TITLES,$
TYPE=ACROSSVALUE,COLUMN=ROWTOTAL(1),$
TYPE=ACROSSTITLE,MACRO=HEADING2,$
TYPE=PAGENUM,MACRO=TITLES,$
TYPE=RECAP,MACRO=BODY,$
TYPE=GRANDTOTAL,BACKCOLOR='SILVER',STYLE=BOLD,MACRO=BODY,$
TYPE=FREETEXT,LABEL=R8,COLUMN=N1,JUSTIFY=LEFT,$
TYPE=FREETEXT,LABEL=R1,COLUMN=N1,JUSTIFY=LEFT,$
TYPE=REPORT,LABEL=R8,COLUMN=N1,STYLE=BOLD+UNDERLINE,$
TYPE=REPORT,LABEL=R1,COLUMN=N1,STYLE=BOLD+UNDERLINE,$
TYPE=REPORT,LABEL=KPI_TEUS,COLUMN=N1,JUSTIFY=LEFT,$
TYPE=REPORT,LABEL=REV_OVER_TEU,COLUMN=N1,JUSTIFY=LEFT,$
TYPE=REPORT,LABEL=CON_OVER_TEU,COLUMN=N1,JUSTIFY=LEFT,$
TYPE=REPORT,LABEL=JLYTDMTEUS,COLUMN=N1,JUSTIFY=LEFT,$
TYPE=REPORT,LABEL=MARKET_GROWT,COLUMN=N1,JUSTIFY=LEFT,$
TYPE=REPORT, LABEL=OOCL_SHARE, COLUMN=N1, JUSTIFY=LEFT,$
ENDSTYLE
END


Hope there will a solution to it.

As I mentioned before (and you found out) the +3 does not work, nor is it correct syntax. For output PDF, my code works, but not for HTML. here's some code for HTML that DOES work:

TABLE FILE CAR
PRINT MODEL
BY CAR
ACROSS COUNTRY COLUMNS 'ENGLAND' AND 'FRANCE' AND 'JAPAN'
ON TABLE NOTOTAL
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=10,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
TYPE=HEADING,
     LINE=2,
     OBJECT=TEXT,
     ITEM=1,
     FONT='ARIAL',
$
TYPE=ACROSSVALUE,
SIZE=9,
WIDTH=3.0,
$
ENDSTYLE
END

Here is your Rex with the extra line for spacing with RR before and after. Copy this into your Fex and let us know how it worked.

-* File ATESTOFACR.fex
TABLE FILE CAR
PRINT MODEL
BY CAR
ACROSS COUNTRY COLUMNS 'ENGLAND' AND 'FRANCE' AND 'JAPAN'

HEADING
"Test"
ON TABLE SET PAGE-NUM OFF
ON TABLE SET FORMULTIPLE ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET BLANKINDENT ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,LEFTMARGIN=0.750000,RIGHTMARGIN=0.750000,TOPMARGIN=0.750000,BOTTOMMARGIN=0.750000,SQUEEZE=ON,ORIENTATION=PORTRAIT,$
DEFMACRO=HEADING1,FONT='TIMES NEW ROMAN',SIZE=18,COLOR='BLUE',STYLE=BOLD+ITALIC,LINES-PER-PAGE=20,$
DEFMACRO=HEADING2,FONT='TIMES NEW ROMAN',SIZE=14,COLOR='BLUE',STYLE=BOLD+ITALIC,LINES-PER-PAGE=20,$
DEFMACRO=TITLES,FONT='TIMES NEW ROMAN',SIZE=12,COLOR='BLUE',STYLE=BOLD+ITALIC,LINES-PER-PAGE=20,$
DEFMACRO=BODY,FONT='ARIAL',SIZE=10,LINES-PER-PAGE=20,$
TYPE=REPORT,SIZE=9,COLOR='BLACK',BACKCOLOR='NONE',STYLE=NORMAL,TOPGAP=0.000000,LINES-PER-PAGE=20,MACRO=BODY,$
TYPE=DATA,MACRO=BODY,$
TYPE=TITLE,MACRO=TITLES, $
TYPE=TABHEADING,BORDER=LIGHT,MACRO=HEADING1,$
TYPE=TABFOOTING,MACRO=HEADING2,$
TYPE=HEADING,MACRO=HEADING1,$
TYPE=FOOTING,MACRO=TITLES,$
TYPE=SUBHEAD,MACRO=HEADING2,$
TYPE=SUBHEAD,LINE=1,MACRO=HEADING2,$
TYPE=SUBFOOT,BACKCOLOR='SILVER',STYLE=BOLD,MACRO=BODY,$
TYPE=SUBFOOT,LINE=1,MACRO=BODY,$
TYPE=SUBTOTAL,BACKCOLOR='SILVER',STYLE=BOLD,MACRO=BODY,$
TYPE=ACROSSVALUE,MACRO=TITLES,$
TYPE=ACROSSVALUE,COLUMN=ROWTOTAL(1),$
RR
TYPE=ACROSSVALUE, SIZE=9, WRAP=2.000000, JUSTIFY=LEFT,$
RR
TYPE=ACROSSTITLE,MACRO=HEADING2,$
TYPE=PAGENUM,MACRO=TITLES,$
TYPE=RECAP,MACRO=BODY,$
TYPE=GRANDTOTAL,BACKCOLOR='SILVER',STYLE=BOLD,MACRO=BODY,$
TYPE=FREETEXT,LABEL=R8,COLUMN=N1,JUSTIFY=LEFT,$
TYPE=FREETEXT,LABEL=R1,COLUMN=N1,JUSTIFY=LEFT,$
TYPE=REPORT,LABEL=R8,COLUMN=N1,STYLE=BOLD+UNDERLINE,$
TYPE=REPORT,LABEL=R1,COLUMN=N1,STYLE=BOLD+UNDERLINE,$
TYPE=REPORT,LABEL=KPI_TEUS,COLUMN=N1,JUSTIFY=LEFT,$
TYPE=REPORT,LABEL=REV_OVER_TEU,COLUMN=N1,JUSTIFY=LEFT,$
TYPE=REPORT,LABEL=CON_OVER_TEU,COLUMN=N1,JUSTIFY=LEFT,$
TYPE=REPORT,LABEL=JLYTDMTEUS,COLUMN=N1,JUSTIFY=LEFT,$
TYPE=REPORT,LABEL=MARKET_GROWT,COLUMN=N1,JUSTIFY=LEFT,$
TYPE=REPORT, LABEL=OOCL_SHARE, COLUMN=N1, JUSTIFY=LEFT,$
ENDSTYLE
END

Hi, RSquared and Darin,

Thank you very much for your suggestions. Both of your suggestions work. I think my boss will like it. Again, very much appreciate your help.

Simon

Learner,

You are welcome. Please tag this item as Solved.

IMHO, I'd go with JG and RSquared and the WRAP.
i.e.: TYPE=ACROSSVALUE, WRAP=1.0,$
-Doug

what someone came up with in our site was doing a compute to compute empty fields. placing them where you need the splits and then using CSS statements to make them blank by removing borders and back-colours.

There was the further option to increase or decrease the width using IF statements in the CSS....

i can try dig out an example if needed?

If you're using CSS why bother with making dummy fields blank etc.?

Just use CSS padding:

TABLE FILE CAR
SUM
SALES/D10 AS ''
ACROSS COUNTRY AS ''
BY SEATS

ON TABLE SET PAGE NOLEAD
ON TABLE HOLD AS H001 FORMAT HTMTABLE
ON TABLE SET STYLESHEET *
TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=8, $
TYPE=REPORT, ACROSSCOLUMN=SALES, CLASS=AIRY, $
TYPE=ACROSSVALUE, JUSTIFY=RIGHT, $
ENDSTYLE
END
-RUN
-HTMLFORM BEGIN
<html>
<head>
<style>
.AIRY { padding-left: 60px; }
</style>
</head>
<body>
!IBI.FIL.H001;
</body>
</html>
-HTMLFORM END

the reason it's done here is so the size can be set on the fly to experiment with different output sizes....

Hi everyone,

I just got another request from my boss. He wants to add an extra space in the middle of all the columns.

ACROSS COUNTRY COLUMNS 'ENGLAND' AND 'FRANCE' AND ' ' AND 'JAPAN' AND 'ITALY'

That is what i did. It does add the extra column but with the dots in the column data cell. Is there a way to just add a column space without a dot showing in the data field...

SET NODATA = ' '

will set the value to blank for all missing data in a report request.

Hi Francis,

That works if all the column has data in it... but i have some data fields that have no data and need the dot in it. Is there a way to just set that extra column without dot?

I wouldn't use a dummy column to add spaces between columns in an HTML report, I'd use CSS styling:

-* Conditional styling and Across ----------------------------------------------

-* http://techsupport.informationbuilders.com/sps/22142010.html

DEFINE FILE CAR
FLAG/I1 = IF COUNTRY EQ 'ITALY' THEN 1 ELSE 0;
END
-RUN

TABLE FILE CAR
SUM
SALES/D10 AS ''
FLAG NOPRINT
BY MODEL
ACROSS COUNTRY AS ''

ON TABLE SET PAGE NOLEAD
ON TABLE HOLD AS H001 FORMAT HTMTABLE
ON TABLE SET STYLESHEET *
TYPE=REPORT, GRID=ON, FONT='ARIAL', SIZE=8, $
TYPE=DATA, ACROSSCOLUMN=SALES, CLASS=AIRY, $
TYPE=DATA, ACROSSCOLUMN=SALES, CLASS=VERYAIRY, WHEN=FLAG EQ 1, $
TYPE=ACROSSVALUE, JUSTIFY=RIGHT, CLASS=AIRY, $
ENDSTYLE
END
-RUN

-HTMLFORM BEGIN
<html>
<head>
<style>
.AIRY { padding-left: 35px; }
.VERYAIRY { padding-left: 90px;}
</style>
</head>
<body>
!IBI.FIL.H001;
</body>
</html>
-HTMLFORM END

Unfortunately, as described here, styling and ACROSS is a little flaky.

Hi Francis,

Thanks for the suggestion. Just wanted to let you know that i will try it tomorrow and let you know if i have any question. Thanks again!

Simon