Solved My report does not fit the page in print preview.

[Khurramshaikh47]

Page size is A4
Report width is 11.125"

Please guide me how to fix it.

 

[isladogs]

Reduce the margins. Click the margins button in your ribbon to do so.
If its still too big, then you will need to reduce the width of one or more controls
...or use A3 & get a new printer

 

[Gasman]

Go Landscape?

 

[isladogs]

Its already in landscape!

 

[Khurramshaikh47]

Its already in landscape!

Yes its already Landscape.

 

[arnelgp]

set Can Grow for the textbox to Yes.

 

[Khurramshaikh47]

You can see all margins are 0.25, Orientation is already Landscape, Page Size is A4, Report Width is already 11.125".

Reduce the margins. Click the margins button in your ribbon to do so.
If its still too big, then you will need to reduce the width of one or more controls
...or use A3 & get a new printer

 

[Khurramshaikh47]

set Can Grow for the textbox to Yes.

Done but still same problem

 

[arnelgp]

use smaller font size.

 

[Khurramshaikh47]

use smaller font size.

But the width of my report is 11.125 means A4 size. How its possible to cut my half page? Report's orientation is Landscape but its margin in layout view seems like portrait. You can see in the image below:

 

[arnelgp]

goto page setup and see the page orientation.

 

[Khurramshaikh47]

goto page setup and see the page orientation.

I saw many time its Landscape. You can see

Check here also

 

[Gasman]

Its already in landscape!

Oops, sorry. Not enough coffee

 

[The_Doc_Man]

You have reached the ultimate problem with any report in any language - excessive data density. You need to either set the DESCRIPTION field with .CANGROW = 1 and shrink its .WIDTH or you need to use a REALLY small font or you must accept that you will truncate something. You have too much data to be displayed in that format.

 

[Khurramshaikh47]

Thank you so much to all. Solved

 

[chrisdd]

Evening all,

I've got something strange with some reports - they are showing fine as A4 landscape reports for me, but when my client opens them they open as A3 reports with a large area of white space although they are in the correct orientation - there are several printers available and it does the same thing with all as well as when saving as a PDF, I'm stumped but it must be something simple surely?

 

[The_Doc_Man]

@chrisdd - Check the properties of your client's default printer. Sometimes the default printer's settings work their way into other things.

Also, this is not a big dig against you, but you often do better to open a new problem rather than ride on an old one. You tacked a problem onto a thread that is over 12 months old. It's not illegal to do so; there are no rules against it; but it isn't wise if you want the most exposure on your problem.