PDF rendering problem if it is called from a modal page (fdf)

Hi,
I am having this problem with rendering PDF. My modal is calling this report
page which renders the PDF by posting the parameter.
From a modal page.
//I have the parameters in the Form
var strReportPage = "frmReportModal.aspx";
formReport.action = strReportPage;
formReport.method = "post";
formReport.target = "blank";
formReport.submit();
The reportModal.aspx comes up with this error:
Adobe Reader could not open 'pa02528XX.fdf' because it is either not a
supported file type ... or because the file has been corrupted.
It will work fine if I try from a non-modal pagestrutt,
Unfortunately not at the moment. I don't if it is adobe problem.
"strutt" <strutt@.discussions.microsoft.com> wrote in message
news:6326B311-9604-434F-A92F-51618D7C38F8@.microsoft.com...
> Did you ever figure this out? I am having the same problem. It appears to
be
> something in Adobe, but I still don't have it fixed. Thanks for any help.
> "Hara" wrote:
> > Hi,
> >
> > I am having this problem with rendering PDF. My modal is calling this
report
> > page which renders the PDF by posting the parameter.
> >
> > From a modal page.
> > //I have the parameters in the Form
> > var strReportPage = "frmReportModal.aspx";
> > formReport.action = strReportPage;
> > formReport.method = "post";
> > formReport.target = "blank";
> > formReport.submit();
> >
> > The reportModal.aspx comes up with this error:
> >
> > Adobe Reader could not open 'pa02528XX.fdf' because it is either not a
> > supported file type ... or because the file has been corrupted.
> >
> > It will work fine if I try from a non-modal page
> >
> >|||Hara,
I did not figure out what was causing the problem either. I did come up with
a workaround though, If you change the content-disposition to
'attachment;filename=xxxxxx.pdf', then IE will prompt with a file open/save
dialog. If the user selects 'open'. the file opens properly in adobe reader.
Dave
"Hara Vilaythong" wrote:
> strutt,
> Unfortunately not at the moment. I don't if it is adobe problem.
>
> "strutt" <strutt@.discussions.microsoft.com> wrote in message
> news:6326B311-9604-434F-A92F-51618D7C38F8@.microsoft.com...
> > Did you ever figure this out? I am having the same problem. It appears to
> be
> > something in Adobe, but I still don't have it fixed. Thanks for any help.
> >
> > "Hara" wrote:
> >
> > > Hi,
> > >
> > > I am having this problem with rendering PDF. My modal is calling this
> report
> > > page which renders the PDF by posting the parameter.
> > >
> > > From a modal page.
> > > //I have the parameters in the Form
> > > var strReportPage = "frmReportModal.aspx";
> > > formReport.action = strReportPage;
> > > formReport.method = "post";
> > > formReport.target = "blank";
> > > formReport.submit();
> > >
> > > The reportModal.aspx comes up with this error:
> > >
> > > Adobe Reader could not open 'pa02528XX.fdf' because it is either not a
> > > supported file type ... or because the file has been corrupted.
> > >
> > > It will work fine if I try from a non-modal page
> > >
> > >
>
>

PDF Rendering Problem - blank pages

I have a report that consists of a number of subreports. When I export to
PDF I get blank pages on every second page. No data is missing, it looks
like an incorrect margin setting or additional page break. If I export the
original "Sub"reports to PDF, then the problem does not occur.
I have checked the margins in the report and the subreports, and they are
all identical. Does anyone have any ideas I can try?
AndreCheck your master report.
Look at your report width as well as your left and right margins.
"Andre" <Andre@.discussions.microsoft.com> wrote in message
news:05B0EB7A-8DE7-4323-A4AF-383F4E4D8543@.microsoft.com...
>I have a report that consists of a number of subreports. When I export to
> PDF I get blank pages on every second page. No data is missing, it looks
> like an incorrect margin setting or additional page break. If I export
> the
> original "Sub"reports to PDF, then the problem does not occur.
> I have checked the margins in the report and the subreports, and they are
> all identical. Does anyone have any ideas I can try?
> Andresql

