Kbase 18442: Report Builder - Case Function Can Handle Only 10 Conditions
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/12/1998 |
|
Solution ID: 18442
SYMPTOM(s):
Report Builder does not allow more than 10 conditions in the Case function. If you try to put more conditions, you get the error message.
"Too many arguments to function".
This is presently a limitation of the CASE function and an enhancement request has been logged to expand the limit. This solution provides two ways to work around the error.
FIX:
1) You can nest one CASE function within another.
For example:
CASE(item-num, 1, "one", 2, "two", 3, "three", 4, "four", 5, "five", 6, "six", 7, "seven", 8, "eight", 9, "nine", CASE(item-num, 10, "ten", 11, "eleven", 12,
"twelve", 13, "thirteen", 14, "fourteen",""))
OR
2) Use the IIF function for all the items/conditions.