Report page size when printing

I use SQL Server 2005 Reporting Services. The clients use Internet Explorer 6 or higher on Windows XP.

When i access a report by ReportServer URL, the report viewer show me this report with my default parameters selected. If i choose "PDF" format and i click "Export", my report is perfect on printing.

My problem is the button print of the ReportViewer page, if i click on it, the printed report is very too large (on two page). I presume that some settings are wrong in my report, the maximum width of the content never exceed 31 cm, i want the report in LandScape.

There are my settings for this report :

InteractiveSize : 11in; 8,5in

Margins : 1,5cm; 1,5cm; 1,5cm; 1,5cm

PageSize : 35cm; 25cm

Where's the problem when i use the print button directly into the ReportViewer ? Internet Explorer ? The printer drivers or settings ? The report settings ?

Sorry for my english...

What happens when you set InteractiveWidth to 35cm and InteractiveHeight to 25cm? InteractiveHeight/Width are used to generate soft page breaks with HTML and Excel formats.|||Same problem, i have deleted the report before deploying again with the updated report (InteractiveWidth to 35cm and InteractiveHeight to 25cm) and the report stay on 2 page in width.|||At what width does the report break across pages? This usually happens when the report body width exceeds the page width minus (left and right margins).|||ok i will change the width and height of the page. It seem's to be 27.5 X 21.5 cm, so i will reduce the width and the content will fit on one page. Thanks.

report model project question

I am having a problem trying to get the correct data on the report.
It is a typical schema where we have clients, doctors and both of those have
doctors. I am unable to show clients, client addresses and doctors on the
same report builder report. I can get 2 of those not 3.
any ideas? (is this a limitation of the product?)It all depends on the relation you set to be visible in the report model. So
you need to select the proper table and the keys.
Amarnath
"dave" wrote:
> I am having a problem trying to get the correct data on the report.
> It is a typical schema where we have clients, doctors and both of those have
> doctors. I am unable to show clients, client addresses and doctors on the
> same report builder report. I can get 2 of those not 3.
> any ideas? (is this a limitation of the product?)|||What do you mean "the relation you set to be visible"? How and where do you
specify visible options?
Sorry new to this.
thank you
dave
"Amarnath" wrote:
> It all depends on the relation you set to be visible in the report model. So
> you need to select the proper table and the keys.
> Amarnath
>
> "dave" wrote:
> > I am having a problem trying to get the correct data on the report.
> >
> > It is a typical schema where we have clients, doctors and both of those have
> > doctors. I am unable to show clients, client addresses and doctors on the
> > same report builder report. I can get 2 of those not 3.
> >
> > any ideas? (is this a limitation of the product?)|||Ok, Visible means nothing like enabling or disabling. but what I meant was,
setting the right relation, so that it can be selected for your reports from
report builder. If you dont have the relation or if the PK or FK is not
present in the tables, then that can't be selected, which you will come to
know when you go for setting the relation using the wizard.
Amarnath
"dave" wrote:
> What do you mean "the relation you set to be visible"? How and where do you
> specify visible options?
> Sorry new to this.
> thank you
> dave
> "Amarnath" wrote:
> > It all depends on the relation you set to be visible in the report model. So
> > you need to select the proper table and the keys.
> >
> > Amarnath
> >
> >
> > "dave" wrote:
> >
> > > I am having a problem trying to get the correct data on the report.
> > >
> > > It is a typical schema where we have clients, doctors and both of those have
> > > doctors. I am unable to show clients, client addresses and doctors on the
> > > same report builder report. I can get 2 of those not 3.
> > >
> > > any ideas? (is this a limitation of the product?)