Parameters in record selection criteria

[Katy44]

I have a feeling I'm missing something very obvious!
I have a parameter in my report which is selected to allow multiple values. I understand that these values get passed into the report as an array, and I've messed around with them to get the values in the array displayed on the report. How do I use this array in my record selection formula: {Table.Field} in /is one of {?MyParamField}?

Do I have to loop through the array and build up the selection string? There must be an easier way!

 

[dgillz]

Try this:

{YourField} in {?YourParameter}

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[Katy44]

I have that at the moment, but it doesn't seem to affect my results. If that usually works though, I will go and have another look.

 

[dgillz]

are you sure your parameter is a multi-value parameter?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[Katy44]

I chose "Allow multiple values" and left the discrete /range option as discrete only. I have already used a loop to put each member of the array in a string and put that on the report.

 

[Katy44]

I've just created a very simple report to try this out, and it works as you said it should.
There's obviously another reason why this isn't working on my other report.
Thanks for your help, I would have spent a long time assuming that this was the problem!

 

[dgillz]

No need to create a loop to get the parameters on your report, provided that they are string data type. Use the Join() function.

Join({?YourMVParm},",")

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[poujor]

The yntax to use in the Record selection formula is : {YourField} = {?YourParameter} no matter if
{?YourParameter} is a single or multi-valued parameter

 

[Katy44]

Thank you both for your help. It is working now - I was being very stupid and not realising that all the figures on my report were in subreports, and so the parameters needed to be passed through to the subreports!