Solved

Rotate SubReport 90 degrees

Posted on 2006-06-15
3
1,129 Views
Last Modified: 2008-02-01
Is it possible to rotate a subreport in Access? Instead of going down I'd like to have my records go across.
Any ideas welcome!
0
Comment
Question by:Michael Vasilevsky
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 10

Accepted Solution

by:
LenaWood earned 300 total points
ID: 16916579
If you design the subreport with your controls going across then that is what you will get.  If you mean each record adds a new row across instead of down I guess you could try creating columns in your report (Under page setup).  What is going to happen when you get more records than you have columns?

Lena
0
 
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 200 total points
ID: 16916595
You can try creating a CrossTab query, if this will display your results correctly.

Lena is correct, however ... what happens when you can't fit anymore records into your report horizontally?
0
 
LVL 10

Author Comment

by:Michael Vasilevsky
ID: 16916651
No native way to rotate, eh?
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question