Formula to determine if a parameter is Array

[chris777]

I need to create a formula to display parameter value(s) entered by the user. The parameter is a Multiple Discrete.

I am having trouble with it as there can be multiple or a single value. If there is only one value I can't use JOIN, so I am trying to figure out a way to determine if the parameter is a distinct value or multiple (array) value and then use the appropriate CASE to display the value(s).

I have been trying to determine a way to COUNT the number of values in the parameter but the COUNT function doesn't work. I don't know of any kind of IS ARRAY? type test.

Any ideas?

Chris


Chris
DFW Crystal User Group

http://www.dfwcug.com

 

[dgillz]

I have never tried this, but:

If Count({?ParmField})>1 then <<logic on how to treat arrays>> else <<logic on how to treat single values>>

Let me know if that works

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

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[chris777]

The COUNT function was the first thing I tried, but I get an error: &quot;The Summary/Running Total total could not be created&quot;

Thanks.

Chris
DFW Crystal User Group

http://www.dfwcug.com

 

[dgillz]

I just tested this in version 8.5 developer and it works:

if count({?Parm})>1 then join({?Parm},&quot;, &quot else {?Parm}[1]

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

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[chris777]

You're right. I had an mistake in my parameter that I missed, which was causing the error.

Thanks.

Chris
DFW Crystal User Group

http://www.dfwcug.com

 

[lbass]

I believe the join function works even if only one parameter (string) value is selected, so maybe the initial problem with join was also because of the parameter error.

-LB

 

[chelseatech]

An array with one item will still work okay with join.

Where JOIN doesn't work is if it is a range or single value parameter.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm