I am trying to use alignment grid to draw border lines. Because the special request, I put everything in subhead. Within the subhead, multiple lines there contain name, phone, numeric fields, etc. for each record. For each field within a line, I need border lines around for each “cell”. However, for some cells, the left or right lines cannot align from the first record to the last record.

For example, the first record has right border line at the position I want, but the line at the last record shift to the right at the pdf report.

TYPE=SUBHEAD,
BY=2,
LINE=3,
OBJECT=TEXT,
ITEM=5,
BORDER-BOTTOM=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-BOTTOM-STYLE=SOLID,
BORDER-RIGHT-STYLE=SOLID,
BORDER-BOTTOM-COLOR='BLACK',
BORDER-RIGHT-COLOR='BLACK',
JUSTIFY=LEFT,
WIDTH=.694,
$

Also, I am not sure why I have to put some border lines in field cell (below) instead of text cell (above).

TYPE=SUBHEAD,
BY=2,
LINE=7,
OBJECT=FIELD,
ITEM=1,
BORDER-BOTTOM=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-BOTTOM-STYLE=SOLID,
BORDER-RIGHT-STYLE=SOLID,
BORDER-BOTTOM-COLOR='BLACK',
BORDER-RIGHT-COLOR='BLACK',
JUSTIFY=LEFT,
WIDTH=1.444,
$

WebFocus 7611

Thank you a lot,

This message has been edited. Last edited by: <Kathryn Henning>,

What is your output format? Have you considered COLSPAN? Can you dup this using the CAR file (with DEFINEd fields ir needed)?

I didn’t make a line between model and bodytype. The same for sales and length, I failed to create a line between there for this car table. For line 6, I should make dark blue color as line 5, but can’t start it below dealer cost. I am not sure if I can create the straight line between model and bodytype, or a line from sales and length, then the first straight line (the record “England”) still will be align with the last record (the record “W Germany”) or not.

TABLE FILE CAR
BY 'CAR.ORIGIN.COUNTRY' NOPRINT

