Stored Procedure: Get parameters from Crystal Report
Posted on 2003-12-12
I pass multiple paramter values from Crystal Report to a SP, I have a Division parameter, may have multiple values, let say i have 4 values: 1, 2, 3, and 4. I pass those values into SP.
In SP, how could I declare a variable to accept multiple values pass in, and how to extract those values from the variable I just declare?
And with a range value (i.e. Age Range between 20 - 40), how could we handle it?
Please give me an example to do that.
thanks in advance