PDF Rendering from an ASP page

Hi Friends,
How can we render a page in pdf format directly from the Web
Aplication. With out the File Down Load screen.
Thanks
Josethis is a browser issue. You can stream the report (in any format) down to
the browser as
contenttype={what ever you got} and
response.writebinary({your array of bytes})
The browser decides to do the open vs. save dialog depending on its own
settings, I think.
dlr
"Jose Francis" <josefrancis@.gmail.com> wrote in message
news:482833ae.0409170516.1ec28fb2@.posting.google.com...
> Hi Friends,
> How can we render a page in pdf format directly from the Web
> Aplication. With out the File Down Load screen.
> Thanks
> Jose

PDF Rendering - Page break with images

Hi,
I have a main page which has subreports, images and tables. in Preview i can
see the reports with proper page breaks, but when i render it to pdf, the
image and table in the main page is moving to another page, actually only 3
pages has to be printed in pdf but it is printing to 10 pages.
any suggestions please.
Thanks and regards,
AnithaI got the solution, i need to put all the lables and data in a Table to
display it in one page.
"Anitha Naidu" wrote:
> Hi,
> I have a main page which has subreports, images and tables. in Preview i can
> see the reports with proper page breaks, but when i render it to pdf, the
> image and table in the main page is moving to another page, actually only 3
> pages has to be printed in pdf but it is printing to 10 pages.
> any suggestions please.
> Thanks and regards,
> Anitha
>|||Try placing everything inside a rectangle control.
Place a rectangle in a blank area of the body.
Cut the controls including tables you want to contain, select the
rectangle, then paste the controls back in. Align things the way you
want inside the rectangle. This is the best way to restrict things in
RS. It may not work, but it's worth a try.
Cheers
Chris
Anitha Naidu wrote:
> I got the solution, i need to put all the lables and data in a Table
> to display it in one page.
>
> "Anitha Naidu" wrote:
> > Hi,
> >
> > I have a main page which has subreports, images and tables. in
> > Preview i can see the reports with proper page breaks, but when i
> > render it to pdf, the image and table in the main page is moving to
> > another page, actually only 3 pages has to be printed in pdf but it
> > is printing to 10 pages.
> >
> > any suggestions please.
> >
> > Thanks and regards,
> > Anitha
> >

PDF Rendering

OK still having the problem of a blank page after every report. I have reset
all my page sizes, margins etc. Ensured that my page size is minus my
margins etc. And still this is happening. Any insight would be lovely
thanks. Cannot deploy reports to customers application until this is sorted.Do you have a page break after any groups?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nat Johnson" <NatJohnson@.discussions.microsoft.com> wrote in message
news:60472AC6-90D7-4B80-84EA-C78ACFE98022@.microsoft.com...
> OK still having the problem of a blank page after every report. I have
> reset
> all my page sizes, margins etc. Ensured that my page size is minus my
> margins etc. And still this is happening. Any insight would be lovely
> thanks. Cannot deploy reports to customers application until this is
> sorted.|||No page break Brain. Managed to get it sorted yesterday afternoon with much
playing around with margins etc. Even are setting the page size to the
normal width less the margins didn't seem to help. I had to bring it in a
lot further.
"Brian Welcker [MSFT]" wrote:
> Do you have a page break after any groups?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Nat Johnson" <NatJohnson@.discussions.microsoft.com> wrote in message
> news:60472AC6-90D7-4B80-84EA-C78ACFE98022@.microsoft.com...
> > OK still having the problem of a blank page after every report. I have
> > reset
> > all my page sizes, margins etc. Ensured that my page size is minus my
> > margins etc. And still this is happening. Any insight would be lovely
> > thanks. Cannot deploy reports to customers application until this is
> > sorted.
>
>|||What about the <Body> properties width and height. Do they conform to your
paper dimensions. And even if they do, is the 'can grow' option on in your
fields? Sometimes this can push your report past your defined margins and
create an extra page.
--
Message posted via http://www.sqlmonster.com|||I've had this problem a few times...make sure that your report width is small
enough to fit on one page. Try to keep it under 22.75cm wide. The extra page
is just the edges wrapping around to the next page.
"Nat Johnson" wrote:
> OK still having the problem of a blank page after every report. I have reset
> all my page sizes, margins etc. Ensured that my page size is minus my
> margins etc. And still this is happening. Any insight would be lovely
> thanks. Cannot deploy reports to customers application until this is sorted.

