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

I also have the same problem. When I export the report out in pdf format,
there is an extra page.
I am running RSR2 and adobe 7.0.2
Is there any solution to this?yes,
Make sure there is no extra space in the report body after a table and chart
"qjlee" wrote:
> I also have the same problem. When I export the report out in pdf format,
> there is an extra page.
> I am running RSR2 and adobe 7.0.2
> Is there any solution to this?

Extra empty pages in PDF report

Report looks great in Visual studio and in a Browser, but when I convert it
to pdf for printing, I am getting extra pages after every good page with just
a header printed on those pages.
I tried decrease the size of the report and make sure that it fits into 8
1/2 x 11 inches, but it did not help.
I still have those annoying empty pages in the printed report.
Any other suggestions on how can I fix it?
Thank you.Simon if are you having problem with client side printing then you will want
to try the following.
Try setting body width to 8.46 if you are using letter/portrait. If you are
using letter/landscape then set the width to 10.96.
I hope that helps.
This is an issue Microsorft is now aware of.
"Simon Gold" wrote:
> Report looks great in Visual studio and in a Browser, but when I convert it
> to pdf for printing, I am getting extra pages after every good page with just
> a header printed on those pages.
> I tried decrease the size of the report and make sure that it fits into 8
> 1/2 x 11 inches, but it did not help.
> I still have those annoying empty pages in the printed report.
> Any other suggestions on how can I fix it?
> Thank you.
>|||Thanks Kevin. I figured it out about one hour before I got your e-mail. :-)
"Kevin Weir" wrote:
> Simon if are you having problem with client side printing then you will want
> to try the following.
> Try setting body width to 8.46 if you are using letter/portrait. If you are
> using letter/landscape then set the width to 10.96.
> I hope that helps.
> This is an issue Microsorft is now aware of.
> "Simon Gold" wrote:
> > Report looks great in Visual studio and in a Browser, but when I convert it
> > to pdf for printing, I am getting extra pages after every good page with just
> > a header printed on those pages.
> > I tried decrease the size of the report and make sure that it fits into 8
> > 1/2 x 11 inches, but it did not help.
> > I still have those annoying empty pages in the printed report.
> > Any other suggestions on how can I fix it?
> > Thank you.
> >

extra blank pages when exported to pdf

