SQL Server 2005 Reporting Services and Classic ASP

[JScannell]

I am about to delve into a new area. I will be creating report(s) with SQL Server 2005 Reporting Services, and then calling them with Classic ASP.

Has anybody done that before? How do you call the report? I can only presume you need a connection object and come kind of command object (similar in nature to one you'd use to call a stored proc, but designed to interface with a report). But I don't have a clue what to do.

I will eventually be migrating to ASP.NET but at the present time don't know how to use it. I do have to create and run the report, though, right away.

Anything you can do will be appreciated.

Thanks,

Jerry Scannell

 

[mkal]

Not sure you would need to. SQL 2005 Reporting Services has it's own portal that you can deploy reports to. Once reports are deployed you can assign permissions for users to view the reports.

After installing if you accepted the defaults the portal can be found

http://localhost/reports

or replace <localhost> with the name of the computer.

 

[JScannell]

So I fully understand, if I install SQL Server 2005 after I install IIS, then a report portal will be created?

What would happen if SQL Server 2005 happened to be installed first? Can you add the portal in later if you want?

Thanks,

Jerry Scannell