Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
| Search | Today's Posts | Mark Forums Read
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports 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
  #1 (permalink)  
Old March 16th, 2005, 04:37 AM
Registered User
 
Join Date: Mar 2005
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Crystal Reports and Stored Procedures

Hi,

Im just learning to produce reports from sql stored procedures. I have done some basic ones using SELECT statements etc. I know want to look at putting parameters in the stored procedures and cant find any literature to help me.

1. Can you use a pick list in stored procedures, like you can when using parameters in Crystal? and can anybody provide an example

2. Can you prompt the user for a value in stored procedures, ie, for example the user is asked What month are you looking for and they then type in May as an answer? again can anybody provide an example

3. Can you pass a WHERE clause through a stored procedure, i.e hardcode it in, i,e, WHERE month = 'May' for instance and can you provide me with an example

4. Also are there any good webpages where you can learn more about stored procedures

Thanks

Mark

  #2 (permalink)  
Old March 30th, 2005, 08:09 PM
Authorized User
 
Join Date: Jun 2003
Location: Rochester, NY, USA.
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
Default

markw,

Can't believe 90 read this post and didn't contribute anything. Here's a good link to get you started on Sproc:

http://www.4guysfromrolla.com/webtech/111499-1.shtml

HtH.


Similar Threads
Thread Thread Starter Forum Replies Last Post
STORED PROCEDURES shazia1 SQL Server ASP 7 September 26th, 2007 06:11 AM
Print a Crystal Reports from Stored procedures bogcip SQL Server 2000 5 May 9th, 2007 05:26 AM
Using Stored Procedures In Crystal Report 9 uday.chikorde Crystal Reports 0 April 6th, 2006 09:19 AM
Stored Procedures stu9820 ASP.NET 1.x and 2.0 Application Design 2 January 15th, 2005 04:09 AM
Crystal 9 and stored procedures with dynamic sql Pravs VB How-To 0 December 9th, 2004 05:48 AM





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