I currently use Crystal Reports RDC that is called from an ASP 3.0 page (actually, the ASP page calls my custom VB
COM+ code which then calls then RDC), supplies a CustomerID as a parameter to generate a report (e.g. on one customer) that is then exported as a PDF file and saved to the filesystem on the server. That PDF is then available for download by end-users in my web application (i.e. as a link). Since the move to Win2003/SQL Server 2005 one of the Crystal components is misbehaving and I'd like to move this report entirely to SSRS.
However, my entire web application is classic ASP 3.0 (and will not be changing anytime soon). So what I'd like to do is call a web service with a parameter from my ASP 3.0 page (e.g. CustomerID), have the web service generate the report, save the PDF file on the server, and return back to the ASP page the path to the PDF file. Except I don't know how to do this and cannot find any examples of using ASP 3.0 with SSRS. I can probably do some limited ASP.NET 2.0 programming to create the web service but need help doing that (if necessary).
Can someone please direct me to examples of how to use ASP 3.0 and SSRS together? Or tell me if I'm going about it the wrong way (e.g. do I even need to save the PDF on the server)?
Thanks for any help or direction.