Wrox Programmer Forums
|
Reporting Services SQL Server Reporting Services. Please specify which version.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Reporting Services section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 26th, 2007, 07:03 PM
Registered User
 
Join Date: Sep 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default ASP 3.0 and SSRS?

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.





Similar Threads
Thread Thread Starter Forum Replies Last Post
SSRS 2005 Integration with ASP.Net Applications jeetu.bhagchandani Reporting Services 0 June 7th, 2008 11:56 AM
SSRS: Custom reports naveenjv Reporting Services 1 October 12th, 2007 02:17 AM
SSRS Custom Report iSheahan BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 0 February 8th, 2007 12:52 PM
Print problem in SSRS hthakkar BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 0 March 14th, 2006 09:20 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.