Rotate entire report

[PRMiller]

Good evening,

I have a "continuous report" that can grow to an infite length depending on the number of records. Due to design parameters, the report needs to grow horizontally. Here's an example:

Rec Item1 Item2 Item3 Item4
1
2
3
4

With data being populated under Item1 through Item4. Oftentimes, a particular Rec may have an Item5, Item6, Item7, etc. etc. So, the report grows horizontally. Of course, this isn't possible (I don't think), so we had to make it grow vertically.

To meet the design needs, we set the Vertical property of every label and text box to "Yes." The result is a report that you have to look at sideways on your computer, but prints very nicely.

I'd be happy there. However, I should know better! Enough users are complaining (Hey, I can turn my laptop on its side, but it's harder for them with desktops!!) that I need to find a way to rotate the ENTIRE report 45 degrees.

There are many posts here about rotating TEXT and LABELS, but not entire REPORTS. Does anyone know if this is possible?

Thanks,
Paul

 

[dhookom]

Is there are reason why you end up with so many columns? Is this a crosstab query?
I doubt you can rotate an entire report 45 degrees. I would check

http://www.lebans.com

for rotating code solutions.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[PRMiller]

Hi Duane,

Thanks for the reply. In my example above, "Rec" = an employee and "Item" = a performance measurement.

Each of employee's -- customer service representatives -- have a minimum of eight call observations each month. Each call observation returns a score, which we want to report. We also break each call down into it's various segments (ie - "Did you use proper grammer?", "Were you courteous?", etc) so we can see what contributed to the score.

While the report worked fine for 8 observations (it fit on one page horizontally), it didn't give us a true picture of a trend over time. So, our design parameters said, "Give the user the option to run this for one month, two months, a year, etc" so that they could truly see that trend over time. Therefore, an employee may have 8, 10, 20, 30, etc calls, each one requiring its own column.

I'll check out the link you provided.

Thanks,
Paul

 

[PRMiller]

I checked out

http://www.lebans.com

but could not find any solutions. Any other thoughts out there?

 

[dhookom]

There are some sample crosstab reports at

http://www.invisibleinc.com/divFiles.cfm?divDivID=4

but I wouldn't guarantee these will work for you.

It may be that your only option is scissors and glue.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.