Emailing report details

Hi,
I have a simple report that displays a page of text. I want to add a
button to it and
when the button is clicked a new outlook email is created with the
report as body, ready for the user to enter an email address.
Yes I know reports have subscriptions, they want a more adhoc
solution.
And users don't want the extra clicks of saving the report to file and
attaching it themselves.
Can it be done, is there an example?
thanks in advance.On Aug 1, 11:07 pm, paulhux...@.hotmail.com wrote:
> Hi,
> I have a simple report that displays a page of text. I want to add a
> button to it and
> when the button is clicked a new outlook email is created with the
> report as body, ready for the user to enter an email address.
> Yes I know reports have subscriptions, they want a more adhoc
> solution.
> And users don't want the extra clicks of saving the report to file and
> attaching it themselves.
> Can it be done, is there an example?
> thanks in advance.
There are not really any options available for this type of
functionality (aside from what you mentioned). If exporting the report
to PDF and attaching it to an email is an option, I would suggest
going the custom/ASP.NET application route. There is an open source
library available that can assist you in doing this: iTextSharp
(http://sourceforge.net/projects/itextsharp/http://itextsharp.sourceforge.net/tutorial/
). Otherwise, you will need to design a custom application that
includes a report viewer control that incorporates an SSRS report.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Aug 3, 11:31 am, EMartinez <emartinez...@.gmail.com> wrote:
> On Aug 1, 11:07 pm, paulhux...@.hotmail.com wrote:
> > Hi,
> > I have a simple report that displays a page of text. I want to add a
> > button to it and
> > when the button is clicked a new outlook email is created with the
> > report as body, ready for the user to enter an email address.
> > Yes I know reports have subscriptions, they want a more adhoc
> > solution.
> > And users don't want the extra clicks of saving the report to file and
> > attaching it themselves.
> > Can it be done, is there an example?
> > thanks in advance.
> There are not really any options available for this type of
> functionality (aside from what you mentioned). If exporting the report
> to PDF and attaching it to an email is an option, I would suggest
> going the custom/ASP.NET application route. There is an open source
> library available that can assist you in doing this: iTextSharp
> (http://sourceforge.net/projects/itextsharp/http://itextsharp.sourceforge.net/tutorial/
> ). Otherwise, you will need to design a custom application that
> includes a report viewer control that incorporates an SSRS report.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
****************************
thanks Enrique|||On Aug 2, 9:05 pm, paulhux...@.hotmail.com wrote:
> On Aug 3, 11:31 am, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Aug 1, 11:07 pm, paulhux...@.hotmail.com wrote:
> > > Hi,
> > > I have a simple report that displays a page of text. I want to add a
> > > button to it and
> > > when the button is clicked a new outlook email is created with the
> > > report as body, ready for the user to enter an email address.
> > > Yes I know reports have subscriptions, they want a more adhoc
> > > solution.
> > > And users don't want the extra clicks of saving the report to file and
> > > attaching it themselves.
> > > Can it be done, is there an example?
> > > thanks in advance.
> > There are not really any options available for this type of
> > functionality (aside from what you mentioned). If exporting the report
> > to PDF and attaching it to an email is an option, I would suggest
> > going the custom/ASP.NET application route. There is an open source
> > library available that can assist you in doing this: iTextSharp
> > (http://sourceforge.net/projects/itextsharp/http://itextsharp.sourcefo...
> > ). Otherwise, you will need to design a custom application that
> > includes a report viewer control that incorporates an SSRS report.
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> ****************************
> thanks Enrique
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Email on demand

Looking for an example of sending a 2005 RS report via a web page on demand.
I would need to fire it when a user clicked a button on the web form.
In the old days, in plain old ASP, we used to build an HTML formatted email
body and then fire it off using CDO. We could still do that with ASPX but
I'd much prefer to build a report in RS (more formatting and doc type options)
and then fire it off.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1On Oct 3, 1:07 pm, "wnichols via SQLMonster.com" <u3357@.uwe> wrote:
> Looking for an example of sending a 2005 RS report via a web page on demand.
> I would need to fire it when a user clicked a button on the web form.
> In the old days, in plain old ASP, we used to build an HTML formatted email
> body and then fire it off using CDO. We could still do that with ASPX but
> I'd much prefer to build a report in RS (more formatting and doc type options)
> and then fire it off.
> --
> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1
This link should help.
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
You will want to create a Proxy (Web Reference) to
ReportingService2005.asmx. Then attach the newly created file to an
email created via ASP.NET. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Enrique,
Thanks for the info.
EMartinez wrote:
>> Looking for an example of sending a 2005 RS report via a web page on demand.
>> I would need to fire it when a user clicked a button on the web form.
>[quoted text clipped - 6 lines]
>> --
>> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1
>This link should help.
>http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
>You will want to create a Proxy (Web Reference) to
>ReportingService2005.asmx. Then attach the newly created file to an
>email created via ASP.NET. Hope this helps.
>Regards,
>Enrique Martinez
>Sr. Software Consultant
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1|||On Oct 4, 11:04 am, "wnichols via SQLMonster.com" <u3357@.uwe> wrote:
> Enrique,
> Thanks for the info.
>
> EMartinez wrote:
> >> Looking for an example of sending a 2005 RS report via a web page on demand.
> >> I would need to fire it when a user clicked a button on the web form.
> >[quoted text clipped - 6 lines]
> >> --
> >> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1
> >This link should help.
> >http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingser...
> >You will want to create a Proxy (Web Reference) to
> >ReportingService2005.asmx. Then attach the newly created file to an
> >email created via ASP.NET. Hope this helps.
> >Regards,
> >Enrique Martinez
> >Sr. Software Consultant
> --
> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Email Column

