kgittinger
asked on
how to change report orientation so headers are on the left not on the top
How Can I change the report orientation so headers are on the left not on the top and my data is set next to that?
Can you post a sketch of how you want the report to look? I am having problems visualizing it. For example, do you want the header text to run vertically, at right angles to the detail text?
(I am not saying that is possible . . .)
<<How Can I change the report orientation so headers are on the left not on the top and my data is set next to that?>>
You can rotate the entire page by using file/page setup, page tab, and change the orientation to landscape.
Normally, on a 8 1/2" x 11 page, a report prints left to right across the 8 1/2" side and down the 11". Landscape would do the opposite, print left to right across 11" and down the page on the 8 1/2" side.
If you actually what to have the headings on the left and the detail on the right vertially down the page, that's something else.
JimD.
You can rotate the entire page by using file/page setup, page tab, and change the orientation to landscape.
Normally, on a 8 1/2" x 11 page, a report prints left to right across the 8 1/2" side and down the 11". Landscape would do the opposite, print left to right across 11" and down the page on the 8 1/2" side.
If you actually what to have the headings on the left and the detail on the right vertially down the page, that's something else.
JimD.
ASKER
I do want the header to run vertically from top to bottom with the data to the right. I am trying to avoid querying via exel to put the data in the format I am bing requested to present.
Thanks so much
Can you get an idea based on this picture?
Rotation.bmp
Thanks so much
Can you get an idea based on this picture?
Rotation.bmp
You might be able to accomplish that with a subreport. If you create a main report that just contained your header data, you could then insert a subreport next to it that contained all of your detail.
ASKER
Should I be able to just pull in the summarized data as such?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'll try it. Thanks!
If so you can just cut and paste them into the detail section, right next to your data. However, they will appear for every row of data in your report.