I have a web based application that allows users to apply for
employment via the web. Once the appllcaition is submitted I want to
send the details to HR via email using SSRS 2005.
I'm not very familiar with rs.exe utility which is the tool I think I
need to use.
I would appreciate it if anyone has done something like this before
and can point me in the right direction it would be greatly
appreciated.On Sep 14, 4:51 pm, NC3 <ncolem...@.yahoo.com> wrote:
> I have a web based application that allows users to apply for
> employment via the web. Once the appllcaition is submitted I want to
> send the details to HR via email using SSRS 2005.
> I'm not very familiar with rs.exe utility which is the tool I think I
> need to use.
> I would appreciate it if anyone has done something like this before
> and can point me in the right direction it would be greatly
> appreciated.
One alternative is to design an ASP.NET application that sends emails
and then attach a URL to the email that basically allows the user to
export the report to a standard format (i.e., PDF). An example of a
URL to send in an email is as follows:
http://ServerA/reportserver?/ExampleReportFolderName/ExampleReportName&rs:Command=Render&ParameterName=xxxxx&rs:Format=PDF
In this example, the format is as follows:
http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=Render&<ParameterName>=<ParameterValue>&rs:Format=<PDF/CSV/XML/Excel/MHTML>
Of course, if you have multiple parameters you would include extra '&'
symbols and parameter values; and, you could change the export format.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Sep 14, 10:49 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Sep 14, 4:51 pm, NC3 <ncolem...@.yahoo.com> wrote:
> > I have a web based application that allows users to apply for
> > employment via the web. Once the appllcaition is submitted I want to
> > send the details to HR via email using SSRS 2005.
> > I'm not very familiar with rs.exe utility which is the tool I think I
> > need to use.
> > I would appreciate it if anyone has done something like this before
> > and can point me in the right direction it would be greatly
> > appreciated.
> One alternative is to design an ASP.NET application that sends emails
> and then attach a URL to the email that basically allows the user to
> export the report to a standard format (i.e., PDF). An example of a
> URL to send in an email is as follows:http://ServerA/reportserver?/Exampl=
eReportFolderName/ExampleReportNam...
> In this example, the format is as follows:
> http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=3DR=
ende=ADr&<ParameterName>=3D<ParameterValue>&rs:Format=3D<PDF/CSV/XML/Excel/=MHTML>
> Of course, if you have multiple parameters you would include extra '&'
> symbols and parameter values; and, you could change the export format.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Thanks for the response...
One important detail I did not mention is we have security concerns
sending plain text emails from the Internet. I want to send the email
after the DB is updated so the email is secure in transmission.|||On Sep 17, 2:54 pm, NC3 <ncolem...@.yahoo.com> wrote:
> On Sep 14, 10:49 pm, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Sep 14, 4:51 pm, NC3 <ncolem...@.yahoo.com> wrote:
> > > I have a web based application that allows users to apply for
> > > employment via the web. Once the appllcaition is submitted I want to
> > > send the details to HR via email using SSRS 2005.
> > > I'm not very familiar with rs.exe utility which is the tool I think I
> > > need to use.
> > > I would appreciate it if anyone has done something like this before
> > > and can point me in the right direction it would be greatly
> > > appreciated.
> > One alternative is to design an ASP.NET application that sends emails
> > and then attach a URL to the email that basically allows the user to
> > export the report to a standard format (i.e., PDF). An example of a
> > URL to send in an email is as follows:http://ServerA/reportserver?/Exam=
pleReportFolderName/ExampleReportNam...
> > In this example, the format is as follows:
> > http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=
=3DRende=ADr&<ParameterName>=3D<ParameterValue>&rs:Format=3D<PDF/CSV/XML/Ex=cel/MHTML>
> > Of course, if you have multiple parameters you would include extra '&'
> > symbols and parameter values; and, you could change the export format.
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Thanks for the response...
> One important detail I did not mention is we have security concerns
> sending plain text emails from the Internet. I want to send the email
> after the DB is updated so the email is secure in transmission.
Have you considered an SSL certificate? This should secure the
download part of the process. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Sep 17, 9:08 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Sep 17, 2:54 pm, NC3 <ncolem...@.yahoo.com> wrote:
>
>
> > On Sep 14, 10:49 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > > On Sep 14, 4:51 pm, NC3 <ncolem...@.yahoo.com> wrote:
> > > > I have a web based application that allows users to apply for
> > > > employment via the web. Once the appllcaition is submitted I want to
> > > > send the details to HR via email using SSRS 2005.
> > > > I'm not very familiar with rs.exe utility which is the tool I think= I
> > > > need to use.
> > > > I would appreciate it if anyone has done something like this before
> > > > and can point me in the right direction it would be greatly
> > > > appreciated.
> > > One alternative is to design an ASP.NET application that sends emails
> > > and then attach a URL to the email that basically allows the user to
> > > export the report to a standard format (i.e., PDF). An example of a
> > > URL to send in an email is as follows:http://ServerA/reportserver?/Ex=
ampleReportFolderName/ExampleReportNam...
> > > In this example, the format is as follows:
> > > http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=
=3DRende=AD=ADr&<ParameterName>=3D<ParameterValue>&rs:Format=3D<PDF/CSV/XML=/Excel/MHTML>
> > > Of course, if you have multiple parameters you would include extra '&'
> > > symbols and parameter values; and, you could change the export format.
> > > Hope this helps.
> > > Regards,
> > > Enrique Martinez
> > > Sr. Software Consultant
> > Thanks for the response...
> > One important detail I did not mention is we have security concerns
> > sending plain text emails from the Internet. I want to send the email
> > after the DB is updated so the email is secure in transmission.
> Have you considered an SSL certificate? This should secure the
> download part of the process. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant- Hide quoted text -
> - Show quoted text -
Will having an SSL in place secure an email from an ASP.NET
application in transit? That's our true concern...securing the data in
transit.
Thanks again for you help.|||On Sep 18, 1:03 pm, NC3 <ncolem...@.yahoo.com> wrote:
> On Sep 17, 9:08 pm, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Sep 17, 2:54 pm, NC3 <ncolem...@.yahoo.com> wrote:
> > > On Sep 14, 10:49 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > > > On Sep 14, 4:51 pm, NC3 <ncolem...@.yahoo.com> wrote:
> > > > > I have a web based application that allows users to apply for
> > > > > employment via the web. Once the appllcaition is submitted I want= to
> > > > > send the details to HR via email using SSRS 2005.
> > > > > I'm not very familiar with rs.exe utility which is the tool I thi=nk I
> > > > > need to use.
> > > > > I would appreciate it if anyone has done something like this befo=re
> > > > > and can point me in the right direction it would be greatly
> > > > > appreciated.
> > > > One alternative is to design an ASP.NET application that sends emai=ls
> > > > and then attach a URL to the email that basically allows the user to
> > > > export the report to a standard format (i.e., PDF). An example of a
> > > > URL to send in an email is as follows:http://ServerA/reportserver?/=
ExampleReportFolderName/ExampleReportNam...
> > > > In this example, the format is as follows:
> > > > http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Comma=
nd=3DRende=AD=ADr&<ParameterName>=3D<ParameterValue>&rs:Format=3D<PDF/CSV/X=ML/Excel/MHTML>
> > > > Of course, if you have multiple parameters you would include extra ='&'
> > > > symbols and parameter values; and, you could change the export form=at.
> > > > Hope this helps.
> > > > Regards,
> > > > Enrique Martinez
> > > > Sr. Software Consultant
> > > Thanks for the response...
> > > One important detail I did not mention is we have security concerns
> > > sending plain text emails from the Internet. I want to send the email
> > > after the DB is updated so the email is secure in transmission.
> > Have you considered an SSL certificate? This should secure the
> > download part of the process. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant- Hide quoted text -
> > - Show quoted text -
> Will having an SSL in place secure an email from an ASP.NET
> application in transit? That's our true concern...securing the data in
> transit.
> Thanks again for you help.
For the email itself, I'm not completely sure; however, an SSL
certificate will improve security at the website level. In terms of
the exported report, you might want to look into some 3rd party PGP/
Encryption tools. There are a couple available that are open source
and some that aren't. This option should provide protection in
transit. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Sep 19, 8:28 am, EMartinez <emartinez...@.gmail.com> wrote:
> On Sep 18, 1:03 pm, NC3 <ncolem...@.yahoo.com> wrote:
>
>
> > On Sep 17, 9:08 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > > On Sep 17, 2:54 pm, NC3 <ncolem...@.yahoo.com> wrote:
> > > > On Sep 14, 10:49 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > > > > On Sep 14, 4:51 pm, NC3 <ncolem...@.yahoo.com> wrote:
> > > > > > I have a web based application that allows users to apply for
> > > > > > employment via the web. Once the appllcaition is submitted I wa=nt to
> > > > > > send the details to HR via email using SSRS 2005.
> > > > > > I'm not very familiar with rs.exe utility which is the tool I t=hink I
> > > > > > need to use.
> > > > > > I would appreciate it if anyone has done something like this be=fore
> > > > > > and can point me in the right direction it would be greatly
> > > > > > appreciated.
> > > > > One alternative is to design an ASP.NET application that sends em=ails
> > > > > and then attach a URL to the email that basically allows the user= to
> > > > > export the report to a standard format (i.e., PDF). An example of= a
> > > > > URL to send in an email is as follows:http://ServerA/reportserver=
?/ExampleReportFolderName/ExampleReportNam...
> > > > > In this example, the format is as follows:
> > > > > http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Com=
mand=3DRende=AD=AD=ADr&<ParameterName>=3D<ParameterValue>&rs:Format=3D<PDF/=CSV/XML/Excel/MHTML>
> > > > > Of course, if you have multiple parameters you would include extr=a '&'
> > > > > symbols and parameter values; and, you could change the export fo=rmat.
> > > > > Hope this helps.
> > > > > Regards,
> > > > > Enrique Martinez
> > > > > Sr. Software Consultant
> > > > Thanks for the response...
> > > > One important detail I did not mention is we have security concerns
> > > > sending plain text emails from the Internet. I want to send the ema=il
> > > > after the DB is updated so the email is secure in transmission.
> > > Have you considered an SSL certificate? This should secure the
> > > download part of the process. Hope this helps.
> > > Regards,
> > > Enrique Martinez
> > > Sr. Software Consultant- Hide quoted text -
> > > - Show quoted text -
> > Will having an SSL in place secure an email from an ASP.NET
> > application in transit? That's our true concern...securing the data in
> > transit.
> > Thanks again for you help.
> For the email itself, I'm not completely sure; however, an SSL
> certificate will improve security at the website level. In terms of
> the exported report, you might want to look into some 3rd party PGP/
> Encryption tools. There are a couple available that are open source
> and some that aren't. This option should provide protection in
> transit. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant- Hide quoted text -
> - Show quoted text -
Your responses have been a big help. Thanks for the advice!|||On Sep 19, 4:07 pm, NC3 <ncolem...@.yahoo.com> wrote:
> On Sep 19, 8:28 am, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Sep 18, 1:03 pm, NC3 <ncolem...@.yahoo.com> wrote:
> > > On Sep 17, 9:08 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > > > On Sep 17, 2:54 pm, NC3 <ncolem...@.yahoo.com> wrote:
> > > > > On Sep 14, 10:49 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > > > > > On Sep 14, 4:51 pm, NC3 <ncolem...@.yahoo.com> wrote:
> > > > > > > I have a web based application that allows users to apply for
> > > > > > > employment via the web. Once the appllcaition is submitted I =want to
> > > > > > > send the details to HR via email using SSRS 2005.
> > > > > > > I'm not very familiar with rs.exe utility which is the tool I= think I
> > > > > > > need to use.
> > > > > > > I would appreciate it if anyone has done something like this =before
> > > > > > > and can point me in the right direction it would be greatly
> > > > > > > appreciated.
> > > > > > One alternative is to design an ASP.NET application that sends =emails
> > > > > > and then attach a URL to the email that basically allows the us=er to
> > > > > > export the report to a standard format (i.e., PDF). An example =of a
> > > > > > URL to send in an email is as follows:http://ServerA/reportserv=
er?/ExampleReportFolderName/ExampleReportNam...
> > > > > > In this example, the format is as follows:
> > > > > > http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:C=
ommand=3DRende=AD=AD=ADr&<ParameterName>=3D<ParameterValue>&rs:Format=3D<PD=F/CSV/XML/Excel/MHTML>
> > > > > > Of course, if you have multiple parameters you would include ex=tra '&'
> > > > > > symbols and parameter values; and, you could change the export =format.
> > > > > > Hope this helps.
> > > > > > Regards,
> > > > > > Enrique Martinez
> > > > > > Sr. Software Consultant
> > > > > Thanks for the response...
> > > > > One important detail I did not mention is we have security concer=ns
> > > > > sending plain text emails from the Internet. I want to send the e=mail
> > > > > after the DB is updated so the email is secure in transmission.
> > > > Have you considered an SSL certificate? This should secure the
> > > > download part of the process. Hope this helps.
> > > > Regards,
> > > > Enrique Martinez
> > > > Sr. Software Consultant- Hide quoted text -
> > > > - Show quoted text -
> > > Will having an SSL in place secure an email from an ASP.NET
> > > application in transit? That's our true concern...securing the data in
> > > transit.
> > > Thanks again for you help.
> > For the email itself, I'm not completely sure; however, an SSL
> > certificate will improve security at the website level. In terms of
> > the exported report, you might want to look into some 3rd party PGP/
> > Encryption tools. There are a couple available that are open source
> > and some that aren't. This option should provide protection in
> > transit. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant- Hide quoted text -
> > - Show quoted text -
> Your responses have been a big help. Thanks for the advice!
You're welcome. Glad I could be of assistance. Let me know if I can be
of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant
