Grid Formatting 1

[CoSpringsGuy]

What is the easiest way to make a report look like a spreadsheet with all the values seperated in cells. Would you guys suggest adding boxes to all of the cells? is there an easier way?


_____________________________________
Not the brightest
Crystal Reports XI Developer Version
user in the world........

 

[MrBillSC]

Try increasing length of each field until its border touches the adjacent field. Then hilight all the fields, right click on them, select "format fields", and add a single line border to all 4 sides.

MrBill

 

[CoSpringsGuy]

using that and snapping to vertical and horizontal guidelines is the ticket! Thanks

_____________________________________
Not the brightest
Crystal Reports XI Developer Version
user in the world........

 

[PhilB2]

To attempt to enclose my detail lines to make them look like a spreadsheet, I tried creating boxes and/or lines. Both worked, except that the bottom border for the first set of detail lines and the top border for the next set did not meet, leaving a small gap between them. I tried lining up the bottom border as close to the bottom edge of the detail section as I could, but I couldn't close the gap. I thought of leaving out the bottom border, and somehow working it out so only the last line would be followed by a border, but don't know how.

 

[PhilB2]

Helpful spelling hint: There's "a rat" in "separate".

 

[PhilB2]

Here is a solution that works for me, that I tried after reading the post and replies:

I my Detail Section, I used lines, not boxes, and view | zoom | 400, turned off Align to Grid. I placed the top line as high as it could go in the Detail section, and used vertical lines where needed. I left out the bottom line.

I inserted the bottom line in my Group 2 Footnote (Group 2 precedes my Detail Section), as high as it could be placed.

 

[lbass]

You could also create a grid in a page header section that is resized to the size of the page, and then format it to underlay following sections.

-LB

 

[PhilB2]

Formatting the lines as dashed or dotted allows the lines appear to meet precisely even though they would need more precise positioning if they were solid.

 

[PhilB2]

Refering to using top, left and right lines in the section in which you would like the grid, and the bottom line in the Group Footer:

Turns out aligning the lines to the grid is a better idea, once the section is set up so that the top and bottom borders of the section are aligned to the

 

[PhilB2]

Whoops! When I place the bottom line of the Detail grid in the Group Footer, it appears on the next page when the detail line above it is positioned at the page bottom.

 

[PhilB2]

What seems to work, although I encountered some strange effects for a while on the lower left corner of my grid, was to turn on Align to Grid and create lines to form the grid, all within one section.

 

[PhilB2]

I think the approach of inserting lines except for the bottom line, and placing the bottom line in the group footer, would work, if Print at Bottom of Page is selected in the Group Expert dialog box.

 

[PhilB2]

Sorry--regarding my prior post, I found out that Print at Bottom means don't print anywhere else.

 

[PhilB2]

I've found that using precisely positioned lines normally works, but when I tried suppressing fields when blank, the lines still showed up.

To get around this problem, I re-created my grid by carefully lining up fields and selecting borders.

(One possible disadvantage of using borders vs. lines is that, at least in Crystal 9.2, for lines one is able to select a couple of thinner (finer) grades than the default, and that is not true of borders.