ON CAR.ORIGIN.COUNTRY SUBHEAD
" <0> <8> Country: "
" <0> <9><16>CAR <30>MODEL <46>BODYTYPE"
" <0> <9> <15>" <0> <4> "
" <0> <9> <15>DEALER_COST<26>RETAIL_COST<39>SALES<50>LENGTH "
" <0> <9> "
" <0> <9> <16>" <0> <7> ________________________________________________________________"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
ALIGN-BORDERS=BODY,
FONT='ARIAL',
SIZE=10,
$
TYPE=SUBHEAD,
BY=1,
LINE=1,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=.806,
$
TYPE=SUBHEAD,
BY=1,
LINE=1,
OBJECT=TEXT,
ITEM=2,
BORDER-TOP=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-TOP-STYLE=SOLID,
BORDER-LEFT-STYLE=SOLID,
BORDER-RIGHT-STYLE=SOLID,
BORDER-TOP-COLOR='BLACK',
BORDER-LEFT-COLOR='BLACK',
BORDER-RIGHT-COLOR='BLACK',
BACKCOLOR=RGB(176 255 255),
JUSTIFY=LEFT,
WIDTH=.306,
$
TYPE=SUBHEAD,
BY=1,
LINE=1,
OBJECT=TEXT,
ITEM=3,
SIZE=14,
STYLE=BOLD,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=1,
OBJECT=FIELD,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=1,
OBJECT=FIELD,
ITEM=2,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=2,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=.806,
$
TYPE=SUBHEAD,
BY=1,
LINE=2,
OBJECT=TEXT,
ITEM=2,
BORDER-LEFT=MEDIUM,
BORDER-LEFT-STYLE=SOLID,
BORDER-LEFT-COLOR='BLACK',
BACKCOLOR=RGB(176 255 255),
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=2,
OBJECT=TEXT,
ITEM=3,
SIZE=8,
COLOR='WHITE',
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=2,
OBJECT=TEXT,
ITEM=4,
SIZE=8,
COLOR='WHITE',
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=2,
OBJECT=TEXT,
ITEM=5,
SIZE=8,
COLOR='WHITE',
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=2,
OBJECT=FIELD,
ITEM=1,
SIZE=12,
BACKCOLOR=RGB(0 0 139),
STYLE=BOLD,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=2,
OBJECT=FIELD,
ITEM=2,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=2,
OBJECT=FIELD,
ITEM=3,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=2,
OBJECT=FIELD,
ITEM=4,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=2,
OBJECT=FIELD,
ITEM=5,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=2,
OBJECT=FIELD,
ITEM=6,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=2,
OBJECT=FIELD,
ITEM=7,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=3,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=.806,
$
TYPE=SUBHEAD,
BY=1,
LINE=3,
OBJECT=TEXT,
ITEM=2,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-LEFT-STYLE=SOLID,
BORDER-RIGHT-STYLE=SOLID,
BORDER-LEFT-COLOR='BLACK',
BORDER-RIGHT-COLOR='BLACK',
BACKCOLOR=RGB(176 255 255),
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=3,
OBJECT=TEXT,
ITEM=3,
BORDER-BOTTOM=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-BOTTOM-STYLE=SOLID,
BORDER-RIGHT-STYLE=SOLID,
BORDER-BOTTOM-COLOR='BLACK',
BORDER-RIGHT-COLOR='BLACK',
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=3,
OBJECT=TEXT,
ITEM=4,
BORDER-BOTTOM=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-BOTTOM-STYLE=SOLID,
BORDER-RIGHT-STYLE=SOLID,
BORDER-BOTTOM-COLOR='BLACK',
BORDER-RIGHT-COLOR='BLACK',
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=3,
OBJECT=TEXT,
ITEM=5,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=3,
OBJECT=FIELD,
ITEM=1,
BORDER-BOTTOM=MEDIUM,
BORDER-BOTTOM-STYLE=SOLID,
BORDER-BOTTOM-COLOR='RED',
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=3,
OBJECT=FIELD,
ITEM=2,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=3,
OBJECT=FIELD,
ITEM=3,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=3,
OBJECT=FIELD,
ITEM=4,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=3,
OBJECT=FIELD,
ITEM=5,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=3,
OBJECT=FIELD,
ITEM=6,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=3,
OBJECT=FIELD,
ITEM=7,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=3,
OBJECT=FIELD,
ITEM=8,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=4,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=.806,
$
TYPE=SUBHEAD,
BY=1,
LINE=4,
OBJECT=TEXT,
ITEM=2,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-BOTTOM-STYLE=SOLID,
BORDER-LEFT-STYLE=SOLID,
BORDER-RIGHT-STYLE=SOLID,
BORDER-BOTTOM-COLOR='BLACK',
BORDER-LEFT-COLOR='BLACK',
BORDER-RIGHT-COLOR='BLACK',
BACKCOLOR=RGB(176 255 255),
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=4,
OBJECT=TEXT,
ITEM=3,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=4,
OBJECT=FIELD,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=4,
OBJECT=FIELD,
ITEM=2,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=5,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=.806,
$
TYPE=SUBHEAD,
BY=1,
LINE=5,
OBJECT=TEXT,
ITEM=2,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=5,
OBJECT=TEXT,
ITEM=3,
BACKCOLOR=RGB(0 0 139),
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=5,
OBJECT=TEXT,
ITEM=4,
SIZE=8,
COLOR='WHITE',
BACKCOLOR=RGB(0 0 139),
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=5,
OBJECT=TEXT,
ITEM=5,
SIZE=8,
COLOR='WHITE',
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=5,
OBJECT=TEXT,
ITEM=6,
SIZE=8,
COLOR='WHITE',
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=5,
OBJECT=TEXT,
ITEM=7,
SIZE=8,
COLOR='WHITE',
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=5,
OBJECT=FIELD,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=5,
OBJECT=FIELD,
ITEM=2,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=5,
OBJECT=FIELD,
ITEM=3,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=5,
OBJECT=FIELD,
ITEM=4,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=5,
OBJECT=FIELD,
ITEM=5,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=5,
OBJECT=FIELD,
ITEM=6,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=6,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=.806,
$
TYPE=SUBHEAD,
BY=1,
LINE=6,
OBJECT=TEXT,
ITEM=2,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=6,
OBJECT=TEXT,
ITEM=3,
BACKCOLOR=RGB(0 0 139),
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=6,
OBJECT=FIELD,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=6,
OBJECT=FIELD,
ITEM=2,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=6,
OBJECT=FIELD,
ITEM=3,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=7,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=.806,
$
TYPE=SUBHEAD,
BY=1,
LINE=7,
OBJECT=TEXT,
ITEM=2,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=7,
OBJECT=TEXT,
ITEM=3,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-BOTTOM-STYLE=SOLID,
BORDER-LEFT-STYLE=SOLID,
BORDER-RIGHT-STYLE=SOLID,
BORDER-BOTTOM-COLOR='BLACK',
BORDER-LEFT-COLOR='BLACK',
BORDER-RIGHT-COLOR='BLACK',
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=7,
OBJECT=TEXT,
ITEM=4,
BORDER-BOTTOM=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-BOTTOM-STYLE=SOLID,
BORDER-RIGHT-STYLE=SOLID,
BORDER-BOTTOM-COLOR='BLACK',
BORDER-RIGHT-COLOR='BLACK',
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=7,
OBJECT=TEXT,
ITEM=5,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=7,
OBJECT=TEXT,
ITEM=6,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=7,
OBJECT=FIELD,
ITEM=1,
BORDER-BOTTOM=MEDIUM,
BORDER-BOTTOM-STYLE=SOLID,
BORDER-BOTTOM-COLOR='BLACK',
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=7,
OBJECT=FIELD,
ITEM=2,
BORDER-BOTTOM=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-BOTTOM-STYLE=SOLID,
BORDER-RIGHT-STYLE=SOLID,
BORDER-BOTTOM-COLOR='BLACK',
BORDER-RIGHT-COLOR='BLACK',
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=7,
OBJECT=FIELD,
ITEM=3,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=7,
OBJECT=FIELD,
ITEM=4,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=7,
OBJECT=FIELD,
ITEM=5,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=7,
OBJECT=FIELD,
ITEM=6,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=7,
OBJECT=FIELD,
ITEM=7,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=7,
OBJECT=FIELD,
ITEM=8,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=7,
OBJECT=FIELD,
ITEM=9,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=7,
OBJECT=FIELD,
ITEM=10,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=8,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=.806,
$
TYPE=SUBHEAD,
BY=1,
LINE=8,
OBJECT=TEXT,
ITEM=2,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=8,
OBJECT=TEXT,
ITEM=3,
SIZE=14,
STYLE=BOLD,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=8,
OBJECT=FIELD,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=8,
OBJECT=FIELD,
ITEM=2,
JUSTIFY=LEFT,
WIDTH=1.000,
$
ENDSTYLE
END

