Showing posts with label extra. Show all posts
Showing posts with label extra. Show all posts

Sunday, February 19, 2012

Blank pages in print preview for sub reports

Hi,

I have serveral subreports in main report. I have no problem print the orignal report but when I print them as subreport so get extra blank pages. I try to set the width of sub report in main report the max width value (19.6 cm width) without succeed. Any help would be appreiciate!

Hi,The extra blank page is coming for the Page Layout that you set for your report.Decrease the Left Margin and right margin percentage and try to move your Textbox fields bit closer to each other from right side and remove the extra space left on the right side of your report just draging it towards left.Hope this will solve your problem.|||Hi,In Sql report the preview take extra space for the extra width that you give to your report.So remove the extra width from your report.Do not increase the default width of the report by draging it towards right.Hope this will solve your problem.

Regards
Gelu

Thursday, February 16, 2012

Blank Page Between Exported Report

For some reason when I export the report from the web interface it exports
with an extra page between each page - it looks as if it has set the tables
that are in the report to 100% and then added an extra page because it
overflowed. However, this does not occur when I export from the Report
Manager or from the report Toolkit IDE.
Any ideas?
MikeTake a look at the previous post on this:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=4da98d7c-af5a-45c0-8cdf-dad47c6cb771
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Solomons" <mikesolo@.optonline.net> wrote in message
news:uVWw5ZKdEHA.1040@.TK2MSFTNGP10.phx.gbl...
> For some reason when I export the report from the web interface it exports
> with an extra page between each page - it looks as if it has set the
tables
> that are in the report to 100% and then added an extra page because it
> overflowed. However, this does not occur when I export from the Report
> Manager or from the report Toolkit IDE.
> Any ideas?
> Mike
>|||That didn't solve my problem - it's really odd - like I said in the IDE when
I export to PDF it fits fine, but when I use the Report Viewer ASP.NET
component from the web it adds an extra space - it also looks like the table
has been set to strectch 100% or something - any other ideas?
Mike
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:ulG1p0KdEHA.2268@.TK2MSFTNGP12.phx.gbl...
> Take a look at the previous post on this:
>
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=4da98d7c-af5a-45c0-8cdf-dad47c6cb771
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Michael Solomons" <mikesolo@.optonline.net> wrote in message
> news:uVWw5ZKdEHA.1040@.TK2MSFTNGP10.phx.gbl...
> > For some reason when I export the report from the web interface it
exports
> > with an extra page between each page - it looks as if it has set the
> tables
> > that are in the report to 100% and then added an extra page because it
> > overflowed. However, this does not occur when I export from the Report
> > Manager or from the report Toolkit IDE.
> >
> > Any ideas?
> >
> > Mike
> >
> >
>|||Encountered a similar problem where;
"Report Properties, Layout, Page width=8.5 Page height=11"
and
"Body Properties, Size, width=8.5, height=11"
Exported PDF's printed extra pages. After trying near everthing I could
think of I changed the height as follows;
"Body Properties, Size, width=8.5, height=10.99"
After that everything worked just fine.
Go figure, but it worked.
HTH,
Greg|||Nope - didn't work - anothe rodd thing though - I have an image which is
psuhed to the furthemost right side of the report - in the design view, it
is the item which is right most - when publish to the web and view it in the
report viewer, it is stilll all the way to the right, but the table seems to
go much further - as if that is the problem.
Also - keep in mind this isn't happening when I export to PDF from the
Report Manager interface, only when I export from the report viewer ASP.net
component from our website.
Odd...
Mike
"Greg Rowland" <greg@.waveltd.com> wrote in message
news:%23PeuB0LdEHA.3664@.TK2MSFTNGP12.phx.gbl...
> Encountered a similar problem where;
> "Report Properties, Layout, Page width=8.5 Page height=11"
> and
> "Body Properties, Size, width=8.5, height=11"
> Exported PDF's printed extra pages. After trying near everthing I could
> think of I changed the height as follows;
> "Body Properties, Size, width=8.5, height=10.99"
> After that everything worked just fine.
> Go figure, but it worked.
> HTH,
> Greg
>|||You may want to try exporting to a PDF or other format, just see what it
looks like. You may get some other ideas from that.
Good luck,
G