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.
|