Embedding PDF Document

Does reporting services allow emdedding of PDF documents? I dont want to convert the document to JPEG as the size increases many times (for me the image size is around 1.6MB vs. 100KB for PDF) and i have several of these images. Would appreciate if anyone has done similar exercise to embed document within reports.
thanks !!Not sure what we would really embed it in? HTML isn't really a format that
supports embedding. You can embed docs in e-mail messages as well as link to
docs on a web page. I suppose we could have an MHTML format that embedded a
PDF file but this hasn't been high on the priority list.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ashok Jain" <Ashok Jain@.discussions.microsoft.com> wrote in message
news:0D468114-DF97-4800-ADB8-411D1C362954@.microsoft.com...
> Does reporting services allow emdedding of PDF documents? I dont want to
> convert the document to JPEG as the size increases many times (for me the
> image size is around 1.6MB vs. 100KB for PDF) and i have several of these
> images. Would appreciate if anyone has done similar exercise to embed
> document within reports.
> thanks !!|||But where is the PDF document stored? You can't 'embed' documents in a web
page. Can you just link to the document on a web site from the report? You
could even store the PDF in the Report Server database and link to it.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ashok Jain" <AshokJain@.discussions.microsoft.com> wrote in message
news:111C7F98-B8FF-4F7A-AF74-E14F9EE1650E@.microsoft.com...
> Thanks Brian !
> The issue I have is that I need to embed pre-generated PDF documents into
> the report and I am not sure how can I do that unless I convert the PDF
> into JPEG and then use the IMAGE control to embed. This works fine -
> however the size increase makes the report useless. For example, a 100KB
> PDF becomes 1.6MB JPEG file and you can imagine the generate and print
> pains if I have 10-20 of those images.
> Would love to have the feature where PDF or WORD docs can be imported into
> report pages -- is there an alternative like may be using a 3rd party
> activex or something like that?
> thanks again,
> Ashok
>
>
> "Brian Welcker [MSFT]" wrote:
>> Not sure what we would really embed it in? HTML isn't really a format
>> that
>> supports embedding. You can embed docs in e-mail messages as well as link
>> to
>> docs on a web page. I suppose we could have an MHTML format that embedded
>> a
>> PDF file but this hasn't been high on the priority list.
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Ashok Jain" <Ashok Jain@.discussions.microsoft.com> wrote in message
>> news:0D468114-DF97-4800-ADB8-411D1C362954@.microsoft.com...
>> > Does reporting services allow emdedding of PDF documents? I dont want
>> > to
>> > convert the document to JPEG as the size increases many times (for me
>> > the
>> > image size is around 1.6MB vs. 100KB for PDF) and i have several of
>> > these
>> > images. Would appreciate if anyone has done similar exercise to embed
>> > document within reports.
>> >
>> > thanks !!
>>

Embedding Fonts While Exporting To PDF

Hi,
My report requires a special type of font. I have the font installed on the
report server. When I export the report as PDF and view the document on the
report server I am able to see the new font. But when I open the same
document on a machine which doesn't have the font installed, I don't get to
see the font. I understand that there is some way you can configure your pdfs
so that the fonts are embedded within the PDF so that all the clients need
not have the font installed to view the document. Is there any way we can
embed fonts in pdfs using reporting services?
Any help is greatly appreciated.
Thanks,
GeorgeYou can't embed fonts into PDF exports in this version of SRS. Maybe next
version which is due maybe middle of next year. Crystal Reports allows you
to embed fonts in version 9.
"george" wrote:
> Hi,
> My report requires a special type of font. I have the font installed on the
> report server. When I export the report as PDF and view the document on the
> report server I am able to see the new font. But when I open the same
> document on a machine which doesn't have the font installed, I don't get to
> see the font. I understand that there is some way you can configure your pdfs
> so that the fonts are embedded within the PDF so that all the clients need
> not have the font installed to view the document. Is there any way we can
> embed fonts in pdfs using reporting services?
> Any help is greatly appreciated.
> Thanks,
> Georgesql

