Exporting pdf from RS to a Win Form

I'm using Reporting Services 2005 and .Net framework 2.0 and want to display
reports from RS in my Windows form. My questions are:
1) I've got the pdf from the Render-method in the RS Web Service, and tried
to display the pdf in a WebBrowser in my Windows Form using the
WebBrowser.DocumentStream property. But I don't know how set the content type
to application/pdf. I only get the binary displayed in the browser.
Suggestions?
2) If I access, from the same browser as in 1), a pdf through an URL, it
works fine. So, is if possible to retreive a report as a pdf through an URL
reference directly?
3) I could try to display the pdf some kind of other pdf container in my
winform. Does anyone know some nice tools to do this?
Regards,
Tomsi2) According to Books online for SQL Server CTP April 2005, it should be
possible to specify rs:Format=PDF as a parameter in the URL. But this doesn't
help me. It just seems to ignore the parameter... What could be wrong? Or
just simply doesn't the 2005 version support URL access directly?
"Tomsi" wrote:
> I'm using Reporting Services 2005 and .Net framework 2.0 and want to display
> reports from RS in my Windows form. My questions are:
> 1) I've got the pdf from the Render-method in the RS Web Service, and tried
> to display the pdf in a WebBrowser in my Windows Form using the
> WebBrowser.DocumentStream property. But I don't know how set the content type
> to application/pdf. I only get the binary displayed in the browser.
> Suggestions?
> 2) If I access, from the same browser as in 1), a pdf through an URL, it
> works fine. So, is if possible to retreive a report as a pdf through an URL
> reference directly?
> 3) I could try to display the pdf some kind of other pdf container in my
> winform. Does anyone know some nice tools to do this?
> Regards,
> Tomsi|||I ran into this problem as well. I need to display pdf documents
within windows forms and I am trying to utilize the webbrowser control
but can't seem to set the contenttype to 'application/pdf'. Did you
ever find a solution?
Tomsi wrote:
> I'm using Reporting Services 2005 and .Net framework 2.0 and want to display
> reports from RS in my Windows form. My questions are:
> 1) I've got the pdf from the Render-method in the RS Web Service, and tried
> to display the pdf in a WebBrowser in my Windows Form using the
> WebBrowser.DocumentStream property. But I don't know how set the content type
> to application/pdf. I only get the binary displayed in the browser.
> Suggestions?
> 2) If I access, from the same browser as in 1), a pdf through an URL, it
> works fine. So, is if possible to retreive a report as a pdf through an URL
> reference directly?
> 3) I could try to display the pdf some kind of other pdf container in my
> winform. Does anyone know some nice tools to do this?
> Regards,
> Tomsi|||1) As a temporary solution I save the pdf-stream to a file, and access the
file with the WebBrowser.Url-property:
--
string fileName = Path.GetTempFileName() + ".pdf";
FileStream fs = new FileStream(fileName, FileMode.Create);
fs.Write(bytes, 0, bytes.Length);
fs.Close();
_browserReport.Url = new Uri(fileName);
--
But I would like to know how to do this without saving to disk.
2) As far as I can read the SQL Server 2005 documentation, it should work to
get a pdf through URL access from Reporting Services by setting the attribute
"Format=PDF" in the URL. But I can't get it to work in the CTP april
2005-version.
3) Haven't tried this further out. I think Adobe sells some kind of SDK
which might help.
So my answer is that I'm still looking for a good solution.
Tomsi
"rich.beaver@.gmail.com" wrote:
> I ran into this problem as well. I need to display pdf documents
> within windows forms and I am trying to utilize the webbrowser control
> but can't seem to set the contenttype to 'application/pdf'. Did you
> ever find a solution?
> Tomsi wrote:
> > I'm using Reporting Services 2005 and .Net framework 2.0 and want to display
> > reports from RS in my Windows form. My questions are:
> >
> > 1) I've got the pdf from the Render-method in the RS Web Service, and tried
> > to display the pdf in a WebBrowser in my Windows Form using the
> > WebBrowser.DocumentStream property. But I don't know how set the content type
> > to application/pdf. I only get the binary displayed in the browser.
> > Suggestions?
> >
> > 2) If I access, from the same browser as in 1), a pdf through an URL, it
> > works fine. So, is if possible to retreive a report as a pdf through an URL
> > reference directly?
> >
> > 3) I could try to display the pdf some kind of other pdf container in my
> > winform. Does anyone know some nice tools to do this?
> >
> > Regards,
> > Tomsi
>sql

