Laying out report in tabular form (with complete borders around)

Up until now, I've always layed out reports without any structure between report  elements - in other words things were lined up, etc. and maybe there was an underline underneath the header row, and one above the summary, etc. But there was never a need to have a fully enclosed table.

But now I'm having a hard time groking how to display some data as if it were some cells in a spreadsheet. WIth border lines between each row and each column. As an example of what data I'm displaying:

Section Heading:  (this cell spans all three four columns)
Name:           Person 1         Person 2         Person 3
Address:      Address1       Address2        Address3
Frequency:   Quarterly        Monthly           Quarterly
Type:             Single             Consolidated   Consolidated

Basically, "Section Heading" is just a text field, as are the labels in the first column: "Name, Address, Frequency, Type) But then everything in the 2nd, 3rd, and 4th columns is coming out of a view in SQL Server.

Thus far I've been able to "insert box" and have that span various sections. So I can box in the data ok, but trying to get lines between the columns and rows where appropriate is challenging. I thought the Cross-tab function would work - but that seems to be more for manipulating numbers or values that can be summarized, grouped, subtotaled, etc. I can draw lines from one side of the outer box to the other and from top to bottom - but this is very inexact - is there a trick I'm missing for getting all of that to line up

I think I must be missing something very obvious. I'm self-taught and though I never had to before, I figured it would be very simple to display data in a table format.
LVL 1
rreimundAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ToniCoderCommented:
I had to do something similar recently.  Instead of using the box, I used vertical and horizontal lines.  You can place the horizontal lines at the bottom of the detail section so that they print at the end of every row of your data.  Then place the vertical lines only on the top section making them extend to all sections like you did for the box.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rreimundAuthor Commented:
Is there anyway to get the horizontal and vertical lines to snap at the corners and intersections?

The issue I had with the box was that I had to constantly fiddle with them to get them to line up just right.

I also was trying to get the top row to have a silver background. This meant layering a smaller box one row tall withsilver background over the big box that spanned multiple rows. I can see how the indiv lines might help.

Also, the various rows aren't repeated so each row is actually it's own detail section. Any way to get those all the same height?
0
mlmccCommented:
As far as I have found there is no easy way to get lines to snap together.  I always seem to be fiddling with them to get them to look right.

mlmcc
0
ToniCoderCommented:
What I do is look at the size and position of the lines I need to align then try to match the x or y coordinates.

You could also move the lines using your keyboard's arrow keys.  I find it easier to use the keys when I have to move the lines just a hair.

To make sure the rows are the same height, use the ruler to determine the size of one then make the height of the other details the same as the first.
0
rreimundAuthor Commented:
Thanks guys..

the individual horizontal and vertical lines seems to work better than trying to nest boxes, etc.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.