Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
|
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 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 May 6th, 2009, 12:05 PM
Registered User
 
Join Date: May 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to skibear99 Send a message via Yahoo to skibear99
Cool Multiple Input Parameters for Stored Proc.

I'm writing a Crystal Report to supplement the native G/L Reports for our Accounting Database. (MAS 500 - SQL 2005). (Crystal Reports Ver 10.)

What I'd like to do is give the user the opportunity to select more than one G/L Account (or Dept, etc.) in the report.

I know how to write a stored procedure which would look at the data passed from the report to select just one Account. What I'm not sure about is how to use the Allow Multiple values property of Crystal Reports in conjunction with the Stored Proc.

Previous searching has led me to the subject of Arrays. As somewhat of a newbie programmer, would this be the way to go? If so, how to create the array, and associate it with the desired parameter?

Hope that I've been clear in my request.





Similar Threads
Thread Thread Starter Forum Replies Last Post
unicode parameters in stored proc CharityPays SQL Server 2000 1 November 12th, 2006 12:02 AM
stored proc input parameter ttbhandari SQL Server ASP 2 October 14th, 2004 02:47 PM
problems with stored proc and output parameters zieg42 VB.NET 2002/2003 Basics 1 June 12th, 2004 07:11 AM
Optional Stored Proc Parameters? VBAHole22 SQL Server 2000 3 August 13th, 2003 11:46 AM
Passing Parameters to Stored Proc mdillard Classic ASP Professional 6 June 10th, 2003 10:35 PM





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