Embedded PDF and Excel Files

I want to upload PDF and Excel files to the Report Server database. I
would like to display them in a custom web application. When working
with the ReportViewer control, I can easily show reports. I can't
figure out the process on how to show a PDF to a user. In particular,
if the user selects a PDF ( I can check the MIMETYPE), then, how do I
get the file from Report Server so I can stream it to the user?On Oct 10, 3:21 pm, "goo...@.landy.net" <goo...@.landy.net> wrote:
> I want to upload PDF and Excel files to the Report Server database. I
> would like to display them in a custom web application. When working
> with the ReportViewer control, I can easily show reports. I can't
> figure out the process on how to show a PDF to a user. In particular,
> if the user selects a PDF ( I can check the MIMETYPE), then, how do I
> get the file from Report Server so I can stream it to the user?
If you create a report that has the same format and output as the PDF
and Excel files, you could call the report and automatically render it
to PDF or Excel with a download prompt via URL. Here are a couple
examples.
http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Render&Param1=SomeValue&rs:Format=PDF
-or-
http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Render&Param1=SomeValue&rs:Format=Excel
Here's the URL format:
http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=Render&<ParameterName>=<ParameterValue>&rs:Format=<PDF/CSV/XML/Excel/MHTML>
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Oct 10, 8:36 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Oct 10, 3:21 pm, "goo...@.landy.net" <goo...@.landy.net> wrote:
> > I want to upload PDF and Excel files to the Report Server database. I
> > would like to display them in a custom web application. When working
> > with the ReportViewer control, I can easily show reports. I can't
> > figure out the process on how to show a PDF to a user. In particular,
> > if the user selects a PDF ( I can check the MIMETYPE), then, how do I
> > get the file from Report Server so I can stream it to the user?
> If you create a report that has the same format and output as the PDF
> and Excel files, you could call the report and automatically render it
> to PDF or Excel with a download prompt via URL. Here are a couple
> examples.http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=
=3DRend...
> -or-http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=3DRe=
nd...
> Here's the URL format:
> http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=3DR=
ende=ADr&<ParameterName>=3D<ParameterValue>&rs:Format=3D<PDF/CSV/XML/Excel/=MHTML>
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
These are generic PDF files, not based on a report so they cannot be
rendered. We are using Reporting Services to provide security not
only to reports, but also some ancillary PDF and Excel files.|||Where does an uploaded pdf get stored'
Our uploaded pdf changes every week and rather than reupload everytime I was
hoping we could just save changes to the location it was uploaded to.
Many Thanks
"google@.landy.net" wrote:
> On Oct 10, 8:36 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > On Oct 10, 3:21 pm, "goo...@.landy.net" <goo...@.landy.net> wrote:
> >
> > > I want to upload PDF and Excel files to the Report Server database. I
> > > would like to display them in a custom web application. When working
> > > with the ReportViewer control, I can easily show reports. I can't
> > > figure out the process on how to show a PDF to a user. In particular,
> > > if the user selects a PDF ( I can check the MIMETYPE), then, how do I
> > > get the file from Report Server so I can stream it to the user?
> >
> > If you create a report that has the same format and output as the PDF
> > and Excel files, you could call the report and automatically render it
> > to PDF or Excel with a download prompt via URL. Here are a couple
> > examples.http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Rend...
> > -or-http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Rend...
> >
> > Here's the URL format:
> > http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=Rende-r&<ParameterName>=<ParameterValue>&rs:Format=<PDF/CSV/XML/Excel/MHTML>
> > Hope this helps.
> >
> > Regards,
> >
> > Enrique Martinez
> > Sr. Software Consultant
> These are generic PDF files, not based on a report so they cannot be
> rendered. We are using Reporting Services to provide security not
> only to reports, but also some ancillary PDF and Excel files.
>

Embedded images cause export to .pdf to fail.

