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.