Wrox Programmer Forums
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional 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 10th, 2004, 02:16 PM
Authorized User
Join Date: Jun 2003
Posts: 10
Thanks: 0
Thanked 1 Time in 1 Post
Default Pass parameter to store procedure & 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 viewer.

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!
The Following User Says Thank You to quinn For This Useful Post:

Similar Threads
Thread Thread Starter Forum Replies Last Post
Crystal Report Parameter pass from c# shriji.1111 Crystal Reports 4 June 14th, 2011 11:38 AM
How to pass parameter to a crystal report using c# preetakrish BOOK: Professional Crystal Reports for VS.NET 16 November 19th, 2009 05:26 AM
pass parameter in crystal report srivigdev C# 3 April 14th, 2008 12:11 PM
Parameterized CRystal report & Stored procedure jay4ever_2000 ASP.NET 1.0 and 1.1 Professional 3 June 6th, 2006 08:53 AM
How to Pass parameter to chart in crystal Report. simsimlhr C# 3 April 12th, 2004 11:04 AM

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