Solved

Rotate SubReport 90 degrees

Posted on 2006-06-15
3
1,090 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
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 84

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

911 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now