I am using an embedded image of a signature on my report. It is a small
.jpg. When I run and print the report, everything is ok. When I try to
export it to pdf, the report stops rendering the report when it gets to the
image. I am using Adobe v.7. I tried this using Adobe v.5 and the whole
report renders except the signature image. Does anyone have an idea how i
can get around this?I found the answer was to change the embedded image from a .jpg format to a
.bmp format. I guess that adobe has a had time renedering images that were
in .jpg format.
"Chris Arnold" wrote:
> I am using an embedded image of a signature on my report. It is a small
> .jpg. When I run and print the report, everything is ok. When I try to
> export it to pdf, the report stops rendering the report when it gets to the
> image. I am using Adobe v.7. I tried this using Adobe v.5 and the whole
> report renders except the signature image. Does anyone have an idea how i
> can get around this?

embed office document

is it at all feasible to embed an office doument (specifically word) into an ssrs report so that the document will print out when renderered to pdf?
No, this is really not possible. You would need to translate the text into RDL to do this. We are looking at the ability to provide rich text formatting (including embedded HTML) in a future release.|||Please add this feature.

embed barcode in pdf

We export a report (pdf format) from Reporting Services that contains
barcodes. If someone tries to view the pdf on a computer that doesn't have
the barcode font loaded it doesn't show up. Is there a way to embed the
barcode image in the pdf?
Thanks,
TimPerhaps someone else will jump in but I am pretty sure there is no way to
embed the font in RS 2005.
RS 2008 will have barcode support (part of the Dundas controls that
Microsoft purchased and is including in RS 2008). This support will allow
you to get around this problem. Today your only choice is to have anyone
that needs to print barcodes to have the font on their machine.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Tim Kelley" <tkelley@.company.com> wrote in message
news:u4W0JmwpIHA.4292@.TK2MSFTNGP04.phx.gbl...
> We export a report (pdf format) from Reporting Services that contains
> barcodes. If someone tries to view the pdf on a computer that doesn't
> have the barcode font loaded it doesn't show up. Is there a way to embed
> the barcode image in the pdf?
> Thanks,
> Tim
>

emailsubscription - eventpolling, but no notificationpolling