Can we provide an outlook based email column so that as the email is
clicked. directly outlook opens with to mail column. so tha we can directly
send the email as they click corresponding column.
Navin.DHi,
Why dont u have a link of "mailto:chathurangaw@.zone24x7.com " for that
column
on the column u need the link... right click and select properties,->
Advanced
then give an expression for the jump to URL of the navigation tab...
it's real simple...
Chathuranga
NAVIN.D wrote:
> Can we provide an outlook based email column so that as the email is
> clicked. directly outlook opens with to mail column. so tha we can directly
> send the email as they click corresponding column.
> Navin.D|||There are some 10,000 records filled in directly from dbase for that email
column, can you please provide the expression.
"chathurangakw@.gmail.com" wrote:
> Hi,
> Why dont u have a link of "mailto:chathurangaw@.zone24x7.com " for that
> column
> on the column u need the link... right click and select properties,->
> Advanced
> then give an expression for the jump to URL of the navigation tab...
> it's real simple...
> Chathuranga
>
> NAVIN.D wrote:
> > Can we provide an outlook based email column so that as the email is
> > clicked. directly outlook opens with to mail column. so tha we can directly
> > send the email as they click corresponding column.
> >
> > Navin.D
>|||Assuming the db field is email... The Action URL might be
="mailto:" & Fields!email.Value
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"NAVIN.D" wrote:
> There are some 10,000 records filled in directly from dbase for that email
> column, can you please provide the expression.
> "chathurangakw@.gmail.com" wrote:
> > Hi,
> >
> > Why dont u have a link of "mailto:chathurangaw@.zone24x7.com " for that
> > column
> > on the column u need the link... right click and select properties,->
> > Advanced
> > then give an expression for the jump to URL of the navigation tab...
> >
> > it's real simple...
> >
> > Chathuranga
> >
> >
> > NAVIN.D wrote:
> > > Can we provide an outlook based email column so that as the email is
> > > clicked. directly outlook opens with to mail column. so tha we can directly
> > > send the email as they click corresponding column.
> > >
> > > Navin.D
> >
> >|||the properties for the currently selected item are not valid,please correct
all errors before contuning. Is the error i am getting when i use it
"Wayne Snyder" wrote:
> Assuming the db field is email... The Action URL might be
> ="mailto:" & Fields!email.Value
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "NAVIN.D" wrote:
> > There are some 10,000 records filled in directly from dbase for that email
> > column, can you please provide the expression.
> >
> > "chathurangakw@.gmail.com" wrote:
> >
> > > Hi,
> > >
> > > Why dont u have a link of "mailto:chathurangaw@.zone24x7.com " for that
> > > column
> > > on the column u need the link... right click and select properties,->
> > > Advanced
> > > then give an expression for the jump to URL of the navigation tab...
> > >
> > > it's real simple...
> > >
> > > Chathuranga
> > >
> > >
> > > NAVIN.D wrote:
> > > > Can we provide an outlook based email column so that as the email is
> > > > clicked. directly outlook opens with to mail column. so tha we can directly
> > > > send the email as they click corresponding column.
> > > >
> > > > Navin.D
> > >
> > >|||the properties for the currently selected item are not valid,please correct
all errors before contuning. Is the error i am getting when i use it
Wayne Snyder" wrote:
> Assuming the db field is email... The Action URL might be
> ="mailto:" & Fields!email.Value
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "NAVIN.D" wrote:
> > There are some 10,000 records filled in directly from dbase for that email
> > column, can you please provide the expression.
> >
> > "chathurangakw@.gmail.com" wrote:
> >
> > > Hi,
> > >
> > > Why dont u have a link of "mailto:chathurangaw@.zone24x7.com " for that
> > > column
> > > on the column u need the link... right click and select properties,->
> > > Advanced
> > > then give an expression for the jump to URL of the navigation tab...
> > >
> > > it's real simple...
> > >
> > > Chathuranga
> > >
> > >
> > > NAVIN.D wrote:
> > > > Can we provide an outlook based email column so that as the email is
> > > > clicked. directly outlook opens with to mail column. so tha we can directly
> > > > send the email as they click corresponding column.
> > > >
> > > > Navin.D
> > >
> > >|||Wayne Snyder 's reply should be enough to get it working.... u might
be in a wrong place... I'm talking about the Navigation Tab of a
Properties Dialog-> advanced... for a TextBox|||or a TextBox inside a Table|||tried the same way but get the error as i mentioned
thank you
Navin.D
"chathurangakw@.gmail.com" wrote:
> or a TextBox inside a Table
>

email

I would like to automate a report to be emailed to an email address.
When viewing the report, clicked on new subscription.
In the subscription window what options should there be for Delievered By: ?
I currently have: Report Server File Share in the drop down. Should there be other entries in the list too?
ThanksChange to Report Server Email and make sure that the report server is configured for Email Delivery.

email

I would like to automate a report to be emailed to an email address.
When viewing the report, clicked on new subscription.
In the subscription window what options should there be for Delievered By: ?
I currently have: Report Server File Share in the drop down. Should there be
other entries in the list too?
Thanksyes , you should have 'report serve email ' option too- if you dont, its
because you didnt choose the option at installation time to install SMTP
service.
"farshad" <farshad@.discussions.microsoft.com> wrote in message
news:91C6988E-808B-4049-AFA1-3B7A793F0220@.microsoft.com...
>I would like to automate a report to be emailed to an email address.
> When viewing the report, clicked on new subscription.
> In the subscription window what options should there be for Delievered By:
> ?
> I currently have: Report Server File Share in the drop down. Should there
> be
> other entries in the list too?
> Thanks|||How can I add this option whithout affecting the present instal/settings
please?
"Immy" wrote:
> yes , you should have 'report serve email ' option too- if you dont, its
> because you didnt choose the option at installation time to install SMTP
> service.
> "farshad" <farshad@.discussions.microsoft.com> wrote in message
> news:91C6988E-808B-4049-AFA1-3B7A793F0220@.microsoft.com...
> >I would like to automate a report to be emailed to an email address.
> > When viewing the report, clicked on new subscription.
> > In the subscription window what options should there be for Delievered By:
> > ?
> > I currently have: Report Server File Share in the drop down. Should there
> > be
> > other entries in the list too?
> > Thanks
>
>|||Hello again,
I do not remember seeing the SMTP option during the install.
Please note I am using SSRS 2005. The email we use is loyus notes.
Any thoughts pls?
Thanks
"Immy" wrote:
> yes , you should have 'report serve email ' option too- if you dont, its
> because you didnt choose the option at installation time to install SMTP
> service.
> "farshad" <farshad@.discussions.microsoft.com> wrote in message
> news:91C6988E-808B-4049-AFA1-3B7A793F0220@.microsoft.com...
> >I would like to automate a report to be emailed to an email address.
> > When viewing the report, clicked on new subscription.
> > In the subscription window what options should there be for Delievered By:
> > ?
> > I currently have: Report Server File Share in the drop down. Should there
> > be
> > other entries in the list too?
> > Thanks
>
>|||OK farshad, in RS2000 you have the option at installation time. For 2005 you
need to use the configuration tool.
See link below for steps:
http://msdn2.microsoft.com/en-us/library/ms159155.aspx
Immy
"farshad" <farshad@.discussions.microsoft.com> wrote in message
news:D25E292B-6886-4B0D-AD51-A518AF50BCA8@.microsoft.com...
> Hello again,
> I do not remember seeing the SMTP option during the install.
> Please note I am using SSRS 2005. The email we use is loyus notes.
> Any thoughts pls?
> Thanks
> "Immy" wrote:
>> yes , you should have 'report serve email ' option too- if you dont, its
>> because you didnt choose the option at installation time to install SMTP
>> service.
>> "farshad" <farshad@.discussions.microsoft.com> wrote in message
>> news:91C6988E-808B-4049-AFA1-3B7A793F0220@.microsoft.com...
>> >I would like to automate a report to be emailed to an email address.
>> > When viewing the report, clicked on new subscription.
>> > In the subscription window what options should there be for Delievered
>> > By:
>> > ?
>> > I currently have: Report Server File Share in the drop down. Should
>> > there
>> > be
>> > other entries in the list too?
>> > Thanks
>>