Wednesday, March 28, 2012
PDF Rendering with web form
and display it as a PDF.
The problem that is experienced is when the report reads parameters from the
querystring passed to the webform. The parameters passed to the page will
then be passed to the Reporting Services web service. The page attempts to
open the PDF, but when Adobe Acrobat Reader opens, an error appears: "Adobe
Reader could not open 'paXXXXXX.fdf' because it is either not a supported
file type or because the file has been corrupted (for example, it was sent as
an email attachment and wasn't correctly decoded)."
This problem only happens when exporting to the PDF format and runs fine in
all other formats. This error only occurs when the report is run in version
6 of Acrobat. In version 7 it is not a problem. The instance of Reporting
Services used has SP1 installed.I had a similar problem. It turned out that the web form was adding its HTML
to the end of the PDF file. Apparently Excel didn't care but Acrobat V6 did.
I fixed it by overriding the page's Render method and only called
MyBase.Render(output) when the mime type was HTML. This prevented the page's
HTML being rendered and stuck on the end of the PDF or any other non-html
stream.
Hope that helps.
Grahame
"Aidan" wrote:
> I'm experiencing a problem with a webform which receives a binary steam back
> and display it as a PDF.
> The problem that is experienced is when the report reads parameters from the
> querystring passed to the webform. The parameters passed to the page will
> then be passed to the Reporting Services web service. The page attempts to
> open the PDF, but when Adobe Acrobat Reader opens, an error appears: "Adobe
> Reader could not open 'paXXXXXX.fdf' because it is either not a supported
> file type or because the file has been corrupted (for example, it was sent as
> an email attachment and wasn't correctly decoded)."
> This problem only happens when exporting to the PDF format and runs fine in
> all other formats. This error only occurs when the report is run in version
> 6 of Acrobat. In version 7 it is not a problem. The instance of Reporting
> Services used has SP1 installed.
PDF render
Is there a way to make the rendering of a report in PDF form any faster?
Currently takes about 40 mins for 10,000 pages. Only solution i can think of
is throw more hardware at it.
Thanks,
SPOOn Mon, 19 Dec 2005 06:01:02 -0800, iamspo wrote:
> Using RS/SQL 2000.
> Is there a way to make the rendering of a report in PDF form any faster?
> Currently takes about 40 mins for 10,000 pages. Only solution i can think of
> is throw more hardware at it.
> Thanks,
> SPO
I'd agree - throw more hardware at it, but I have to ask what everyone else
is probably thinking...
10,000 pages? What are you generating? Could anyone possibly look through
(or print!) a PDF containing that many pages?|||> 10,000 pages? What are you generating? Could anyone possibly look
> through
> (or print!) a PDF containing that many pages?
I don't see how or why.sql
PDF has a extra page
I have an invoice form report that should be one page in length, but when I
render to PDF I get a 2nd page with header & footer but nothing in the
middle. How do I stop this happening?
brian smithIn VS, under report properties, are your page dimensions set to the proper height and width? Based on those values, is the width of your page in the layout view actually fit that?
I had a similar problem with one of my reports - turned out my margins were larger than I had thought. Shrinking down the report body by about a quarter of an inch solved it.
HTH
- T|||Make sure that your report is set up 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.
"Brian Smith" <bsmith@.nospam.leazesdotcom> wrote in message
news:%23nxXmxEZEHA.2844@.TK2MSFTNGP12.phx.gbl...
> Some tips please on PDF rendering.
> I have an invoice form report that should be one page in length, but when
I
> render to PDF I get a 2nd page with header & footer but nothing in the
> middle. How do I stop this happening?
> brian smith
>|||Thanks - I'll try it later.
brian
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:%23Er1vhFZEHA.3596@.tk2msftngp13.phx.gbl...
> Make sure that your report is set up 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.
>
> "Brian Smith" <bsmith@.nospam.leazesdotcom> wrote in message
> news:%23nxXmxEZEHA.2844@.TK2MSFTNGP12.phx.gbl...
> > Some tips please on PDF rendering.
> > I have an invoice form report that should be one page in length, but
when
> I
> > render to PDF I get a 2nd page with header & footer but nothing in the
> > middle. How do I stop this happening?
> >
> > brian smith
> >
> >
>|||Worked fine. Thanks very much.
brian
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:%23Er1vhFZEHA.3596@.tk2msftngp13.phx.gbl...
> Make sure that your report is set up 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.
>
> "Brian Smith" <bsmith@.nospam.leazesdotcom> wrote in message
> news:%23nxXmxEZEHA.2844@.TK2MSFTNGP12.phx.gbl...
> > Some tips please on PDF rendering.
> > I have an invoice form report that should be one page in length, but
when
> I
> > render to PDF I get a 2nd page with header & footer but nothing in the
> > middle. How do I stop this happening?
> >
> > brian smith
> >
> >
>
Monday, March 26, 2012
PDF file is not in right format
HI,
When I preview the report it is in correct format but when I save it in PDF form it is not coming in the right format.
There is a textbox on 1st page.If the value of that textbox is large it prints the text on 2nd page and leaves a blank
space on 1st page.Why this is happening.Please Help me.
May
Try couple of things:
1) make your textbox multiline. There is property MultiLine so set that to true.
2) Check your report page margins. Keep it according to your page size.
Let me know if this helps
Lav
|||I have set the page margin to 0.3 and also body size is 6.8in.Still it is shifting the whole text to next page.
Text is a big paragraph .I could not find the multiline property of textbox.
Thanks in Advance.
May
|||What is your page size??
I assume 6.8in is your width.
For Multiline i meant Can grow property. Make sure its set to True.
|||also make sure your page size must be greater than your width + left margin + right margin|||Page Size is 8.5in-11in.Can Grow property is True already.
Is there any property like Keep Together.Because it is trying to keep the whole text together thats why
it is shifting it onto the next page.I tried to put textbox in a rectangle..still not working.
May
|||Is there anything else on that page? Explain me the layout of the page.
If possible add an image of report layout.
|||
I don't know how to add the image from here.Layout is like this:
CustomerName: !First(FieldCustname.value) DateEntered: Fielddate.value
Contact (subreport)
Reason: !First(FieldReason.value)
Action: !First(FieldAction.value)
Reason textbox is giving trouble.After printing the name,date n contact the rest of the page is blank.
reason text is on 2nd page.
|||
I have the same problem with a table which the report try to display on the next page when it fit, butKeepTogether is set toflase and there is noPageBreakBefore.
But it behave like if KeepTogether was set to True.
Any idea ?
Friday, March 23, 2012
PDF cache problem
changed but when the person creates an 'updated' report, the cached version
is pulled up instead of rerunning the report. Report Services is set to no
cache. I think this is directly related to Acrobat Reader. Has anyone seen
this? Figured out a way to force a recreation of the report? Is there a way
to dynamically change the name of the report, such as add the time in
milliseconds, that may force an updated pdf to be created?
Thanks,
Neilin the url to your report you should add rs:clearsession=true
"Neil Gould" wrote:
> I have a webform that I create a pdf report from. Data in the form can be
> changed but when the person creates an 'updated' report, the cached version
> is pulled up instead of rerunning the report. Report Services is set to no
> cache. I think this is directly related to Acrobat Reader. Has anyone seen
> this? Figured out a way to force a recreation of the report? Is there a way
> to dynamically change the name of the report, such as add the time in
> milliseconds, that may force an updated pdf to be created?
> Thanks,
> Neilsql