Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server ASP
SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP 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 March 9th, 2004, 02:55 PM
Authorized User
Join Date: Jun 2003
Posts: 10
Thanks: 0
Thanked 1 Time in 1 Post
Default SQL Server 2000, ASP and Crystal Report

I have a report in Crystal that I need to let users view/print his vacation/sick leave report via the web. I can generate a sql query string with the user information through asp and get it to the report. These are the steps I did that user can view the report.

1. A web form with Department dropdown list, Year drop down list, and Type dropdown list.
2. User first selects which department he wants to view, then what year and type of Vacation or Sick Leave from the web form.
3. Then I pass those three parameters(Department, Year, Type) to Crystal Report and display the report in a ActiveX view.

I follow the Crystal Report ASPXMPS8 and ASPXMPS85 examples to achieve this and it is working fine except it takes so long to retrive the data from the database. There is only 3000 records in the database, and I don't think this would affect the performance. I wonder if it would speed up the performance if I use store procedure in SQL server? What are the steps I need to do to do this? Thanks!

Similar Threads
Thread Thread Starter Forum Replies Last Post
VB 2005 Crystal Report Connection with SQL 2000 blackspear BOOK: Professional Crystal Reports for VS.NET 0 December 3rd, 2008 09:49 AM
how to call sql server function in crystal report arumugavel Access VBA 0 November 16th, 2006 12:05 AM
Using Crystal Report with SQL SERVER deepakbachelor Classic ASP Basics 0 June 23rd, 2006 03:02 AM
Crystal Report "Login Failed" windows 2000 server HaniShtine Crystal Reports 0 December 7th, 2005 04:00 PM
benifit of crystal report with asp and sql server ak SQL Server ASP 9 November 24th, 2005 09:14 PM

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