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
Showing posts with label allows. Show all posts
Showing posts with label allows. Show all posts
Monday, March 12, 2012
Wednesday, March 7, 2012
RS formatting ?
Hi all,
I have a report that allows users to choose one or more parameter
values and then a report is rendered based off of that input. I have a
table that I want to always have 8 rows, but if the report returns only
2 rows I need to add 6 blank rows to the end of the table. If the
report returns only 5 rows, I need 3 blank rows added to the end of the
table, and so on. Does anyone have any idea how to do this in RS?
Thanks in advance.Quite simple.
Two ways.
One - write custom sql script, count amount of rows and add needed empty
ones to the resulting output.
sql stored procedure or a set of sql statements will do just fine.
Second one - write a custom dataset extension. get a simple dataset from the
sql server ( ore whatever data source of your choice) and within data
processing extesion implementation - just add empty rows
as
dataset.Tables[0].Rows.Add(dataset.Tables[0].NewRow())
"aggiechick717" <mhoppe@.chkenergy.com> wrote in message
news:1163189494.473934.172880@.f16g2000cwb.googlegroups.com...
> Hi all,
> I have a report that allows users to choose one or more parameter
> values and then a report is rendered based off of that input. I have a
> table that I want to always have 8 rows, but if the report returns only
> 2 rows I need to add 6 blank rows to the end of the table. If the
> report returns only 5 rows, I need 3 blank rows added to the end of the
> table, and so on. Does anyone have any idea how to do this in RS?
>
> Thanks in advance.
>
I have a report that allows users to choose one or more parameter
values and then a report is rendered based off of that input. I have a
table that I want to always have 8 rows, but if the report returns only
2 rows I need to add 6 blank rows to the end of the table. If the
report returns only 5 rows, I need 3 blank rows added to the end of the
table, and so on. Does anyone have any idea how to do this in RS?
Thanks in advance.Quite simple.
Two ways.
One - write custom sql script, count amount of rows and add needed empty
ones to the resulting output.
sql stored procedure or a set of sql statements will do just fine.
Second one - write a custom dataset extension. get a simple dataset from the
sql server ( ore whatever data source of your choice) and within data
processing extesion implementation - just add empty rows
as
dataset.Tables[0].Rows.Add(dataset.Tables[0].NewRow())
"aggiechick717" <mhoppe@.chkenergy.com> wrote in message
news:1163189494.473934.172880@.f16g2000cwb.googlegroups.com...
> Hi all,
> I have a report that allows users to choose one or more parameter
> values and then a report is rendered based off of that input. I have a
> table that I want to always have 8 rows, but if the report returns only
> 2 rows I need to add 6 blank rows to the end of the table. If the
> report returns only 5 rows, I need 3 blank rows added to the end of the
> table, and so on. Does anyone have any idea how to do this in RS?
>
> Thanks in advance.
>
Saturday, February 25, 2012
RS and J2EE High Level Architecture Question
I am looking for a tool that allows me to generate lists, mailmerged letters
and reports from a J2EE application. Are there strong reasons in favor or
against RS, specifically in regard to integrating via the Web Service API?
Can I wrap RS in a J2EE-based interface and stream reports through the
application server, as opposed to exposing the RS management interface to
the end users?
Thanks for your input.Christian,
> I am looking for a tool that allows me to generate lists, mailmerged
letters
> and reports from a J2EE application. Are there strong reasons in favor or
> against RS, specifically in regard to integrating via the Web Service API?
This is one of the RS strongest points because with RS reports are
web-enabled by default. In other words, once you deploy your report to the
report catalog there is nothing you have to do to expose it over the web.
> Can I wrap RS in a J2EE-based interface and stream reports through the
> application server, as opposed to exposing the RS management interface to
> the end users?
You bet. You can generate RS reports on the server-side your J2EE
application by calling the RS Render SOAP API. In addtion, the Report Server
supports URL addressibility where a HTTP-GET request is generated on the
client side of the application. You should carefully evaluate both SOAP and
URL addressibility to find out which one meets your app requirements better.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Christian Donner" <stealthcdonner@.stealthmolecular.comremovestealth> wrote
in message news:esT536OlEHA.3760@.TK2MSFTNGP12.phx.gbl...
> I am looking for a tool that allows me to generate lists, mailmerged
letters
> and reports from a J2EE application. Are there strong reasons in favor or
> against RS, specifically in regard to integrating via the Web Service API?
> Can I wrap RS in a J2EE-based interface and stream reports through the
> application server, as opposed to exposing the RS management interface to
> the end users?
> Thanks for your input.
>|||Christian,
I don't see why not. the web service methods for RS include the RENDER
method. Since this is a SOAP call which returns a byte array (representing
the rendered report) RS is client agnostic. have at it.
hope this helps.
dlr
"Christian Donner" <stealthcdonner@.stealthmolecular.comremovestealth> wrote
in message news:esT536OlEHA.3760@.TK2MSFTNGP12.phx.gbl...
> I am looking for a tool that allows me to generate lists, mailmerged
letters
> and reports from a J2EE application. Are there strong reasons in favor or
> against RS, specifically in regard to integrating via the Web Service API?
> Can I wrap RS in a J2EE-based interface and stream reports through the
> application server, as opposed to exposing the RS management interface to
> the end users?
> Thanks for your input.
>
and reports from a J2EE application. Are there strong reasons in favor or
against RS, specifically in regard to integrating via the Web Service API?
Can I wrap RS in a J2EE-based interface and stream reports through the
application server, as opposed to exposing the RS management interface to
the end users?
Thanks for your input.Christian,
> I am looking for a tool that allows me to generate lists, mailmerged
letters
> and reports from a J2EE application. Are there strong reasons in favor or
> against RS, specifically in regard to integrating via the Web Service API?
This is one of the RS strongest points because with RS reports are
web-enabled by default. In other words, once you deploy your report to the
report catalog there is nothing you have to do to expose it over the web.
> Can I wrap RS in a J2EE-based interface and stream reports through the
> application server, as opposed to exposing the RS management interface to
> the end users?
You bet. You can generate RS reports on the server-side your J2EE
application by calling the RS Render SOAP API. In addtion, the Report Server
supports URL addressibility where a HTTP-GET request is generated on the
client side of the application. You should carefully evaluate both SOAP and
URL addressibility to find out which one meets your app requirements better.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Christian Donner" <stealthcdonner@.stealthmolecular.comremovestealth> wrote
in message news:esT536OlEHA.3760@.TK2MSFTNGP12.phx.gbl...
> I am looking for a tool that allows me to generate lists, mailmerged
letters
> and reports from a J2EE application. Are there strong reasons in favor or
> against RS, specifically in regard to integrating via the Web Service API?
> Can I wrap RS in a J2EE-based interface and stream reports through the
> application server, as opposed to exposing the RS management interface to
> the end users?
> Thanks for your input.
>|||Christian,
I don't see why not. the web service methods for RS include the RENDER
method. Since this is a SOAP call which returns a byte array (representing
the rendered report) RS is client agnostic. have at it.
hope this helps.
dlr
"Christian Donner" <stealthcdonner@.stealthmolecular.comremovestealth> wrote
in message news:esT536OlEHA.3760@.TK2MSFTNGP12.phx.gbl...
> I am looking for a tool that allows me to generate lists, mailmerged
letters
> and reports from a J2EE application. Are there strong reasons in favor or
> against RS, specifically in regard to integrating via the Web Service API?
> Can I wrap RS in a J2EE-based interface and stream reports through the
> application server, as opposed to exposing the RS management interface to
> the end users?
> Thanks for your input.
>
Subscribe to:
Posts (Atom)