PDF has a extra page

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 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
> >
> >
>

PDF Fit to Page

I have reports being accessed through report manager in the UK and USA.
The reports were created to fit on an A4 page size which works fine in
UK but because the standard paper size in USA is Letter the export to
PDF is producing reports that are rendering to multiple pages.
Is there anyway I can set the PDF to fit to page either in the report
itself or in report manager?
If this isn't possible can I create a custom renderer that inherits the
standard PDF renderer but allows me to set the fit to page?In the report you will need to set the correct size, in the layout tab, in
report proeperties, to pen this dialog, just right click(or left depends ond
you configuration), and select properties, then move to the layout tab, and
set the correct paper size, adjust the margins as you need it, do the same
with the report's body, but you have to be carefull,
the body width must be less or equal than the
Page Width(the one in layou) - the sum of the margins if you do not meet
this requirements, you'll have pagebreaks in pdfs.
You can find more information for this at the following link:
http://blogs.msdn.com/chrisbal/
--
Eduardo Fonseca
"Nathan" wrote:
> I have reports being accessed through report manager in the UK and USA.
> The reports were created to fit on an A4 page size which works fine in
> UK but because the standard paper size in USA is Letter the export to
> PDF is producing reports that are rendering to multiple pages.
> Is there anyway I can set the PDF to fit to page either in the report
> itself or in report manager?
> If this isn't possible can I create a custom renderer that inherits the
> standard PDF renderer but allows me to set the fit to page?
>

PDF first page blank issue

