Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jhermiz
3564 Posts |
 Posted - 2004-11-04 : 16:48:56
|
| How do I change a report in sql server to make it landscape...need more width... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-04 : 16:55:36
|
| Just make it bigger by dragging the outer edges. Or are you talking about when it gets printed?Tara |
 |
|
|
jhermiz
3564 Posts |
Posted - 2004-11-04 : 17:07:41
|
| well i tried doing that but when i view the "page" it seperates it into 4 pages with the rest being the right side of the report. |
|
|
|
jhermiz
3564 Posts |
Posted - 2004-11-04 : 17:08:03
|
| i know when you print it you set that up in ur printer options. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-04 : 17:11:17
|
| I've only seen this happen when the page was viewed in PDF format. What happens if you make the page even bigger? I wonder if it's because the cells are set to automatically expand depending on the contents but you reached the maximum width so it put it on another page.Tara |
|
|
|
jhermiz
3564 Posts |
Posted - 2004-11-05 : 14:36:17
|
| im still having issues with this...when i look at the design of the report it hits about 10".I could see if the report was portrait that it would use so many pages, but I want the report to be in landscape mode. I tried looking at the properties of the report and the page width and height is 8.5 x 11The left margin / right and bottom are all set to .5 which is what I want. THe top margin is set to .65.I want this report to come out in landscape but it looks like when it runs its in portrait because a reportthat should be one page is 4 pages :( |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-05 : 15:18:00
|
| Did you try expanding it to say 15"?Tara |
|
|
|
jhermiz
3564 Posts |
Posted - 2004-11-05 : 15:36:34
|
| I figured it out, I swapped the page width and height and that did the trick.Jon |
|
|
|
|
|
|
Landscape