473,386 Members | 1,644 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Read Reports in Landscape

Hi Everyone, I have a big database that I am building, very simple, but very annoying. I keep changing certain reports to open in Landscape (by changing the setting in Page Setup) Only to find that the next time I open it it opens in Portrait! Can anyone give me a solution?
May 6 '07 #1
3 1400
JConsulting
603 Expert 512MB
If you're making change in the page layout and saving them, then those changes SHOULD remain when the report is open again. Are you making the changes while the report is open in design view? If not, you should.
I'm also assuming there's not any kind of code in place to change the orientation at runtime?
May 6 '07 #2
MMcCarthy
14,534 Expert Mod 8TB
You have posted this question in the Articles section. I am moving it to the Access forum.

ADMIN
May 6 '07 #3
ADezii
8,834 Expert 8TB
Hi Everyone, I have a big database that I am building, very simple, but very annoying. I keep changing certain reports to open in Landscape (by changing the setting in Page Setup) Only to find that the next time I open it it opens in Portrait! Can anyone give me a solution?
Try modifying the Orientation for the Printer specifically assigned for the Report:
Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenReport "Report1", acViewDesign
  2. Reports("Report1").Printer.Orientation = acPRORLandscape
  3. DoCmd.OpenReport "Report1", acViewNormal
May 7 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: amber | last post by:
Hi there, I'm having trouble with the page setup in a report I've created. Originally I copied an existing report (that was setup as landscape layout). On the new report, I changed the layout to...
3
by: MarcJ | last post by:
Hello, I can't seem to get printing to landscape working. Here is some of the code I've tried. '--------------------------------------------------------------------------------- Dim...
2
by: Jeannette | last post by:
Hi! there, I am currently working on web-based reports using crystal reports.NET 2003 and I am new to this reporting tool. I notice that the WEB forms report viewer toolbar does not include the...
11
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on...
0
by: Dino L. | last post by:
hi, Can I give option for landscape printing in crystal reports viewer?
2
by: Atley | last post by:
I have imbedded a report in my project (added a report to my project and set some fields) How the heck do I access the report in my program? I have looked on MSDN and searched for a...
2
by: Ralf | last post by:
I posted under a different subject earlier, no responses. I have changed the question somewhat. Is there a way to have the report come up in landscape, not just print in landscape? I know how...
0
by: matvin | last post by:
When generating .NET Crystal Reports with Page Orientation as Landscape, a Blank page gets generated along with the report. But this is not the case when the page orientation is set with Portrait.Any...
1
by: Momo15 | last post by:
When I try exporting a report in Rich Text Format or Email it, some my data is altered. Additionally, when I try “emailing” the same thing happens. One of my reports with was landscape orientation...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.