Hi,
>From script i'm sending a few emails with pdf attachments.
One report is mailed, two others not. The script for creating the
subscriptions is equal, only different parameters.
When I look in the logfiles I don't see any errors, however only the
succeeded report has both event- and notificationpolling logging.
So the logging for the succeeded one is:
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:52::
EventPolling processing item f21fb887-9e00-40c5-8fac-f246ad14bd4f
ReportingServicesService!dbpolling!194!30.04.2005-05:49:52::
EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!library!1240!04/30/2005-05:49:53:: Schedule
3461442c-d51f-4701-9413-a5bef0d283a0 executed at 04/30/2005 05:49:53.
ReportingServicesService!schedule!1240!04/30/2005-05:49:53:: Creating
Time based subscription notification for subscription:
3424547a-9e5a-4e74-8bd1-78af62a38490
ReportingServicesService!library!1240!04/30/2005-05:49:53:: Schedule
3461442c-d51f-4701-9413-a5bef0d283a0 execution completed at 04/30/2005
05:49:53.
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
EventPolling finished processing item
f21fb887-9e00-40c5-8fac-f246ad14bd4f
ReportingServicesService!dbpolling!194!30.04.2005-05:49:53::
EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
EventPolling processing item 351c51cd-2274-4218-b92e-f05ebdcc0bcb
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
EventPolling finished processing item
351c51cd-2274-4218-b92e-f05ebdcc0bcb
ReportingServicesService!dbpolling!194!30.04.2005-05:49:54::
NotificationPolling processing 1 more items. 1 Total items in internal
queue.
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:54::
NotificationPolling processing item
72b719c2-1ae2-4e7a-a096-b15364e8ebd4
ReportingServicesService!library!1240!04/30/2005-05:49:55:: i INFO:
Call to RenderFirst( '/KEAS/KEASReports/Analyse' )
ReportingServicesService!library!1240!04/30/2005-05:49:56:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server
system properties.
ReportingServicesService!emailextension!1240!04/30/2005-05:49:57::
Email successfully sent to "spitz@.tiscali.nl" <spitz@.tiscali.nl>
ReportingServicesService!library!1240!04/30/2005-05:49:57:: Data Driven
Notification for activation id eff41ff5-c76d-4ced-be63-377e82daf4bb was
saved.
ReportingServicesService!library!1240!04/30/2005-05:49:57:: Status:
Mail sent to spitz@.tiscali.nl;
ReportingServicesService!notification!1240!04/30/2005-05:49:57::
Notification 72b719c2-1ae2-4e7a-a096-b15364e8ebd4 completed. Success:
True, Status: Mail sent to spitz@.tiscali.nl;, DeliveryExtension: Report
Server Email, Report: Analyse, Attempt 0
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:57::
NotificationPolling finished processing item
72b719c2-1ae2-4e7a-a096-b15364e8ebd4
The logging for the ones that are not mailed (the subscriptions are
created):
ReportingServicesService!dbpolling!194!30.04.2005-05:48:52::
EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1240!04/30/2005-05:48:52::
EventPolling processing item a3d3a5e0-4634-4f32-ab10-8564fa09be40
ReportingServicesService!library!1240!04/30/2005-05:48:52:: Schedule
54043fb7-5eec-4063-ae6e-a0ed054e538c executed at 04/30/2005 05:48:52.
ReportingServicesService!schedule!1240!04/30/2005-05:48:52:: Creating
Time based subscription notification for subscription:
9e5701ab-2fc5-48ab-8290-ae05f55fb29f
ReportingServicesService!library!1240!04/30/2005-05:48:53:: Schedule
54043fb7-5eec-4063-ae6e-a0ed054e538c execution completed at 04/30/2005
05:48:53.
ReportingServicesService!dbpolling!194!30.04.2005-05:48:53::
EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
EventPolling finished processing item
a3d3a5e0-4634-4f32-ab10-8564fa09be40
ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
EventPolling processing item 7efce5e2-8cca-4e87-9ac9-f2bac7ad68ff
ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
EventPolling finished processing item
7efce5e2-8cca-4e87-9ac9-f2bac7ad68ff
The securitysettings for all reports are equal.
The failed jobs are also not mailed if started from sqlagent (although
they succeed as sqlagentjob)
Any suggestions are more than welcome, since i have no clue how to
solve this!
Regards jespHave you tried viewing the subscriptions through Report Manager? Perhaps
something is not set up correctly causing the subscription to not fire
correctly.
Have you tried creating the same subscriptions through Report Manager?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"jesp" <spitz@.tiscali.nl> wrote in message
news:1115007058.978980.232660@.o13g2000cwo.googlegroups.com...
> Hi,
>>From script i'm sending a few emails with pdf attachments.
> One report is mailed, two others not. The script for creating the
> subscriptions is equal, only different parameters.
> When I look in the logfiles I don't see any errors, however only the
> succeeded report has both event- and notificationpolling logging.
> So the logging for the succeeded one is:
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:52::
> EventPolling processing item f21fb887-9e00-40c5-8fac-f246ad14bd4f
> ReportingServicesService!dbpolling!194!30.04.2005-05:49:52::
> EventPolling processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!library!1240!04/30/2005-05:49:53:: Schedule
> 3461442c-d51f-4701-9413-a5bef0d283a0 executed at 04/30/2005 05:49:53.
> ReportingServicesService!schedule!1240!04/30/2005-05:49:53:: Creating
> Time based subscription notification for subscription:
> 3424547a-9e5a-4e74-8bd1-78af62a38490
> ReportingServicesService!library!1240!04/30/2005-05:49:53:: Schedule
> 3461442c-d51f-4701-9413-a5bef0d283a0 execution completed at 04/30/2005
> 05:49:53.
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
> EventPolling finished processing item
> f21fb887-9e00-40c5-8fac-f246ad14bd4f
> ReportingServicesService!dbpolling!194!30.04.2005-05:49:53::
> EventPolling processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
> EventPolling processing item 351c51cd-2274-4218-b92e-f05ebdcc0bcb
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
> EventPolling finished processing item
> 351c51cd-2274-4218-b92e-f05ebdcc0bcb
> ReportingServicesService!dbpolling!194!30.04.2005-05:49:54::
> NotificationPolling processing 1 more items. 1 Total items in internal
> queue.
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:54::
> NotificationPolling processing item
> 72b719c2-1ae2-4e7a-a096-b15364e8ebd4
> ReportingServicesService!library!1240!04/30/2005-05:49:55:: i INFO:
> Call to RenderFirst( '/KEAS/KEASReports/Analyse' )
> ReportingServicesService!library!1240!04/30/2005-05:49:56:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
> system properties.
> ReportingServicesService!emailextension!1240!04/30/2005-05:49:57::
> Email successfully sent to "spitz@.tiscali.nl" <spitz@.tiscali.nl>
> ReportingServicesService!library!1240!04/30/2005-05:49:57:: Data Driven
> Notification for activation id eff41ff5-c76d-4ced-be63-377e82daf4bb was
> saved.
> ReportingServicesService!library!1240!04/30/2005-05:49:57:: Status:
> Mail sent to spitz@.tiscali.nl;
> ReportingServicesService!notification!1240!04/30/2005-05:49:57::
> Notification 72b719c2-1ae2-4e7a-a096-b15364e8ebd4 completed. Success:
> True, Status: Mail sent to spitz@.tiscali.nl;, DeliveryExtension: Report
> Server Email, Report: Analyse, Attempt 0
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:57::
> NotificationPolling finished processing item
> 72b719c2-1ae2-4e7a-a096-b15364e8ebd4
> The logging for the ones that are not mailed (the subscriptions are
> created):
> ReportingServicesService!dbpolling!194!30.04.2005-05:48:52::
> EventPolling processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!1240!04/30/2005-05:48:52::
> EventPolling processing item a3d3a5e0-4634-4f32-ab10-8564fa09be40
> ReportingServicesService!library!1240!04/30/2005-05:48:52:: Schedule
> 54043fb7-5eec-4063-ae6e-a0ed054e538c executed at 04/30/2005 05:48:52.
> ReportingServicesService!schedule!1240!04/30/2005-05:48:52:: Creating
> Time based subscription notification for subscription:
> 9e5701ab-2fc5-48ab-8290-ae05f55fb29f
> ReportingServicesService!library!1240!04/30/2005-05:48:53:: Schedule
> 54043fb7-5eec-4063-ae6e-a0ed054e538c execution completed at 04/30/2005
> 05:48:53.
> ReportingServicesService!dbpolling!194!30.04.2005-05:48:53::
> EventPolling processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
> EventPolling finished processing item
> a3d3a5e0-4634-4f32-ab10-8564fa09be40
> ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
> EventPolling processing item 7efce5e2-8cca-4e87-9ac9-f2bac7ad68ff
> ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
> EventPolling finished processing item
> 7efce5e2-8cca-4e87-9ac9-f2bac7ad68ff
>
> The securitysettings for all reports are equal.
> The failed jobs are also not mailed if started from sqlagent (although
> they succeed as sqlagentjob)
> Any suggestions are more than welcome, since i have no clue how to
> solve this!
> Regards jesp
>sql

