Kbase 18652: Report Builder - ENTRY Function in RB Ignores Null Value
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/11/1999 |
|
SUMMARY:
Report Builder -- If a customer is trying to use the ENTRY() function to get a value and there is a null value in the list, it will skip
the null item.
EXPLANATION:
For example, ENTRY(3, "1,2,,4") returns "4" instead of "" because Report Builder skips the third item. It doesn't matter what
delimiter is used.
SOLUTION:
In order to get around this, use the REPLACE() function to
replace the null value with a space. (When you have the null value,
you will have two delimiters together.)
ENTRY(3,REPLACE(entrytest ,"*" + "*", "*" + " " + "*"),"*")
This was logged as a Version 8 bug and fixed in version 9.1.