Kostya,
Thank you so much for taking a look at this. I understand what you are trying to do and I was optimistic that it was going to work, but when I syntax check the record selection formula, CR highlights the
{?ParamField}[2] in the first isnull function and it says, "A field is required here".
I noticed the "and" was right up against the right parenthesis and thought maybe that was the problem, but it wasn't.
UPDATE: I just read in another forum that IsNull() is only for database fields. Don't know if that's correct or not, but if it is then that would explain the error.
ANOTHER UPDATE: I changed all of the IsNull() functions to
{?ParamField}[2] = ''
That got rid of the "A field is required here" syntax error, but when I run the report I'm back to the error message...........
"A subscript must be between 1 and the size of the array".
When I run the report I'm only selecting 1 of the 4 possible values. I wonder if the problem is that CR only sees the ParamField array to be a length of one because that's all that was selected. If so, I don't know how to check how many of these options the user has picked.
As I'm typing this I'm thinking maybe there's some kind of ArrayLength() function I could use.
I hate CR. Especially this Ver. 10
I don't understand how we can be 3 versions behind the most current one.
YET ANOTHER UPDATE: I think I've got it. The array size theory seems to be the way to go. I changed the comparison to be.......
if UBound({?ParamField}) = 1
then {ChemString} like "*{?ParamField}[1]*"
else
if UBound({?ParamField}) = 2
then {ChemString} like "*{?ParamField}[1]*" + "*{?ParamField}[2]*"
etc. etc.
Thanks for your help!!!
Edited by ChiBlackhawks - 13 Feb 2012 at 11:00am
IP Logged