emailing excel and pdf not working

I can email Web Archive reports successfully. However, I cannot send reports
in Excel or PDF.
I have Acrobat Pro 6 installed.
I DO NOT have Excel 2003 installed, but I can if necessary.
Did I missing a configuration step or something?Afte a few weeks of troubleshooting I got it to work. It was totally
unrelated to RS.
"Matt Temple" <mtemple@.dslextreme.com> wrote in message
news:10djruhppn13j04@.corp.supernews.com...
> I can email Web Archive reports successfully. However, I cannot send
reports
> in Excel or PDF.
> I have Acrobat Pro 6 installed.
> I DO NOT have Excel 2003 installed, but I can if necessary.
> Did I missing a configuration step or something?
>

Emailing a Report on the Fly

Hi,
I am rendering a report in PDF Format using web services API using a click
of a button which its doing perfectly.
As soon as this report is rendered in PDF format, Is there a way to send
him a particular user this report by Email thru C# FrontEnd.
An Email has to be sent when a report is rendered by the user automatically
using WebServices API.
plz put some sample code as well.
I am doing from C# in Winforms
Thanks For ur help
Thanks
Chandra
--
Message posted via http://www.sqlmonster.comThis is not built into RS so you would need to call the mail library
yourself. We would like to add a "send now" feature but it won't make it
into SQL 2005.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chandra Kotha via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in
message news:fb6aea0a57554e4cbbda5c3bef6d90ff@.SQLMonster.com...
> Hi,
> I am rendering a report in PDF Format using web services API using a click
> of a button which its doing perfectly.
> As soon as this report is rendered in PDF format, Is there a way to send
> him a particular user this report by Email thru C# FrontEnd.
> An Email has to be sent when a report is rendered by the user
> automatically
> using WebServices API.
> plz put some sample code as well.
> I am doing from C# in Winforms
> Thanks For ur help
> Thanks
> Chandra
> --
> Message posted via http://www.sqlmonster.com|||Thanks very much I will be using Mail API from C#.NET
--
Message posted via http://www.sqlmonster.com

