column report with headers along the side

[ssalem]

Hi I am trying to create a report wich displays 3 records at a time. My problem is I want to have 3 columns which I was able to do. But I want going down along the report 1 header saying what each field of the record is. In other words something like this:




Title Home Depot Menards Lowes
Issue ad1771 ad4545 ad3934
Job Number B314UWM B314UWN B314UWO
PSR Person A Person B Person C
CSR Salesperson Sales A Sales B Sales C
Etc:

I can get 3 columns to display but I get the headers 3 times. Is there any kind of control I can put in to move to the next record. I was trying to think if there was a way to even code iit if I had to. Just not sure how to get what I want.

Thanks for any help.

[rpeare]

what does your original data look like?

[ssalem]

I solved it. What I ended up doing was writing it all in VB. I created a loop through all the records and loading 3 records into 1 record using a counter. Then used that table for the report. And at anytime the field I was grouping on also changed it would reset the counter. So in otherwords created a temp table with title1,title2,title3,Issue1,Issue2,Issue3...etc. Then loading all 3 records to one report.

Sometimes there probably is more then one way to skin a cat.