Output format is PDF. Tried colspan, but not working.

Assigning borders in items in a SUBHEAD for PDF won't work.

I think you will need to rethink your solution.

Although there is a possibility that you could use the OBJECT=BOX stylesheet command to get what you want, a bit tricky though.

For me (WebFOCUS 7.7.03) assigning borders in a SUBHEAD to TEXT or FIELD items actually works.

If it does not yet work in 7611 - would it be an option for you, EdHou, to upgrade?

Another alternative that I could think of (and have used once in the past): creating an SVG "image" (which actually displays the borders) and referring it in the subhead. It is however a bit tedious to create such an image exactly as you want. Maybe Waz' idea using OBJECT=BOX works better - never tried that though.

Just an idea Concerning alignment - don't know if applicable for you: have you tried using HEADALIGN=BODY (which would force your SUBHEAD cells to match the DATA cells)? You might need some empty dummy cells in your report (to match the number of entries in SUBHEAD).

Is possible you can provide some sample codes for OBJECT=BOX and SVG image? I'll try HEADALIGN=BODY. Thank you very much.

Is possible you can provide some sample codes using the CAR table? Thank you again.

Is possible for you to provide a mockup of what it is that you want, in the form of an image? I ask this because there may be a better way, all together, to accomplish what it is that I think you want.

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

I know for certain there were problems with borders in releases prior to 7.7.03. I had to do all kinds of manipulations to make a similar report work in 7.6 and all were fixed by installing 7.7.03.

Vivian Perlmutter

Something line this?


Jun 19: I changed and stripped out a lot, including many of the spot markers and style code, down to 19 lines of code. More in the morning.

Jun 20: I changed the BACKCOLOR and added two style lines to bold COUNTRY and RCOST, just because I felt like changing it.

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

I can't copy and paste the pdf to here.