Email Export?

Hello,

In the Crystal Report Viewer control, there is a way to export a report to the file format of choice (i.e. pdf or xls) and have it emailed.

This is probably a stupid question, but I have to ask it...

Is there a way to have an exported report in SSRS 2005 emailed without saving the report and then attaching it to an email?

I know about the scheduling services, but that will not work for me as my reports are created dynamically and displayed throught the ASP.NET 2.0 Report Viewer Control.

Thanks!!!

-Brian

Hi,

Have you tried Report Subscription using "Report Server E-mail" option? In BOL this is discussed under "E-Mail Delivery in Reporting Services". While configuring reports to be sent as an email you can include the report as a link or/and as an attachment.

HTH

Uday

|||

There is no supported email export. If you use the Viewer controls then your app could export the report and then send the email. Your app would have to take care of all smtp settings however.

-Daniel

|||

Thanks for the response Uday, but as noted in my original post, the report is created dynamically and not a published report. I cannot use the Scheduling/Subscription functionality...

-Brian

|||

Not built-into the ReportViewer control. Since you are sitting in code already, it is possible to wire this up really quickly using the classes in the System.Web.Mail namespace.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I am guessing I would need to use the ReportViewer's RenderStream method, but I cannot find good documentation on the parameters that are needed to call this method (i.e. streamId, mimeType, etc...). Which ones are required? I know what each does from the MSDN documentation, but I am looking for an example of this in use.

I am calling the RenderStream method and passing in empty strings (String.Empty) for each of the parameters and I am getting the following error:

"The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady)"

Any Ideas?

Thanks!

-Brian

Email Export?

Hello,

In the Crystal Report Viewer control, there is a way to export a report to the file format of choice (i.e. pdf or xls) and have it emailed.

This is probably a stupid question, but I have to ask it...

Is there a way to have an exported report in SSRS 2005 emailed without saving the report and then attaching it to an email?

I know about the scheduling services, but that will not work for me as my reports are created dynamically and displayed throught the ASP.NET 2.0 Report Viewer Control.

Thanks!!!

-Brian

Hi,

