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.
>

PDC - SQLServer Reporting Services Beta Install

I am having difficulty installing the server components of the SQLServer
Reporting Services Beta copy I received at the PDC. My server is the domain
controller for a small home network, and I received the following error:
An error occurred while applying security settings. <machineName>\ASPNET is
not a valid user or group.
This could be a problem with the package, or a problem connecting to a
domain controller on the
network. Check your network connection and click Retry, or Cancel to end
the install.
I have verified that the ASPNET machine account exists - but I suspect a
recent upgrade from .NET framework 1.0 to 1.1 may have influenced this
error. I would like to try changing the account that the Report Server Web
Service runs as, but I don't see an option to accomodate thisoption.
Does anyone have any suggestions?
I have the following installed:
Recently upgraded .NET Framework from 1.0 to 1.1
Windows 2000 Server
SQLServer Standard Edition, SP3a
Thanks in advance,
RobYou might have more luck posting this message on the RS newsgroup.
It's :- microsoft.beta.reporting.services.general
--
HTH
Ryan Waight, MCDBA, MCSE
"Rob Patterson" <rpatterson@.ztr.com> wrote in message
news:uRRZqKGpDHA.384@.tk2msftngp13.phx.gbl...
> I am having difficulty installing the server components of the SQLServer
> Reporting Services Beta copy I received at the PDC. My server is the
domain
> controller for a small home network, and I received the following error:
> An error occurred while applying security settings. <machineName>\ASPNET
is
> not a valid user or group.
> This could be a problem with the package, or a problem connecting to a
> domain controller on the
> network. Check your network connection and click Retry, or Cancel to end
> the install.
> I have verified that the ASPNET machine account exists - but I suspect a
> recent upgrade from .NET framework 1.0 to 1.1 may have influenced this
> error. I would like to try changing the account that the Report Server
Web
> Service runs as, but I don't see an option to accomodate thisoption.
> Does anyone have any suggestions?
> I have the following installed:
> Recently upgraded .NET Framework from 1.0 to 1.1
> Windows 2000 Server
> SQLServer Standard Edition, SP3a
> Thanks in advance,
> Rob
>|||How do I subscribe to microsoft.beta.reporting.services.general
I have a similar problem, but I am unable to subscribe.
Thanks,
Hanna