Showing posts with label exporting. Show all posts
Showing posts with label exporting. Show all posts

Thursday, February 16, 2012

Blank Page while exporting output to pdf

Hi,
I am exporting the output of Reporting Services to a pdf file. There is
always a blank page after every page. How can I remove it. Please help me
to resolve this.
Thanks.
AnujHi,
Check the properties of the objects on the report. In the layout section you
will find PageBreakAtEnd and PageBreakAtStart properties, make sure these are
set correctly or you may end up with blank pages where you don't want them.
Although this is unlikely to be the problem if the report displays fine in
HTML or other formats.
Hope it helps.
Ben Lee
"Anuj" wrote:
> Hi,
> I am exporting the output of Reporting Services to a pdf file. There is
> always a blank page after every page. How can I remove it. Please help me
> to resolve this.
> Thanks.
> Anuj|||I reckon that you're using too much space (across) on your report when
building it in the designer.
Say your report is regular portrait with width of 21cm and height of 29.7,
and 2.5cm left and right margin (you'll find these settings in the menu
option Report -> Report Properties -> Layout), check that the width of the
report area you're working with in your designer is not greater than the Page
Width - (Left Margin + Right Margin). If it is then you'll get those blank
pages.
"Anuj" wrote:
> Hi,
> I am exporting the output of Reporting Services to a pdf file. There is
> always a blank page after every page. How can I remove it. Please help me
> to resolve this.
> Thanks.
> Anuj

blank page between the main report and a subreport when exporting to PDF.

When I create a report that has imbedded subreports there are occasions
when I get a blank page between the main report and a subreport, this
occurs when exporting to PDF. From what I have observed; if a
subreport contains more rows of data than can fit on the same page as
the main report then a page break occurs a blank page is inserted and
then the subreport comes out on the subsequent page. This behavior will
not be repeated until the same condition occurs again.When the result
sets from the main report and subreport can fit on one page there is no
problem in exporting to PDF. In HTML format I get the report as
expected with no blank pages..PDF rendering is picky. You have to make sure that the body width does not
exceed, not even by 1 pixel, the (page width - (left margin + right
margin)).
--
Adrian M.
MCP
"Tom" <tom_barnard@.aotx.uscourts.gov> wrote in message
news:1112137446.997763.245800@.l41g2000cwc.googlegroups.com...
> When I create a report that has imbedded subreports there are occasions
> when I get a blank page between the main report and a subreport, this
> occurs when exporting to PDF. From what I have observed; if a
> subreport contains more rows of data than can fit on the same page as
> the main report then a page break occurs a blank page is inserted and
> then the subreport comes out on the subsequent page. This behavior will
> not be repeated until the same condition occurs again.When the result
> sets from the main report and subreport can fit on one page there is no
> problem in exporting to PDF. In HTML format I get the report as
> expected with no blank pages..
>|||Adrian,
We have checked the body width and found no problem there. Could
something else be causing this?
Thanks,
Tom|||This same situation happened to me. I found that two of the subreports had
matrices in them with extra white space to the right of the matrix. The extra
pages were eliminated when I removed this white space.
I hope this helps!
-Jason
"Tom" wrote:
> When I create a report that has imbedded subreports there are occasions
> when I get a blank page between the main report and a subreport, this
> occurs when exporting to PDF. From what I have observed; if a
> subreport contains more rows of data than can fit on the same page as
> the main report then a page break occurs a blank page is inserted and
> then the subreport comes out on the subsequent page. This behavior will
> not be repeated until the same condition occurs again.When the result
> sets from the main report and subreport can fit on one page there is no
> problem in exporting to PDF. In HTML format I get the report as
> expected with no blank pages..
>

Tuesday, February 14, 2012

Blank browser window when exporting to PDF

