Extra page in print preview and .pdf

I have tried and tried to get my reports to quit printing an extra blank page but have been unsuccessful in my efforts.

I've set the margins in my report properties to (all in inches):

.75 - top

.5 - left, right, bottom

My page is landscape so the width is 11 and the height is 8.5

I've made sure my table is not wider than 9.5 - I've even made it as small as 8" wide to see if that was the problem . (I've done this for the header/footer as well.)

My report prints all on one page but I still get a 2nd page with header/footer information and a blank body.

I read a post that said to try making the right margin 0 - that didn't work either.

Additional information: I just saw a post suggesting borders around everything to see what might be bleeding onto a 2nd page.

One page 1, the full borders are there, so nothing should be bleeding onto page 2. However, when I go to page 2, there are no borders around the header, but the left edge shows on the right side of the page. Also, the footer is missing it's left edge, but the right shows. I've tried making both the header and footer smaller, as well as moving them further right - still get the exact issue.

I'm using the reporting services for Visual Studio .NET 2003.

Any help would be greatly appreciated! Thanks!

Well, turns out it was the layout. Although my report elements were the right size, the layout was too big, forcing the margins over.|||

It is COOL that your posted your results!

|||

Hello - just a general comment!

I have eliminated the capability to export to PDF within RS in that PDF NEVER renders any ledgeable characters in my part of the world which includes:

Thailand, Cambodia, Laos, Mayamar (Burma), Vietnam, Pakistan and Tibet and this also includes any dialect in Mandarin!

We just stick to a TIF and everything is always perfect -

|||

When you say your layout was too big, what did you set it too?

Just curious, since I was having an issue similar to yours although I might not have worded it as clearly

http://forums.asp.net/1139722/ShowPost.aspx

Thanks

sql

Extra Page in Adobe Export

Using SRS SP2 and Adobe 7.0.2
When my report renders in the preview pane it it limited to one page but
when exported to Adobe it prints an extra page. The report has Page
Header/Body/Page Footer sections.
Is this a bug or am I missing something in the config?
ThanksI have the same problem. Would like to know if there is a solution.
"Mike Harbinger" wrote:
> Using SRS SP2 and Adobe 7.0.2
> When my report renders in the preview pane it it limited to one page but
> when exported to Adobe it prints an extra page. The report has Page
> Header/Body/Page Footer sections.
> Is this a bug or am I missing something in the config?
> Thanks
>
>|||make sure there is no extra space after the table and chart
"Mike Harbinger" wrote:
> Using SRS SP2 and Adobe 7.0.2
> When my report renders in the preview pane it it limited to one page but
> when exported to Adobe it prints an extra page. The report has Page
> Header/Body/Page Footer sections.
> Is this a bug or am I missing something in the config?
> Thanks
>
>|||That was it! I had moved a field in from the right margin and after
tightening it up the extra page was gone.
Many thanks!
"RP" <RP@.discussions.microsoft.com> wrote in message
news:94E1BCC1-F540-46DE-95F7-56F242097113@.microsoft.com...
> make sure there is no extra space after the table and chart
> "Mike Harbinger" wrote:
>> Using SRS SP2 and Adobe 7.0.2
>> When my report renders in the preview pane it it limited to one page but
>> when exported to Adobe it prints an extra page. The report has Page
>> Header/Body/Page Footer sections.
>> Is this a bug or am I missing something in the config?
>> Thanks
>>

Exporting to Excel from Preview Tab

I designed a report and from Preview tab, i exported it to Excel format and saved. I sent the Xls file to others, but when they opened it, it is displaying the Metadata info of the file. any idea what is going on?

In my report i have a table, and above it i have a bunch of textboxes which serves as a heading for groups of columns in the table. when i preview it is fine. But Exported to excel, some of these textboxes are wrapping to the next line. any idea what is going on? (I tried aligning all the textboxes)

thanks.

Which version / release of the product are you using? The initial release of RS 2000 did not support older versions of Excel. You can install the second service pack or move to RS 2005.

As for the export, make sure that you are putting the textboxes inside the table header, not as textboxes above the table. This will help you align columns.

Exporting to Excel from Preview Tab

I designed a report and from Preview tab, i exported it to Excel format and
saved. I sent the Xls file to others, but when they opened it, it is
displaying the Metadata info of the file. any idea what is going on?
In my report i have a table, and above it i have a bunch of textboxes which
serves as a heading for groups of columns in the table. when i preview it is
fine. But Exported to excel, some of these textboxes are wrapping to the next
line. any idea what is going on? (I tried aligning all the textboxes)
thanks.Don't know about the second issue but the first issue sounds like you have
not installed either SP1 or SP2. RS initially did not support Excel 2000 or
Excel 97. Starting with SP1 they added support for those version. My guess
is the users you sent the file to are on Excel 2000 or earlier.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Giya" <Giya@.discussions.microsoft.com> wrote in message
news:8B2D6E73-9824-40CC-90DB-5BAEFEFCEA82@.microsoft.com...
>I designed a report and from Preview tab, i exported it to Excel format and
> saved. I sent the Xls file to others, but when they opened it, it is
> displaying the Metadata info of the file. any idea what is going on?
> In my report i have a table, and above it i have a bunch of textboxes
> which
> serves as a heading for groups of columns in the table. when i preview it
> is
> fine. But Exported to excel, some of these textboxes are wrapping to the
> next
> line. any idea what is going on? (I tried aligning all the textboxes)
> thanks.|||thanks.
"Bruce L-C [MVP]" wrote:
> Don't know about the second issue but the first issue sounds like you have
> not installed either SP1 or SP2. RS initially did not support Excel 2000 or
> Excel 97. Starting with SP1 they added support for those version. My guess
> is the users you sent the file to are on Excel 2000 or earlier.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Giya" <Giya@.discussions.microsoft.com> wrote in message
> news:8B2D6E73-9824-40CC-90DB-5BAEFEFCEA82@.microsoft.com...
> >I designed a report and from Preview tab, i exported it to Excel format and
> > saved. I sent the Xls file to others, but when they opened it, it is
> > displaying the Metadata info of the file. any idea what is going on?
> >
> > In my report i have a table, and above it i have a bunch of textboxes
> > which
> > serves as a heading for groups of columns in the table. when i preview it
> > is
> > fine. But Exported to excel, some of these textboxes are wrapping to the
> > next
> > line. any idea what is going on? (I tried aligning all the textboxes)
> >
> > thanks.
>
>