I have a report that is made up of several smaller reports. My main report
has a main list and then an inner list. I have this set up so that the entire
report is repeated for each individual product campaign, one per page (in
other words, I have 20 or so pages of the same report, populated with
different data on each page). This works fine when it is published and viewed
through the report manager, but when I go to export it, the first page is
sometimes, but not always blank (except for the header and footer which
contains the correct data for that campaign). Yet if I reorder the campaigns
and make the page that was showing up blank not be the first page anymore, it
displays fine when exported. I did some research on this issue and the
closest thing that I found was someone else posing a similar question on an
MSDN "Chat"
(http://www.microsoft.com/technet/community/chats/trans/sql/sql060704.mspx).
Unfortunately they did not have a solution at that time. If anyone has a
solution to this please let me know. Thanks,
DavidDo you have the "Page Break at Start" option enabled on anything?
"David" wrote:
> I have a report that is made up of several smaller reports. My main report
> has a main list and then an inner list. I have this set up so that the entire
> report is repeated for each individual product campaign, one per page (in
> other words, I have 20 or so pages of the same report, populated with
> different data on each page). This works fine when it is published and viewed
> through the report manager, but when I go to export it, the first page is
> sometimes, but not always blank (except for the header and footer which
> contains the correct data for that campaign). Yet if I reorder the campaigns
> and make the page that was showing up blank not be the first page anymore, it
> displays fine when exported. I did some research on this issue and the
> closest thing that I found was someone else posing a similar question on an
> MSDN "Chat"
> (http://www.microsoft.com/technet/community/chats/trans/sql/sql060704.mspx).
> Unfortunately they did not have a solution at that time. If anyone has a
> solution to this please let me know. Thanks,
> David|||I have "Page Break at END" enabled on my most inner list.
"Mark Parter" wrote:
> Do you have the "Page Break at Start" option enabled on anything?
> "David" wrote:
> > I have a report that is made up of several smaller reports. My main report
> > has a main list and then an inner list. I have this set up so that the entire
> > report is repeated for each individual product campaign, one per page (in
> > other words, I have 20 or so pages of the same report, populated with
> > different data on each page). This works fine when it is published and viewed
> > through the report manager, but when I go to export it, the first page is
> > sometimes, but not always blank (except for the header and footer which
> > contains the correct data for that campaign). Yet if I reorder the campaigns
> > and make the page that was showing up blank not be the first page anymore, it
> > displays fine when exported. I did some research on this issue and the
> > closest thing that I found was someone else posing a similar question on an
> > MSDN "Chat"
> > (http://www.microsoft.com/technet/community/chats/trans/sql/sql060704.mspx).
> > Unfortunately they did not have a solution at that time. If anyone has a
> > solution to this please let me know. Thanks,
> > David

PDF file featuring only the first page... why?

Hello,
I am struggeling with my .PDF file exports. One of our reports outputs 250
pages in the web interface. When I ask to output a PDF version of it, the
file contains only the first page but I really don't know why. Could it be a
problem with the .RDL file?!?
Thanks!
Marc LacoursiereAfter some more inspection... I have found something interesting!
The report contains a table which has 2 groups. Both of them were set to do
a page break after them. If I remove the page break in the inner group, but
leave the other intact, the problem is fixed.
For this report, it is now working perfectly. But I am still wondering why
would the PDF rendering stop because of a table containing two groups both
doing page breaks?
Suppose I am required to create such a behavior in a different report, would
I still be stuck with that issue?
Marc Lacoursiere
"Marc Lacoursiere" <marcdotlacoursiere@.cgi.com> wrote in message
news:uroxxN$9EHA.3236@.TK2MSFTNGP15.phx.gbl...
> Hello,
>
> I am struggeling with my .PDF file exports. One of our reports outputs 250
> pages in the web interface. When I ask to output a PDF version of it, the
> file contains only the first page but I really don't know why. Could it be
> a problem with the .RDL file?!?
>
> Thanks!
> Marc Lacoursiere
>sql

PDF export results in extra pages.

I am experiencing some quirks when exporting to PDF.
I have read all the other posts about page sizes, margins, etc and my situation seems to be a bit different.

PageWidth = 21cm
PageHeight = 29.7cm
Margins = 1cm

Body.Width = 19cm

I have a report that contains a bar chart (Height = 15cm, Width = 19cm) and below that a rectangle that contains two text boxes with totals information (Left = 11.6cm, Width = 7.4cm, Height 0.5cm)

Now most of the time it exports to PDF perfectly - all on one page as would be expected

If however the chart has more than say 20 items on the y-axis then the rectangle gets pushed onto an new page.

For extra information, but not to confuse the issue I also have a page header and footer that have items lined up right to the edge (left + width = 19cm) and they all display fine on the one page. It is just this rectangle that is having the problem.

When I move the rectangle to the left a bit (11.4cm) so 0.2cm away from the right hand edge then it works fine.

It is just very strange because I cant see how it is getting shifted only when the chart contains a lot of items.

Any ideas?

I finally found a solution that works for me, just after I posted - usually the way.

I have created a rectangle with left = 0cm and width = 19cm and then placed the text boxes
inside that rectangle, positioned where I need them.

Once I do that it renders onto one page.

What I think is going on here is a precision problem. I suspect that MS being a US based company their base units are the imperial system so Inches. So even though you can express your measurements in cm, pt's, etc - they are always converted to a base unit of inches. With any conversion process you can get problems with precision and that is what I think is happening here.

So I feel the best way to avoid these precision bugs is to adopt a report design strategy of not having floating report items in your report. Group items by placing them in a rectangle and set the left to 0 and the width to the exact page width boundary (in this case 19cm)

The other solution is to always use the same base units as the renderer (inches) that way you wont suffer conversion precision problems. Unfortunately for me it would take forever to convert all mine from cm to inches.

PDF Export not complete

When I attempt to export a 6 page report as a PDF file, only page 1 is present.
What is preventing the complete report from exporting?Never mind. After installing SP2, everything is fine now.
"kbright" wrote:
> When I attempt to export a 6 page report as a PDF file, only page 1 is present.
> What is preventing the complete report from exporting?

PDF Export Causes 100 % CPU - MS Response appreciated

I have a 100 page report that I render as PDF and then show in an
IFrame from a C# Ascx user control. It takes about 3 minutes to
render if ONE person is rendering the report. The CPU goes to about
50 %. If TWO people attempt to render the report, the CPU goes to
100% and the reports don't render (at least after 11 minutes).
If I render to HTML, it takes about 15 seconds although HTML Rendering
is not an option in this application.
This is running on a server with 1 GIG of memory Xeon 2.38 processor.
I've installed Service Pack 1 (although it blasted through the install
REALLY FAST so I have my doubts).
I had thought that SP1 was supposed to improve PDF rendering. Is
there something I can program to improve performance?
This issue, if not resolvable, makes RS unusable for this application
which is not an option I'm pleased with.
Thanks in Advance for the Reply
Timothy Heuer
heuert@.comcast.netSP1 does contain some improvement for PDF rendering. We are continuing to
improve it for the next release. If you can send the repro (RDL and data),
we will investigate to see what is causing the problem in your particular
scenario.
Fang Wang (MSFT)
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"teem60004" <teem60004@.hotmail.com> wrote in message
news:66823058.0407230846.6c7b89c5@.posting.google.com...
> I have a 100 page report that I render as PDF and then show in an
> IFrame from a C# Ascx user control. It takes about 3 minutes to
> render if ONE person is rendering the report. The CPU goes to about
> 50 %. If TWO people attempt to render the report, the CPU goes to
> 100% and the reports don't render (at least after 11 minutes).
> If I render to HTML, it takes about 15 seconds although HTML Rendering
> is not an option in this application.
> This is running on a server with 1 GIG of memory Xeon 2.38 processor.
> I've installed Service Pack 1 (although it blasted through the install
> REALLY FAST so I have my doubts).
> I had thought that SP1 was supposed to improve PDF rendering. Is
> there something I can program to improve performance?
> This issue, if not resolvable, makes RS unusable for this application
> which is not an option I'm pleased with.
> Thanks in Advance for the Reply
>
> Timothy Heuer
> heuert@.comcast.net

Password Proctected Excel Subscription

I need to send protected information via a reporting services subscripiton. Unfortunately the receiver can not access our reporting services web page so I have to send it as an excel attachment with email. Is there a way I can protect the spreadsheet automatically before it is sent via the subscription.

Thanks

Reporting Services doesn't currently have a DRM/IRM or Excel password feature, so you would have to post-process the Excel files that RS generates.|||Thanks but I'm still not sure how I'd do that without programming.|||You will have to do some programming, or open the Excel files in Excel and modify them.

Passport sign out from this forum

Just lately I have noticed that I am periodically getting signed out of this forum. When I try and sign back in I get directed to an error page saying:

We apologize, but an unknown error has occured in the forums.

This error has been logged.

I would say this has been happening for a couple of weeks now at least.

Has anyone else expereienced this?

Thanks

Jamie

Not seen the error, but I am always having to sign back in, several times a day on the same machine.

Passing settings

In my .NET application, I have my report control Zoom set to Page Width
(rc:Zoom=Page Width). This works fine for the first report that appears,
but when I click a link in this report to navigate to another, the zoom
resets to 100%.
Is there a way to get my Zoom to stay what I've set it to? Do I have to do
this in a config file rather than in .NET?
Thanks,
MelissaYes, we too would like to have all of our reports come up in page width
instead of 100%, is there a way to do this in report manager? maybe a setting
in the config file?
"Melissa" wrote:
> In my .NET application, I have my report control Zoom set to Page Width
> (rc:Zoom=Page Width). This works fine for the first report that appears,
> but when I click a link in this report to navigate to another, the zoom
> resets to 100%.
> Is there a way to get my Zoom to stay what I've set it to? Do I have to do
> this in a config file rather than in .NET?
>
> Thanks,
> Melissa
>
>