Hi:
Is there any way to avoid the blank browser window we see when exporting a
report to pdf?
I'll prefer to download the pdf on the same window to save it to the disk,
or to open it on another browser window using the acrobat reader plugin, but
what reporting services is doing is sending a request to download the report
on a new window, so after finishing the download, the user has to close this
window.
Any solutions?
Thanks,
Daniel Bello UrizarriI do not know what happens to you, here is what happend with my browser
(IE7.0, but it behaved the same when I used IE6):
1. In report viewer, choose export to PDF (or any other exporting format)
and click "Export";
2. A blank Browser window pops up followed by "File Download" dialog box
with button "Open", "Save", and "Cancel";
3.
a. If you choose "Open", the report is opened inside the new browser
window;
b. If you choose "Save" or "Cancel", the newly opened browser CLOSES
automatically. Of course, when you choose "Save", "Save File" dialog box
pops up while the blank browser window closes.
It must be something wrong with your browser/or setting being changes, such
as certain type of client-side script were disabled..., if it does not close
the blank window automatically.
"Daniel Bello" <dburizarri@.yahoo.es> wrote in message
news:eZ0bdYioHHA.5052@.TK2MSFTNGP04.phx.gbl...
> Hi:
> Is there any way to avoid the blank browser window we see when exporting a
> report to pdf?
> I'll prefer to download the pdf on the same window to save it to the disk,
> or to open it on another browser window using the acrobat reader plugin,
> but what reporting services is doing is sending a request to download the
> report on a new window, so after finishing the download, the user has to
> close this window.
> Any solutions?
> Thanks,
> Daniel Bello Urizarri
>|||Norman:
In my PC (and most of the others in my company) the browser window never
gets closed. If I click "Open", an instance of the Acrobat Reader standalone
application is started. If I click on "Save" or "Cancel", after the file
download dialog closes, the browser window remains there. I have IE 6 and
Acrobat Reader 7.
Do you have any ideas about where to look on the browser configuration to
change this behavior?
Thanks,
Daniel Bello Urizarri.
"Norman Yuan" <NotReal@.NotReal.not> wrote in message
news:%23WJPd6ioHHA.3880@.TK2MSFTNGP04.phx.gbl...
>I do not know what happens to you, here is what happend with my browser
>(IE7.0, but it behaved the same when I used IE6):
> 1. In report viewer, choose export to PDF (or any other exporting format)
> and click "Export";
> 2. A blank Browser window pops up followed by "File Download" dialog box
> with button "Open", "Save", and "Cancel";
> 3.
> a. If you choose "Open", the report is opened inside the new browser
> window;
> b. If you choose "Save" or "Cancel", the newly opened browser CLOSES
> automatically. Of course, when you choose "Save", "Save File" dialog box
> pops up while the blank browser window closes.
> It must be something wrong with your browser/or setting being changes,
> such as certain type of client-side script were disabled..., if it does
> not close the blank window automatically.
> "Daniel Bello" <dburizarri@.yahoo.es> wrote in message
> news:eZ0bdYioHHA.5052@.TK2MSFTNGP04.phx.gbl...
>> Hi:
>> Is there any way to avoid the blank browser window we see when exporting
>> a report to pdf?
>> I'll prefer to download the pdf on the same window to save it to the
>> disk, or to open it on another browser window using the acrobat reader
>> plugin, but what reporting services is doing is sending a request to
>> download the report on a new window, so after finishing the download, the
>> user has to close this window.
>> Any solutions?
>> Thanks,
>> Daniel Bello Urizarri
>

Black area where column is hidden in a table when exporting to PDF

I have a very strange problem. I'm using a table and I've
conditionally hidden columns before without any problems, but all of a
sudden, this one report I'm working on has a conditionally hidden
column in the table, but when the column is hidden and I export the
report as PDF, there is a solid black rectangle. It's not directly
where the column is hidden (the hidden column is the next to last
column to the right), but it's one column further to the
right...outside the table. So for instance, if all the columns were
shown in the table, the black rectangle would be to the right of the
table...where another column would go if I were to add one more on the
end. So with the hidden column, it basically goes...end of the table,
white space column, then black rectangle.
Anyone have any ideas what's up with this? I'm using reporting
services 2000 with SP2. Thanks.
RyanHi Ryan
[apologies if you have already received a mail through google groups from me]
did you ever find a solution to this issue, i am having exactly the same
problem of a black square being tacked on to the end of a table?
I'd be grateful if you do have a solution
thanks
"Ryan" wrote:
> I have a very strange problem. I'm using a table and I've
> conditionally hidden columns before without any problems, but all of a
> sudden, this one report I'm working on has a conditionally hidden
> column in the table, but when the column is hidden and I export the
> report as PDF, there is a solid black rectangle. It's not directly
> where the column is hidden (the hidden column is the next to last
> column to the right), but it's one column further to the
> right...outside the table. So for instance, if all the columns were
> shown in the table, the black rectangle would be to the right of the
> table...where another column would go if I were to add one more on the
> end. So with the hidden column, it basically goes...end of the table,
> white space column, then black rectangle.
> Anyone have any ideas what's up with this? I'm using reporting
> services 2000 with SP2. Thanks.
> Ryan
>