SSRS and Classic ASP

[JScannell]

I inadvertently posted this in "SQL Server Programming". It really belongs here:

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

 

[v0520]

It would be easier to simply use the report viewer control and write an asp.net page to invoke the report.
In other words, your .asp page would simply do a response.redirect("youraspnetpage.aspx) and it should work.

Alternatively, since you are using asp, you could call the ssrs reporting services web service via the soap toolkit and be able to render a pdf image of a report in asp.

As I said, easier to simply start using asp.net, asp.net is much better than asp.



Gilbert M. Vanegas
Programmer Analyst III
County of San Bernardino - ISD
Email : gvanegas@isd.sbcounty.gov

 

[bburnell]

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.

I agree with Gilbert, just use asp.net from the get-go and it will be much easier. There's plenty of examples for you to work off of to get you started.
~Brett

--------------------------
Web/.net Programmer & DBA
Central PA