anyone know why I'm getting an extra blank page after every page when I
export to PDF?I did notice something weird ... I click on the body of the report and try
to change the width 11(w) x 8.5 (h) (landscape report) and it always changes
back to 11.125. I can't get it to change. any ideas?
btw, thank you for the quick reply. I am in a rush for this.
"Mike Collins" <MikeCollins@.discussions.microsoft.com> wrote in message
news:F73E92CC-0FBD-47CE-A284-554CE8FE5118@.microsoft.com...
> Course, I did not answer your question...directly. You are getting blank
> pages because something on your report (report width, a long field) is
> causing this and you are not seeing it by looking at the preview tab.
> "Emil" wrote:
> > anyone know why I'm getting an extra blank page after every page when I
> > export to PDF?
> >
> >
> >|||Please make sure that your report is setup as follows:
(Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=Body.Width
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Emil" <laserview@.hotmail.com> wrote in message
news:e4r37RuhEHA.3016@.tk2msftngp13.phx.gbl...
> anyone know why I'm getting an extra blank page after every page when I
> export to PDF?
>|||I can't change my body width
(Report.PageWidth - Report.LeftMargin - Report.Right Margin) >= Body.Width
11-.25-.25 = 10.5
Body.width = 11.125
No mater what I do I can't change the body width. Always goes back to 11.125
Any ideas?
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:%23XvlCquhEHA.2340@.TK2MSFTNGP11.phx.gbl...
> Please make sure that your report is setup as follows:
> (Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=> Body.Width
>
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Emil" <laserview@.hotmail.com> wrote in message
> news:e4r37RuhEHA.3016@.tk2msftngp13.phx.gbl...
> > anyone know why I'm getting an extra blank page after every page when I
> > export to PDF?
> >
> >
>|||Make sure u have all the size of reportitems to the <= body width u want.If u
are not able to change the body size means these is
something(textbox,rectangle table etc...)that has width larger that the width
of the body u are trying to set....
blank pages are usually when the following is not true....for the width
Report.PageWidth >= Report.LeftMargin + Report.Right Margin + Body.Width
I hope this helps...
"Emil" wrote:
> I can't change my body width
>
> (Report.PageWidth - Report.LeftMargin - Report.Right Margin) >= Body.Width
> 11-.25-.25 = 10.5
> Body.width = 11.125
> No mater what I do I can't change the body width. Always goes back to 11.125
> Any ideas?
>
>
> "Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
> news:%23XvlCquhEHA.2340@.TK2MSFTNGP11.phx.gbl...
> > Please make sure that your report is setup as follows:
> >
> > (Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=> > Body.Width
> >
> >
> > --
> > Bruce Johnson [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Emil" <laserview@.hotmail.com> wrote in message
> > news:e4r37RuhEHA.3016@.tk2msftngp13.phx.gbl...
> > > anyone know why I'm getting an extra blank page after every page when I
> > > export to PDF?
> > >
> > >
> >
> >
>
>|||I have a similiar problem - blank pages being generated when exporting
to PDF. However, I have checked my body(9.9in) vs report page width
(11in) with .25 inch left and rt margins. I think the problem is
related the way RS computes the vertical requirements of outputting a
report -- I have many conditionally hidden lines in a table group. If
I set the List height (4in) just large enough to contain the table, I
only get one page rendered when in fact two pages should be rendered to
PDF. However, if I increse the List height to (4.1in) I generate a
report of 4 pages for what should be a 2-page report with pages 2 and 4
blank.
Does anyone else have this same issue?
Dennis|||I am having the same problem - see below "DD" posting. Have you found
a solution to your problem?|||I was having the same problem (exports to PDF fine from VS IDE, but get extra
pages when I export to PDF from Report Manager). I was able to remedy the
problem by installing service pack 1 for sql reporting services.
"DD" wrote:
> I am having the same problem - see below "DD" posting. Have you found
> a solution to your problem?
>|||I was having the same problem, my fix was strange. In my report I have
detailed lines in which I wanted spaces to separate each row, to do this i
added an extra 2 detailed lines with no data fields on them, there height was
0.3cm, when I removed these emtpy lines or increased the height to 0.5cm the
problem went away.
"Jonathan Gordon" wrote:
> I was having the same problem (exports to PDF fine from VS IDE, but get extra
> pages when I export to PDF from Report Manager). I was able to remedy the
> problem by installing service pack 1 for sql reporting services.
>
>
> "DD" wrote:
> > I am having the same problem - see below "DD" posting. Have you found
> > a solution to your problem?
> >
> >sql

expoting data from reporting srvcs to PDF

Hi,
I am trying to export a report to pdf and it does not keep all teh
columsn in the same page. I could not find any options to specify. Has
faced the same problem?
JaideepCheck the margins in the Report properties, layout tab. Also the page width
and Page height. FYI for Portrait Page width must be 21cm and Height 29,7cm.
For landscape the opposite.
"jai" wrote:
> Hi,
> I am trying to export a report to pdf and it does not keep all teh
> columsn in the same page. I could not find any options to specify. Has
> faced the same problem?
> Jaideep
>

exporting to pdf without generating report

hi
I am calling a report from asp and if i click the button the report has to
be be stored in a specified location given by the user and report window
should not be generated.
It is very urgent please help me to solve the problem
thanks
terranceHi,
If you are using URL access then try this.
e.g.
http://servername/reportserver?/Sales/YearlySalesSummary&rs:Format=PDF&rs:Command=Render
If you are in the program, you need to change the response.contenttype as
well to "Application/PDF"
Amarnath
"ter" wrote:
> hi
> I am calling a report from asp and if i click the button the report has to
> be be stored in a specified location given by the user and report window
> should not be generated.
> It is very urgent please help me to solve the problem
> thanks
> terrance
>

Exporting To PDF With Chinese/Jap Characters

Hi all!I have created a report that may display Chinese, Korean and Japanese characters. Everything is fine on the report itself when rendered in the browser, all the characters are showing as it should be, but when I try to export it to pdf, all these characters turned into question marks ??.

I've tried installing Adobe Asian pack, but still I can't make these character shows up.Can anyone shed light on this? I'm doing a local report only BTW. Would there be any effect if I'll do it as a server report?

Anything that could get me started would be greatly appreciated.Thanks in advance.

I've had these kind of issues to when I used what is supposed to be a unicode font, Arial. After switching to a different unicode font, MS Gothic, everything printed correctly. Try that.

Eric

|||:O that's weird, but I'll try it tomorrow in the office|||

I've tried MS Gothic, the chinese character showed correctly but for Jap, Korean and Thai it didn't :( So tried other fonts and the closest that can show Chinese, Jap & Korean is the font Batang, though it cannot display Thai :(

I've googled endlessly post on different forums but still got any clear answer as to if this is a limitation on SSRS or what.

|||

Sorry I can't help you any more. I'm still pretty new to unicode fonts.

Eri

|||

I'm having the same exact issue. I tried using Batang as a font but it still will not show up properly in pdf. have you found a fix for this?

|||

No prob Eric. Actually you already helped me when you said try using other fonts. It will be my temporary fix for the mean time.

@.user

I dunno if the Asian Language pack from adobe would help. I have installed it before I tried changing the font style on the report.

Exporting to PDF through web service produses blank pages

Hi all,
I am exporting to PDF through web service a report that contains matrix.
I get almost every second page a blank page.
The same report when exported to PDF by the report manager does not contain
blank pages.
Is it a bug, Is there any work around
Thanks,
YuvalNobody is going to answer your question. I've been asking it for days. I
emailed all those Microsoft bloggers. I posted here. Nothing. I did
enough research that I am conviced Microsoft knows about the issue.
Note they claim you can find known bugs here:
http://msdn.microsoft.com/bugs/
But you can only find bugs they want you to find (ie ones they know how to
fix). If you seach for reporting services, you will find 0 known bugs.
The problem is that the List containing the matrix is growing so much that
the report won't fit on one page. So it prints two pages. You can see this
by changing the background colour of the List that contains the matrix.
When you run it, you will find the coloured list extends onto the 'blank'
page.
I haven't seen a fix yet. You can shrink your matrix so that the list won't
grow onto the next page. But that's not usually an acceptable fix, because
it means leaving about a third of the page blank.
Seems to me there's no acceptable way to print a matrix report. This issue
affects the tiff, and I found a different issue in Excel.
Scott
"Yuval Rabinovitz" <yvlrb@.netvision.net.il> wrote in message
news:e66FusBkEHA.3848@.tk2msftngp13.phx.gbl...
> Hi all,
> I am exporting to PDF through web service a report that contains matrix.
> I get almost every second page a blank page.
> The same report when exported to PDF by the report manager does not
contain
> blank pages.
> Is it a bug, Is there any work around
> Thanks,
> Yuval
>|||I did eventaully get a reponse from Microsoft. Everyone was quite friendly,
but it took a while to find the person who knew the answer.
If you are not using subtotals in your matrix, you might try "KB article
875518 is FIX: Width of the list that contains a matrix grows unexpectedly
when exported to PDF." This hotfix (only available by calling support)
didn't solve my problem.
If you are using subtotals in your matrix (like I was), this is the answer.
This response was from Sarah Parra:
"
The problem is that the list always extends a certain amount to the right
and bottom of the matrix, and the amount that it extends is based directly
on how wide (for column totals) or tall (for row totals) the total textbox
is. If you look at your report in the designer, in the bottom right corner,
under the totals boxes, there is a gray/brown empty space. That space is
effectively how much extra list you will see in the final output. We take
the size of the matrix to be the actual size that you see, minus the totals
boxes. That means that the list effectively looks like it is that much
bigger than the matrix (instead of being the exact same size). When the
rendering happens, it then adds that much padding to the right and below the
actual matrix.
This is a bug as well, it's just a different bug from the one described in
the article/hotfix. :) This one does have a fairly simple workaround. You
need to resize the list to be the size of the matrix, minus the size of the
totals columns/rows. The designer will not allow you to size the list
smaller than the matrix (which includes the totals), but you can do this
manually in the rdl. The following are the instructions I sent to another
customer on a sample report he had provided, so the sizes and line number
will not match up for you:
(1) Find the size of the column total box. You can just click on it and look
at the Width property. It's 0.875in.
(2) In the Solution Explorer, right click the .rdl file and select View
Code. In the code, find the Width definition for the List itself. You'll see
it on line 78, and it looks like this : <Width>5.875in</Width>. Change that
to that value, minus the size of the total column, .875. So just make it
5.0in, or you can make it a little bigger if you want some extra space
displayed to the right of the matrix itself. In the designer at this point,
it will look like the Total box is gone, but it's still there. You can do
the same thing for the row totals if you want. You will probably want to do
this, because if you have a situation where the matrix should end at the
very bottom of the page, you may still get an extra page if the extended
list height would force it.
(3) Preview and render the report. You should no longer see any blank pages.
"
"Scott Stonehouse" <scott@.mphec.ca> wrote in message
news:%23N3MVjFkEHA.2812@.tk2msftngp13.phx.gbl...
> Nobody is going to answer your question. I've been asking it for days. I
> emailed all those Microsoft bloggers. I posted here. Nothing. I did
> enough research that I am conviced Microsoft knows about the issue.
> Note they claim you can find known bugs here:
> http://msdn.microsoft.com/bugs/
> But you can only find bugs they want you to find (ie ones they know how to
> fix). If you seach for reporting services, you will find 0 known bugs.
> The problem is that the List containing the matrix is growing so much that
> the report won't fit on one page. So it prints two pages. You can see
this
> by changing the background colour of the List that contains the matrix.
> When you run it, you will find the coloured list extends onto the 'blank'
> page.
> I haven't seen a fix yet. You can shrink your matrix so that the list
won't
> grow onto the next page. But that's not usually an acceptable fix,
because
> it means leaving about a third of the page blank.
> Seems to me there's no acceptable way to print a matrix report. This
issue
> affects the tiff, and I found a different issue in Excel.
> Scott
>
> "Yuval Rabinovitz" <yvlrb@.netvision.net.il> wrote in message
> news:e66FusBkEHA.3848@.tk2msftngp13.phx.gbl...
> > Hi all,
> >
> > I am exporting to PDF through web service a report that contains matrix.
> > I get almost every second page a blank page.
> > The same report when exported to PDF by the report manager does not
> contain
> > blank pages.
> >
> > Is it a bug, Is there any work around
> >
> > Thanks,
> > Yuval
> >
> >
>

Exporting to PDF in Java with web interface issue

Hi, thanks for taking the time to take a look at this.

As you can read from the title, I'm trying to export a report to pdf from a thick java client. My connection string is:
"http://10.0.1.36/ReportServer/?/Invoice1/Invoice&assetNbr=14
&invoiceId=061000002&rs:Command=Render:&rs:Format=PDF&rc:Toolbar=false"
(I just added the toolbar=false part, and it didn't fix the problem)

After getting the datastream I just throw it into a file and it works fine... Until I add an image to my report. I don't get any errors in my program, but when I try to open up the pdf itself I get the error: "There was an error opening this document. The file is damaged and could not be repaired."

What confuses me is that if I enter the connection string in ie it comes up and asks me what I should do with the pdf and that one has the image in it with not problems.

To summarize if I've been unclear:
Export via ie no image: good
Export via ie with image: good
Export via java no image: good
Export via java with image: error

Does anyone have an idea why this would occur? I have an Execution Account set up in Reporting Services Configuration Manager and I have IIS anonymous access set up to use my local administrator account so I don't think accessing the image is an issue. But I'm definitely no server/admin expert so if there are any such issues could be causing this don't assume I've got that set up properly.

Thanks, JeffAre you certain that you are writing the file correctly from your Java app?|||I'm pretty sure I am. The whole setup works and exports correctly when connecting to a report that doesn't have an image embedded in it.

Also, is there any way to access the reports other than the web interface from java? I've only seen implementations of this in C# and vb.net|||

You should be able to use any Java SOAP toolkit (such as JAX).

FWIW, perhaps the report w/the image is larger, and exposing some bug in your Java code? Maybe you should compare the byte count of the IE output to what you are getting w/Java.

|||My face is red, it just was that I was stopping the fileout one byte too early... Thanks a bunch for your help.

If I can ask one more favor of you, I'm not familiar with the components involved in using SOAP so if you could give me a little overview that would give me someplace to start reading about it I'd really appreciate it.|||

I've never used any of SOAP toolkits for Java... so I can't really help you out there. This showed some links which may be of interest to you:

http://search.live.com/results.aspx?q=java+SOAP+toolkit&mkt=en-US&form=QBRE

Exporting to PDF and TIFF

Hello All.
I have a report that uses a table. The table is designed to have a page
break after each new table. When I view the report in the designer preview,
it works fine by putting each new table on a new page, and generating the
document map. When I export from preview to PDF, TIFF and Excel, this works
fine too.
When I deploy it to my Report Server, accessing the report via the Report
Manager, it displays as above with no problems. When I export to Excel, this
is fine too. When I export to PDF or TIFF, it only shows the first page,
with one item in the document map.
Anyone have any ideas? If more info is needed, let me know and I will
provide if possible.
Thanks in advance.managed to fix it - just changed the page break to be at start of table and
it worked!!'
"comet61" wrote:
> Hello All.
> I have a report that uses a table. The table is designed to have a page
> break after each new table. When I view the report in the designer preview,
> it works fine by putting each new table on a new page, and generating the
> document map. When I export from preview to PDF, TIFF and Excel, this works
> fine too.
> When I deploy it to my Report Server, accessing the report via the Report
> Manager, it displays as above with no problems. When I export to Excel, this
> is fine too. When I export to PDF or TIFF, it only shows the first page,
> with one item in the document map.
> Anyone have any ideas? If more info is needed, let me know and I will
> provide if possible.
> Thanks in advance.

Exporting to PDF

I have some rows in a table that are visible based on a Condition. The report renders fine in HTML. After exporting the report to PDF, there are some white spaces appearing at the end of the report. Even after the summary row. ( There is another sub report starts after that report). If I take the hidden condition then the next report appears after this report. No white space.

Suggestions Please?

Thanks again!

Interestingly If you set the height of all your subreports to the same value then the space between the reports are disappearing.

|||

What if you were to select the "Can decrease to accomodate contents" checkbox in the cell that holds the subreport?

HTH

Richard

|||

No. That didn't work. I have changed for each cell in the Sub-Report and for the Cells that Sub report placed. Again it was not a problem with the Report Viewer only if you export to PDF.

Either through the Code or through Report Viewer PDF Export.

Exporting to PDF

hi, i'm exporting a crystal report to PDF...it should be pretty straight forward right?

in my crosstab objects, i have a double underline for a field, when i export it PDF, it shows up as 1 thick line....is this just a bug within crystal? or am i doing something wrong...

i simply go to file>export>export report, then choose Acrobat PDF

i've attached a picture of my example...

this isnt a HUGE problem, because it still works in my crystal version, but having the PDF version look good is very usefulHave you tried cutePDF? Install it and change printer to cutePDF. Don't blame me though if it still doesn't work. It might be a waste of your time but it's just something I'd try if desperate enough.|||Is there a resolution setting for the Crystal PDF printer? Might be at 150dpi|||i tried all kinds of resolutions for the PDF export...1500, 2500, 4000 (max) and it still comes out the same in the PDF...ne more suggestions?

exporting to pdf

When we export a report as a PDF and if there are multiple columns in the
report, all the columns in the report do not fit in one single page in the
exported PDF. We would ideally like to accommodate all the columns within one
single page. The only way we could do this today is to reduce the width of
the columns , but this causes the Report to loose its clarity and readability.
Thanks in advance,Go to the report menu item and open "report properties". On the "layout"
tab, increase the "page width" property accordingly. Re-deploy the report,
run and export.
"Chandra" wrote:
> When we export a report as a PDF and if there are multiple columns in the
> report, all the columns in the report do not fit in one single page in the
> exported PDF. We would ideally like to accommodate all the columns within one
> single page. The only way we could do this today is to reduce the width of
> the columns , but this causes the Report to loose its clarity and readability.
> Thanks in advance,
>

exporting to pdf

I have a report I am trying to export to PDF but it is
only showing one page and then it won't turn landscape. I
have set up the page as landscape on the report page and
also when I open the report.
and I still only get one page no it is about 4 or 5 long.Did you set up proper PageSize and margins for the Report?
Also, did you setup Size for the Body which is smaller than Report (PageSize - Margin)?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lee Hopkins" <ljhopkins_1@.yahoo.com> wrote in message
news:218901c49a89$09ee0f50$a501280a@.phx.gbl...
>I have a report I am trying to export to PDF but it is
> only showing one page and then it won't turn landscape. I
> have set up the page as landscape on the report page and
> also when I open the report.
> and I still only get one page no it is about 4 or 5 long.|||Sorry to sound stupid but where are these settings'
for the margin, pagesize.
the body is ok for landscape
>--Original Message--
>Did you set up proper PageSize and margins for the Report?
>Also, did you setup Size for the Body which is smaller
than Report (PageSize - Margin)?
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Lee Hopkins" <ljhopkins_1@.yahoo.com> wrote in message
>news:218901c49a89$09ee0f50$a501280a@.phx.gbl...
>>I have a report I am trying to export to PDF but it is
>> only showing one page and then it won't turn landscape.
I
>> have set up the page as landscape on the report page and
>> also when I open the report.
>> and I still only get one page no it is about 4 or 5
long.
>
>.
>so|||Properties window. From the drop down at the top, select Report and Body respectively. Set the
settings as per my prior post.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lee Hopkins" <ljhopkins_1@.yahoo.com> wrote in message
news:231801c49a9f$0793f0b0$a501280a@.phx.gbl...
> Sorry to sound stupid but where are these settings'
> for the margin, pagesize.
> the body is ok for landscape
>>--Original Message--
>>Did you set up proper PageSize and margins for the Report?
>>Also, did you setup Size for the Body which is smaller
> than Report (PageSize - Margin)?
>>--
>>Tibor Karaszi, SQL Server MVP
>>http://www.karaszi.com/sqlserver/default.asp
>>http://www.solidqualitylearning.com/
>>
>>"Lee Hopkins" <ljhopkins_1@.yahoo.com> wrote in message
>>news:218901c49a89$09ee0f50$a501280a@.phx.gbl...
>>I have a report I am trying to export to PDF but it is
>> only showing one page and then it won't turn landscape.
> I
>> have set up the page as landscape on the report page and
>> also when I open the report.
>> and I still only get one page no it is about 4 or 5
> long.
>>
>>.
>>so

Exporting to PDF

Hello - I have a client that is exporting to PDF and the export fails. I
have seen other posts running into the same problem, something to do with PDF
6 writer. Does Microsoft have a workaround or an update to this?
Thanks in advance.Please supply more information about what you are seeing, such as, error
messages, reproduction steps, etc.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"comet61" <comet61@.discussions.microsoft.com> wrote in message
news:22E13F24-ECA7-4A08-8194-E7A1318122B6@.microsoft.com...
> Hello - I have a client that is exporting to PDF and the export fails. I
> have seen other posts running into the same problem, something to do with
> PDF
> 6 writer. Does Microsoft have a workaround or an update to this?
> Thanks in advance.|||The client is trying to download a matrix style report into a pdf. They have
Adobe 6 Professional. The report is around 150 pages and 800 Kb.
We are able to download via Adobe 6 reader, but have numerous formatting
problems within.
"Bruce Johnson [MSFT]" wrote:
> Please supply more information about what you are seeing, such as, error
> messages, reproduction steps, etc.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "comet61" <comet61@.discussions.microsoft.com> wrote in message
> news:22E13F24-ECA7-4A08-8194-E7A1318122B6@.microsoft.com...
> > Hello - I have a client that is exporting to PDF and the export fails. I
> > have seen other posts running into the same problem, something to do with
> > PDF
> > 6 writer. Does Microsoft have a workaround or an update to this?
> >
> > Thanks in advance.
>
>|||Can you send me, directly to me, some screen shots or the PDF that
demonstrates the problem.
I don't think I will be able to help you unless I can see the what is
happening.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"comet61" <comet61@.discussions.microsoft.com> wrote in message
news:7DB3BF3E-AB80-4ED7-BAA7-925ADDCFB351@.microsoft.com...
> The client is trying to download a matrix style report into a pdf. They
> have
> Adobe 6 Professional. The report is around 150 pages and 800 Kb.
> We are able to download via Adobe 6 reader, but have numerous formatting
> problems within.
> "Bruce Johnson [MSFT]" wrote:
>> Please supply more information about what you are seeing, such as, error
>> messages, reproduction steps, etc.
>> --
>> Bruce Johnson [MSFT]
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "comet61" <comet61@.discussions.microsoft.com> wrote in message
>> news:22E13F24-ECA7-4A08-8194-E7A1318122B6@.microsoft.com...
>> > Hello - I have a client that is exporting to PDF and the export fails.
>> > I
>> > have seen other posts running into the same problem, something to do
>> > with
>> > PDF
>> > 6 writer. Does Microsoft have a workaround or an update to this?
>> >
>> > Thanks in advance.
>>|||I sent the file to your account. Let me know what you find out.
"Bruce Johnson [MSFT]" wrote:
> Can you send me, directly to me, some screen shots or the PDF that
> demonstrates the problem.
> I don't think I will be able to help you unless I can see the what is
> happening.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "comet61" <comet61@.discussions.microsoft.com> wrote in message
> news:7DB3BF3E-AB80-4ED7-BAA7-925ADDCFB351@.microsoft.com...
> > The client is trying to download a matrix style report into a pdf. They
> > have
> > Adobe 6 Professional. The report is around 150 pages and 800 Kb.
> >
> > We are able to download via Adobe 6 reader, but have numerous formatting
> > problems within.
> >
> > "Bruce Johnson [MSFT]" wrote:
> >
> >> Please supply more information about what you are seeing, such as, error
> >> messages, reproduction steps, etc.
> >>
> >> --
> >> Bruce Johnson [MSFT]
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "comet61" <comet61@.discussions.microsoft.com> wrote in message
> >> news:22E13F24-ECA7-4A08-8194-E7A1318122B6@.microsoft.com...
> >> > Hello - I have a client that is exporting to PDF and the export fails.
> >> > I
> >> > have seen other posts running into the same problem, something to do
> >> > with
> >> > PDF
> >> > 6 writer. Does Microsoft have a workaround or an update to this?
> >> >
> >> > Thanks in advance.
> >>
> >>
> >>
>
>|||this is a known microsoft bug is what i found out
"comet61" wrote:
> I sent the file to your account. Let me know what you find out.
> "Bruce Johnson [MSFT]" wrote:
> > Can you send me, directly to me, some screen shots or the PDF that
> > demonstrates the problem.
> > I don't think I will be able to help you unless I can see the what is
> > happening.
> >
> > --
> > Bruce Johnson [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "comet61" <comet61@.discussions.microsoft.com> wrote in message
> > news:7DB3BF3E-AB80-4ED7-BAA7-925ADDCFB351@.microsoft.com...
> > > The client is trying to download a matrix style report into a pdf. They
> > > have
> > > Adobe 6 Professional. The report is around 150 pages and 800 Kb.
> > >
> > > We are able to download via Adobe 6 reader, but have numerous formatting
> > > problems within.
> > >
> > > "Bruce Johnson [MSFT]" wrote:
> > >
> > >> Please supply more information about what you are seeing, such as, error
> > >> messages, reproduction steps, etc.
> > >>
> > >> --
> > >> Bruce Johnson [MSFT]
> > >> Microsoft SQL Server Reporting Services
> > >>
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >> rights.
> > >>
> > >>
> > >> "comet61" <comet61@.discussions.microsoft.com> wrote in message
> > >> news:22E13F24-ECA7-4A08-8194-E7A1318122B6@.microsoft.com...
> > >> > Hello - I have a client that is exporting to PDF and the export fails.
> > >> > I
> > >> > have seen other posts running into the same problem, something to do
> > >> > with
> > >> > PDF
> > >> > 6 writer. Does Microsoft have a workaround or an update to this?
> > >> >
> > >> > Thanks in advance.
> > >>
> > >>
> > >>
> >
> >
> >

Exporting to HTML

Hi!
My client wants to send reports as emails. They don't want' PDF
attachement. HTML seem to be the best way for that.
I'm using Microsoft.Reporting.WinForms
and
LocalReport.Render
I can't seem to find any other formats then Excel or PDF. But
Microsoft reporting does reports for web as well. Is there any way to
get HTML out of local report?
Thanks!This is exactly problem I'm having:
http://msmvps.com/blogs/theproblemsolver/archive/2006/07/19/105216.aspx

Exporting to Excel error

I am having a problem exporting a report to Excel. The report has about 1000
records. I can export it to a pdf fine, but not Excel. I get an "Index was
outside the bounds of the array" error message.
thank you for any help possible.Are you still having this issue or it's solved? Can you tell me what you did
to fix the problem? Because I am having the same problem too. Thanks.
"PatNUFC" wrote:
> I am having a problem exporting a report to Excel. The report has about 1000
> records. I can export it to a pdf fine, but not Excel. I get an "Index was
> outside the bounds of the array" error message.
> thank you for any help possible.

Exporting to Excel and Emailing PDF

I have read several discussions that SP1 needs to be installed for the Export
to Excel and Emailing PDF. Does Reporting Services SP1 need to be installed
on the Reporting Services server? The server is a Windows Sever 2003
Enterprise Edition.
Also, does the fix for emailing PDF need to be done on the Reporting
Services server (support.microsoft.com/default.aspx?scid=kb;[LN];872774) ?
Thanks.Hey Mike,
SP1 does apply to enterprise edition. Yes, SP1 needs to be installed on the
RS server. To see what editions of RS are affected, what exactly gets
updated and specific install instructions see:
http://support.microsoft.com/?kbid=842857
The specific fix you mention below states that it will be in SP2...which we
all are eagerly awaiting...)
Adrian M.
MCP
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:3EFEF651-03D6-47E8-9328-0BE8756091DA@.microsoft.com...
>I have read several discussions that SP1 needs to be installed for the
>Export
> to Excel and Emailing PDF. Does Reporting Services SP1 need to be
> installed
> on the Reporting Services server? The server is a Windows Sever 2003
> Enterprise Edition.
> Also, does the fix for emailing PDF need to be done on the Reporting
> Services server (support.microsoft.com/default.aspx?scid=kb;[LN];872774) ?
>
> Thanks.

Exporting to Excel

Hi guys,
I have set up a report that exports perfectly into PDF,
but not into Excel.
The report contains a table with:
- a standard table header
- a table row: with alternating logos & a textbox directly
next to it
- a details area
- a table footer
(By alternating logos, I am referring to having different
images placed into a rectangle and different logos will
appear depending on certain conditions).
The problem: When exported into Excel, the logo/image does
not appear on the same row as the textbox that is directly
next to it. And the rest of the details from the table
gets pushed a few rows down.
Any info would be appreciated.
Regards,
LisaNo takers from Microsoft on this one?
Regards,
Lisa
"Lisa Liputra" wrote:
> Hi guys,
> I have set up a report that exports perfectly into PDF,
> but not into Excel.
> The report contains a table with:
> - a standard table header
> - a table row: with alternating logos & a textbox directly
> next to it
> - a details area
> - a table footer
> (By alternating logos, I am referring to having different
> images placed into a rectangle and different logos will
> appear depending on certain conditions).
> The problem: When exported into Excel, the logo/image does
> not appear on the same row as the textbox that is directly
> next to it. And the rest of the details from the table
> gets pushed a few rows down.
> Any info would be appreciated.
> Regards,
> Lisa
>
>
>

exporting to a pdf problem

HI everybody, my problem is that when i export to a pdf file i get on first page cut of info and the second page I just get a header and footer. Is there anything to do to fix this problemWould you please post your RDL and the PDF file. If you are using SP1, would
you also post the <ReportName>.rdl.data file.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"J-man" <J-man@.discussions.microsoft.com> wrote in message
news:4F0ECF86-1C7B-4B53-ACA7-0F39C7EEC81F@.microsoft.com...
> HI everybody, my problem is that when i export to a pdf file i get on
first page cut of info and the second page I just get a header and footer.
Is there anything to do to fix this problem|||Just checking - are you running SP1?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"J-man" <J-man@.discussions.microsoft.com> wrote in message
news:4F0ECF86-1C7B-4B53-ACA7-0F39C7EEC81F@.microsoft.com...
> HI everybody, my problem is that when i export to a pdf file i get on
> first page cut of info and the second page I just get a header and footer.
> Is there anything to do to fix this problem|||Well, if you didn't apply SP1 you are probably not running it. When you
browse to http://servername/reportserver, what version do you see? If it
says 878, you are running SP1. If it says 743, you are running RTM. You can
install SP1 from the link off http://www.microsoft.com/sql/reporting.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"j-man" <j-man@.discussions.microsoft.com> wrote in message
news:A76A0B7C-3A01-4CFB-B43A-1D0485E847E0@.microsoft.com...
>I have no clue, I'm just a dumb kid. How would i find this out?
> "Brian Welcker [MSFT]" wrote:
>> Just checking - are you running SP1?
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "J-man" <J-man@.discussions.microsoft.com> wrote in message
>> news:4F0ECF86-1C7B-4B53-ACA7-0F39C7EEC81F@.microsoft.com...
>> > HI everybody, my problem is that when i export to a pdf file i get on
>> > first page cut of info and the second page I just get a header and
>> > footer.
>> > Is there anything to do to fix this problem
>>