Crosstab query looks horrible in report

[Noreene Patrick]

I made a crosstab query with these fields:

Row heading : Date
Column heading: Shift#
Value : Name

This gives me everyone by date and what shift they are on. And it works great!

But, the report looks horrible.

It has a person under shift 3 and on next line is person on shift 2 and so on. It looks jagged and horrible. I want each person under shift to begin at top of detail section and go into correct columns in order.

I know someone has had this problem. PLEASE HELP!!

Thanks in advance....Noreene

 

[dakcg]

Just a thought, but have you tried using the Sorting and Grouping option found in the View toolbar for your data on the report?

DAK

 

[Noreene Patrick]

yes, thank you but I have tried that. I finally got the report to sort and group using that method so all names in each column would stay together, but it still starts column 1 (first shift) way down on the page, column 2 (2nd shift) is grouped together but closer to the top of the detail section and column 3 (3rd shift) is at the very top of detail section (the way I wanted all columns to look). Any more suggestions?

Thanks for replying