Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Hi, Thanks for your reply, but I disagree. Our experience and testing demonstrate the opposite of what you say. If the output of my query (in the filter) returns a string longer than 56 characters, all other filters are blocked and grayed out, making them inaccessible. Could you tell me why? thanks Regards Rosita
-
Hi, I found the problem, and it seems to be solved with REPLACE(REPLACE(REPLACE(REGEXP_REPLACE(TO_CHAR(SUBSTR(xxxtl.name, 0, 99)), '<[^>]*>', ' '), '&', '&'), '"', '”'), ' ', ' ') or SUBSTR(xxxtl.name, 1, 56) as name on the filter "Titolo corso". I also found a post with a similar problem: Oracle BI Report > Parameter…