Sunday, February 19, 2012

Column Headers at the top of the page....?

I have a report looking something like this:

Field 1 Field 3 Field 5

RandomInfo1 RandomInfo1 RandomInfo1

RandomInfo2 RandomInfo2 RandomInfo2

Field 2 Field 4 Field 6

RandomInfo1 RandomInfo1 RandomInfo1

RandomInfo2 RandomInfo2 RandomInfo2

It extends along a fair number of pages, and I'm currently using the "# of columns = 3" in the Report properties --> Layout section in order to make it span over 3 columns instead of the usual 1. I'm using a table in which the random info fields are the repeating values, and the Field 1,2,3,4,etc are included in the list control, but not part of the physical table itself.

My question stems from a couple of chunks of data which basically extend over the course of 1.5 pages (yep. There's enough to fill about 4.5 columns worth.)

I currently have

Field 1 RandomInfo50 RandomInfo100

RandomInfo1 RandomInfo51 RandomInfo101

Randominfo2 RandomInfo52 RandomInfo102

etc.... etc.... etc....

--NewPage-

RandomInfo150 Field 2

Randominfo151 NewRandomInfo1

RandomInfo152 NewRandomInfo2

etc...

What I'm looking to do is have "Field 1" appear at the top of each column whenever a larger chunk of data forces itself into multiple columns, or even multiple columns on multiple pages. I have this nasty feeling it's something silly and blatantly obvious I'm missing...

Any thoughts?

Is "repeat header rows on each page" checked in the properties for the matrix/table?|||

Wow.

I swear I tried that in earlier attempts... It caused a strange... bleh. No matter!

Cheers Greg!

No comments:

Post a Comment