Have you tried Report Subscription using "Report Server E-mail" option? In BOL this is discussed under "E-Mail Delivery in Reporting Services". While configuring reports to be sent as an email you can include the report as a link or/and as an attachment.

HTH

Uday

|||

There is no supported email export. If you use the Viewer controls then your app could export the report and then send the email. Your app would have to take care of all smtp settings however.

-Daniel

|||

Thanks for the response Uday, but as noted in my original post, the report is created dynamically and not a published report. I cannot use the Scheduling/Subscription functionality...

-Brian

|||

Not built-into the ReportViewer control. Since you are sitting in code already, it is possible to wire this up really quickly using the classes in the System.Web.Mail namespace.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I am guessing I would need to use the ReportViewer's RenderStream method, but I cannot find good documentation on the parameters that are needed to call this method (i.e. streamId, mimeType, etc...). Which ones are required? I know what each does from the MSDN documentation, but I am looking for an example of this in use.

I am calling the RenderStream method and passing in empty strings (String.Empty) for each of the parameters and I am getting the following error:

"The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady)"

Any Ideas?

Thanks!

-Brian

Email Attachment Problem

Hi all,
I create a subscription to send the report (in pdf format) to users once every week. The subscription works, all users manage to receive the email but some of them do not have the pdf file attached to the email. Anyone know what is wrong?

DarenSounds like a firewall setting blocking attachments on those emails.|||

Hi,

just wondering if you found a fix for this problem cause I have te same problem.

I noticed that the problem somehow connects to Outlook, cause when i retreve the mail in my Web-mailclient I get an attachment and in my version of Outlook (version 2003 English) there is the attachment and the size of the mail remains the same..

Lucas

|||Hi IjoNL,
I could not find any solution to it, but there's a temporary solution to this is ask the person to try and forward the email they received in outlook then they will find the attachment file there.

Daren

Email Attachment Problem

Hi all,
I create a subscription to send the report (in pdf format) to users once every week. The subscription works, all users manage to receive the email but some of them do not have the pdf file attached to the email. Anyone know what is wrong?

DarenSounds like a firewall setting blocking attachments on those emails.|||

Hi,

just wondering if you found a fix for this problem cause I have te same problem.

I noticed that the problem somehow connects to Outlook, cause when i retreve the mail in my Web-mailclient I get an attachment and in my version of Outlook (version 2003 English) there is the attachment and the size of the mail remains the same..

Lucas

|||Hi IjoNL,
I could not find any solution to it, but there's a temporary solution to this is ask the person to try and forward the email they received in outlook then they will find the attachment file there.

Daren

email a pdf report

I don't know if this is a bug or not. I have SP1 and used the web
service to render the report in PDF format. The report renders fine
but when I click on the email button it asks me if I want to email the
url or the report itself. I choose the latter. When it attached the
report in the email, I notice that the extension of the report is aspx
and not PDF. So, I test the email by sending it to myself. I have to
save the report as PDF extension in order to view as PDF otherwise it
me garbage. I wonder this is a bug. Thanks.I assume you are using your own ASP.NET application that calls the RS web
service then displays the result to your users. Your application needs to
set the ContentType property of the ASP.NET response object, and perhaps the
content-disposition HTTP header. Doing this will tell IE how to display the
data your page is returning.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jeff" <Jeff@.discussions.microsoft.com> wrote in message
news:ADB7C080-8FC7-49DE-89FA-0104A9FF0915@.microsoft.com...
> This is happening to me too...
> "powerranger" wrote:
> > I don't know if this is a bug or not. I have SP1 and used the web
> > service to render the report in PDF format. The report renders fine
> > but when I click on the email button it asks me if I want to email the
> > url or the report itself. I choose the latter. When it attached the
> > report in the email, I notice that the extension of the report is aspx
> > and not PDF. So, I test the email by sending it to myself. I have to
> > save the report as PDF extension in order to view as PDF otherwise it
> > me garbage. I wonder this is a bug. Thanks.
> >