Friday, March 23, 2012

PDF Downloads & ASP

I have a web application (ASP, COM+, SQLServer2K) that uses my own VB COM
components and a Crystal Reports component (a 5mb component) that takes a CR
report that I designed (about 1mb in size), executes it, and exports it as a
PDF file to the server's hard disk ready for download by my users.
Having just come across Reporting Services, it would appear to me that I
could ditch Crystal and go with Reporting Services exclusively. However, in
my browsing I have not come across how to do this with Reporting Services
without using the Report Manager (my users are "anonymous" web users and do
not have access to the server directly) and I can't seem to find any
examples of how to recreate the process I described above.
Questions:
1) Can Reporting Services run a report, and export it as PDF to server hard
drive without user intervention (or using Report Manager)?
2) Can I expect faster processing of reports with Reporting Services
compared to Crystal on the server (my Crystal reports depends entirely on
SPs in SQLServer)?
3) Are there programming examples of using Reporting Services with VB and
ASP, particularly involving PDF export and download?
Thanks for any tips or directions.1) Yes
2) don't know
3) you need to use the web service interface to interact with RS, so you
will need to look for code with uses ASP and Web services then apply what
you learn to the RS web service interface. Most code I have seen assumes
ASP.NET since the web service integration is "trouble free"
hope this helps.
dlr
"Don Miller" <nospam@.nospam.com> wrote in message
news:%234erUYMnEHA.1564@.TK2MSFTNGP09.phx.gbl...
> I have a web application (ASP, COM+, SQLServer2K) that uses my own VB COM
> components and a Crystal Reports component (a 5mb component) that takes a
CR
> report that I designed (about 1mb in size), executes it, and exports it as
a
> PDF file to the server's hard disk ready for download by my users.
> Having just come across Reporting Services, it would appear to me that I
> could ditch Crystal and go with Reporting Services exclusively. However,
in
> my browsing I have not come across how to do this with Reporting Services
> without using the Report Manager (my users are "anonymous" web users and
do
> not have access to the server directly) and I can't seem to find any
> examples of how to recreate the process I described above.
> Questions:
> 1) Can Reporting Services run a report, and export it as PDF to server
hard
> drive without user intervention (or using Report Manager)?
> 2) Can I expect faster processing of reports with Reporting Services
> compared to Crystal on the server (my Crystal reports depends entirely on
> SPs in SQLServer)?
> 3) Are there programming examples of using Reporting Services with VB and
> ASP, particularly involving PDF export and download?
> Thanks for any tips or directions.
>

No comments:

Post a Comment