Hi,
Using CR XI. I have a dynamic cascading prompt - 3 mutiple value parameters. 2 of these are strings. One is a number.
In my selection criteria, I am building it as a formula by checking for 'all' conditions in each of them. therefore whenever a particular parameter is not an all, i add a condition
fieldname = [{?parameter}] (if its a string) and
fieldname in {?parameter} (if its a number).
The number part works, the other 2 dont work in the selection. I am able to retreive data only for one of the selected values.
I tried to display the parameter value using a formula
Join({?parameter},", ")
but i get an error - 'a string array is required here'
I dont know y its behaving this way.
Any help would be greatly appreciated.
Thanks,
Rrgkanth.
Using CR XI. I have a dynamic cascading prompt - 3 mutiple value parameters. 2 of these are strings. One is a number.
In my selection criteria, I am building it as a formula by checking for 'all' conditions in each of them. therefore whenever a particular parameter is not an all, i add a condition
fieldname = [{?parameter}] (if its a string) and
fieldname in {?parameter} (if its a number).
The number part works, the other 2 dont work in the selection. I am able to retreive data only for one of the selected values.
I tried to display the parameter value using a formula
Join({?parameter},", ")
but i get an error - 'a string array is required here'
I dont know y its behaving this way.
Any help would be greatly appreciated.
Thanks,
Rrgkanth.