Exporting PDF - Adding empty page

Hi,

I created a report using dynamic display( I hide the column using the expression in Property->Visibility).By using expression the column which is having null is hided.When I try to export the report to PDF,the empty pages are displaying along with data.Ie.,The report contyains only 5 pages but in PDF it is displaying 10 pages(5pages data with 5 empty pages).

Any Suggestions appreciated!

Thanks

Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.

Also, be sure that:

Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin

-Chris

|||

Chris Baldwin - MSFT wrote:

Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.

Also, be sure that:

Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin

-Chris

I am trying to accomplish the same thing and my problem is the Body width as mentioned by Chris.. it is too wide since my available set of columns is fairly large. Are there any known tricks to work around this limitation, using matrices, or whatever technique?

- Ron

Exporting PDF - Adding empty page

Hi,

I created a report using dynamic display( I hide the column using the expression in Property->Visibility).By using expression the column which is having null is hided.When I try to export the report to PDF,the empty pages are displaying along with data.Ie.,The report contyains only 5 pages but in PDF it is displaying 10 pages(5pages data with 5 empty pages).

Any Suggestions appreciated!

Thanks

Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.

Also, be sure that:

Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin

-Chris

|||

Chris Baldwin - MSFT wrote:

Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.

Also, be sure that:

Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin

-Chris

I am trying to accomplish the same thing and my problem is the Body width as mentioned by Chris.. it is too wide since my available set of columns is fairly large. Are there any known tricks to work around this limitation, using matrices, or whatever technique?

- Ron

exporting error

attached is the error msg that display everytime i export the informations generated by CR v8.5 to excel file. i thought the reason for the error msg is the consumption of the 65T rows allowed in excel because when i export the report having much fewer informations (retrieve the same report in the short period of time), the exportation was successul.

On the other hand, when i tried the previous report version, any exportation was successful even when the retrieval arguments in date range is 3 months.

Please help mei have known the cause of this error, this is due to the subreport i inserted so i just editted the report and delete the sub report. on the other hand, can anyone help me why does the error occur? is it a bug of the CR 8.5? F.Y.I the CR report is directly retrieve in a server... H.E.L.Psql

Export to PDF error with SP1 still (encoding related)

Export to PDF error with SP1 still (encoding related)
my reports have some Chinese msg.
When review or display, everything seemed ok. But when I export it to PDF, Chinese msg showed as "'"
I've tried to export my report into other format with no error.
Before SP1, it's a problem. Now, with SP1, its still. :(
my SQL Server is SQL Server 2000 En + SP4If you want to show PDF reports in Traditional Chinese, try to set FontFamily to "æ?°ç´°æ'é«?" or other localized FontFamilies.
"wps8848" wrote:
> Export to PDF error with SP1 still (encoding related)
>
> my reports have some Chinese msg.
> When review or display, everything seemed ok. But when I export it to PDF, Chinese msg showed as "'"
> I've tried to export my report into other format with no error.
> Before SP1, it's a problem. Now, with SP1, its still. :(
> my SQL Server is SQL Server 2000 En + SP4
>|||thanks to SAM.
The problem is resolved. :)
What a pitty it is? Sign !
"sam" wrote:
> If you want to show PDF reports in Traditional Chinese, try to set FontFamily to "æ?°ç´°æ'é«?" or other localized FontFamilies.
>
> "wps8848" wrote:
> > Export to PDF error with SP1 still (encoding related)
> >
> >
> > my reports have some Chinese msg.
> > When review or display, everything seemed ok. But when I export it to PDF, Chinese msg showed as "'"
> >
> > I've tried to export my report into other format with no error.
> >
> > Before SP1, it's a problem. Now, with SP1, its still. :(
> >
> > my SQL Server is SQL Server 2000 En + SP4
> >
> >

