Link to home
Start Free TrialLog in
Avatar of kgittinger
kgittingerFlag for United States of America

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?

Avatar of Torrwin
Torrwin
Flag of United States of America image

Do you mean the heading labels for your data?

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.
Avatar of Helen Feddema
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.
Avatar of kgittinger

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
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.
Should I be able to just pull in the summarized data as such?
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I'll try it.  Thanks!