Page Setup

how could i make the report to be printed in "Landscape" mode in sql
reporting.Up at the top click on Report, then go to report properties. Go to the layout
tab and change the dimension to landscape view.
"Newsgroups" wrote:
> how could i make the report to be printed in "Landscape" mode in sql
> reporting.
>
>|||Well...i don't have dimension property in the report properties.Is there
any other way to goto this property.
Thanks.
"scraejtp" <scraejtp@.discussions.microsoft.com> wrote in message
news:09239F9B-99CE-4D13-9B14-49A54668D87B@.microsoft.com...
> Up at the top click on Report, then go to report properties. Go to the
> layout
> tab and change the dimension to landscape view.
> "Newsgroups" wrote:
>> how could i make the report to be printed in "Landscape" mode in sql
>> reporting.
>>|||Yes. Report Properties, Page Size, Height & Width. You have to set those
appropriately.
"Vijai" wrote:
> Well...i don't have dimension property in the report properties.Is there
> any other way to goto this property.
> Thanks.
> "scraejtp" <scraejtp@.discussions.microsoft.com> wrote in message
> news:09239F9B-99CE-4D13-9B14-49A54668D87B@.microsoft.com...
> > Up at the top click on Report, then go to report properties. Go to the
> > layout
> > tab and change the dimension to landscape view.
> >
> > "Newsgroups" wrote:
> >
> >> how could i make the report to be printed in "Landscape" mode in sql
> >> reporting.
> >>
> >>
> >>
>
>|||My understanding is that there is not a portrait or landscape setting. I
went to my Report Properties and on the layout tab, changed the Width and
Height properties (11 x 8.5).
Dennis
dennisp@.mayschem.com
Vijai wrote:
>Well...i don't have dimension property in the report properties.Is there
>any other way to goto this property.
>Thanks.
>> Up at the top click on Report, then go to report properties. Go to the
>> layout
>> tab and change the dimension to landscape view.
>> how could i make the report to be printed in "Landscape" mode in sql
>> reporting.|||That's correct. If the PageHeight is greater than the PageWidth, then it is
landscape, otherwise it is portrait. Reporting Services has no notion of the
rotation of the paper in the printer. It is up to the applications that
consume the output (Acrobat reader, print control) to determine the correct
printer settings to best render the specified page size.
More tips on pagination are summarized in Brian Welcker's blog article:
http://blogs.msdn.com/bwelcker/archive/2005/08/19/454043.aspx
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dennis P via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:536F2DDE89AA4@.SQLMonster.com...
> My understanding is that there is not a portrait or landscape setting. I
> went to my Report Properties and on the layout tab, changed the Width and
> Height properties (11 x 8.5).
> Dennis
> dennisp@.mayschem.com
> Vijai wrote:
>>Well...i don't have dimension property in the report properties.Is there
>>any other way to goto this property.
>>Thanks.
>> Up at the top click on Report, then go to report properties. Go to the
>> layout
>> tab and change the dimension to landscape view.
>> how could i make the report to be printed in "Landscape" mode in sql
>> reporting.

Page problem when exporting to pdf format.

I have a main report that contains charts and sub reports. When i see in preview mode it shows ok but when i export it in pdf format it does not show the way i want one relevant remains on previous page and other are gone to next page etc...

Another problem i am facing is if i make the page size greater than 7.5 it exports to one page blank and one page data.

One more thing i want to show table data vertically not horizontally due to restriction of 7.5 inches width.

Thanks in Advance

Muzaffar Ali

Hi Muzaffar,

Regarding report items getting shifted to next page in pdf and getting a blank page check this post -

http://blogs.msdn.com/chrisbal/archive/2006/08/10/694892.aspx

and what exactly you mean by showing data vertically, having header as rows and data as columns(then the number of columns will depend on the numbers of rows in dataset). I think you can try matrix to do that -http://blogs.msdn.com/chrishays/archive/2004/07/23/HorizontalTables.aspx