Export to Excel missing last row

We have several reports in Excel that display fine in HTML, but when they
are exported to Excel the last Row is missing. There is a post dated 9/7 that
mentions the same problem, but was never answered...does anyone have any idea
what might be causing this or if there is a workaround?
ThanksI am having the same issue. I see there have been other posts about the
topic, but no answers. Anyone know any way to fix this? Thanks.
"kbradfor" wrote:
> We have several reports in Excel that display fine in HTML, but when they
> are exported to Excel the last Row is missing. There is a post dated 9/7 that
> mentions the same problem, but was never answered...does anyone have any idea
> what might be causing this or if there is a workaround?
> Thanks|||I made post on 10/14 and 10/20 with no replies. I'm hoping that Microsoft
will respond soon. This problem is causing my client to question the
reporting engine.
"kbradfor" wrote:
> We have several reports in Excel that display fine in HTML, but when they
> are exported to Excel the last Row is missing. There is a post dated 9/7 that
> mentions the same problem, but was never answered...does anyone have any idea
> what might be causing this or if there is a workaround?
> Thanks|||Has anyone tried to add a blank footer row to the table? This way if the bug
does occur it will just drop a blank footer and not your data. (I know this
is idea is just a band-aid not a fix but MS seems to be ignoring this
problem.)
I have not tested this theory myself because I have only seen this happen a
few times and each time I tried to dup the results everything worked fine.
Maybe someone out there has a report that has a regular problem that could
test it for me?
Tim
"Derek Howard" wrote:
> I made post on 10/14 and 10/20 with no replies. I'm hoping that Microsoft
> will respond soon. This problem is causing my client to question the
> reporting engine.
> "kbradfor" wrote:
> >
> > We have several reports in Excel that display fine in HTML, but when they
> > are exported to Excel the last Row is missing. There is a post dated 9/7 that
> > mentions the same problem, but was never answered...does anyone have any idea
> > what might be causing this or if there is a workaround?
> >
> > Thanks

export to excel

Hi:
I have some percentage value in my report. I set these to 0 decimal point
in design layout.
It works fine when display on the web. But when I export them to excel,
these value is set to 1 decimal point.
Is there a way to round to no decimal point when exporting to excel?Ken,
Indeed the standard percentage format without decimals (P0) doesn't export
correctly to Excel. You can use #,##0% as a custom format.
Jan Pieter Posthuma
"ken" wrote:
> Hi:
> I have some percentage value in my report. I set these to 0 decimal point
> in design layout.
> It works fine when display on the web. But when I export them to excel,
> these value is set to 1 decimal point.
> Is there a way to round to no decimal point when exporting to excel?
>|||Thanks Jan, it's very helpful
"Jan Pieter Posthuma" wrote:
> Ken,
> Indeed the standard percentage format without decimals (P0) doesn't export
> correctly to Excel. You can use #,##0% as a custom format.
> Jan Pieter Posthuma
> "ken" wrote:
> > Hi:
> > I have some percentage value in my report. I set these to 0 decimal point
> > in design layout.
> > It works fine when display on the web. But when I export them to excel,
> > these value is set to 1 decimal point.
> > Is there a way to round to no decimal point when exporting to excel?
> >

Export Report to PDF

Hello,
I have a Report with PageHeader and PageFooter. If i display the published
report in IE there are no problems with my parameters there are two pages
displayed. But if I export these two pages to PDF I have a blank page with
only the header and footer beteen each site with data. Can you help me out of
this? Thank you.
best regards
dhi d,
The pdf being split into two pages is becoz of the "Page size" property
for a report, Make sure your page size doesnot exceed the actual page
size.
Rgds,
Venkat
Repordoll wrote:
> Hello,
> I have a Report with PageHeader and PageFooter. If i display the published
> report in IE there are no problems with my parameters there are two pages
> displayed. But if I export these two pages to PDF I have a blank page with
> only the header and footer beteen each site with data. Can you help me out of
> this? Thank you.
> best regards
> d