Something like that. However, with "Country:" on the very left, but country name such as ITALY under "Country:". "CAR MODEL BODYTYPE" at the 2nd line with dark blue color. "MASERATI, DORA 2 DOOR, COUPE" is at the 3rd line with white color. 4th line is blank has the same color with the 1st line. The very left of 2nd line and 3rd line has the same color with the 1st line. Border lines are around the top of the 1st line, the bottom of the 4th line, and left and right border lines. Each cell has border lines around it. For example, border line around "MASERATI".

"DCOST RCOST SALES LENGTH" at the 5th line with dark blue color. The 6th line is with dark blue color. "41,235 51,065 30300 687" is at the 7th line with white color. From the 5th line to 7 line looks indent to right with cell border lines.

My biggest problem is to draw those border lines.

Thank you a lot.

Unfortunately, we don’t have 7703 here. Thank you.

Good news: This was done in 7611... No need to "draw those border lines".

I'm feeling good today. So, here's the code taht I used. Play with it as you see fit and let me know what issues you still have (if any).

SET PAGE=NOLEAD
SET DROPBLNKLINE = ON
TABLE FILE CAR
BY 'CAR.ORIGIN.COUNTRY' NOPRINT SUBHEAD
"Country: <COUNTRY"
"<5>CAR: <CAR <28>MODEL: <MODEL <60>BODYTYPE: <BODYTYPE </1>"
"<3>DCOST: <DCOST<32>RCOST<RCOST<50>SALES: <SALES<65>LENGTH: <LENGTH </1>"
ON CAR.ORIGIN.COUNTRY SUBFOOT
""
ON TABLE SET PAGE-NUM OFF 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,PAGESIZE='Letter',SQUEEZE=OFF,ORIENTATION=PORTRAIT, GRID=ON, topmargin=.0,$
TYPE=SUBHEAD, BORDER=LIGHT, BACKCOLOR=RGB(244 244 244),$
TYPE=SUBHEAD, LINE=1, ITEM=2, STYLE=BOLD,$
TYPE=SUBHEAD, LINE=4, ITEM=4, STYLE=BOLD,$
TYPE=SUBFOOT, BORDER-TOP=LIGHT,$
ENDSTYLE
END

The SET PAGE=NOLEAD and SET DROPBLNKLINE = ON are essential, as is the use of SUBFOOT. Please post your final code, using the icon (in the reply toolbar).

However, I need those border lines. Why NOLEAD and DROPBLNKLINE are essential? I am still trying. Thank you very much.

Are there more border lines required then those show in the above image (posted Wed Jun 19 2013 17:49)?

Perhaps you can post or send (Using PM) an image of what you want.

Sorry, I didn't figure out how to post an image yet.

Email an image of what you want, to any of us, using PM (Private Message).

It'll be a lot easier to show you how to do what you want after we know what it is that you want.

The usual process to post an image, is to use a site like tinypic.com, then add the url of the tinypic image to the post.

I am using PM send image to you. Thank you.

Above image is what I want. I need straight line between each cell. The lines should be aligning at the same position from the first record to the last record. I covered data with yellow box.

Thank you all.

You may need to use "Precision Report" for this...

How many records per page?

The TinyPic works...

You could do something like this... Clunky, tedious, and many boxes... (added to the code posted Thu Jun 20 2013 10:41)...

-* LINE 1
TYPE=REPORT, OBJECT=Box, POSITION=(0.200000 0.350000), DIMENSION=(2.500000 0.200000), BACKCOLOR=SILVER,$
TYPE=REPORT, OBJECT=Box, POSITION=(0.800000 0.680000), DIMENSION=(1.900000 0.200000), BACKCOLOR=GRAY,$
-* LINE 2
TYPE=REPORT, OBJECT=Box, POSITION=(0.200000 1.850000), DIMENSION=(2.500000 0.200000), BACKCOLOR=SILVER,$
TYPE=REPORT, OBJECT=Box, POSITION=(0.800000 2.180000), DIMENSION=(1.900000 0.200000), BACKCOLOR=GRAY,$

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

4 to 6 records per page. I guess your post at 12:47 pm is the "Precision Report"? I'll check that. Thank you.

Nope, that the "Clunky, tedious, and many boxes..." report display approach. The Precision Report is here:

I tried the precision report, not working yet. I will continue try it and others. Thank you a lot.