SQL Validator in Jasper7.8 is blocking WITH or REGEXP_REPLACE function in sub-query. It works fine on commenting the function lines, what are your options if you don't want to disable the SQL Validator?
Release : Any
Component : CLARITY JASPERSOFT
If you don't wish to disable the SQL Validator but just allow for this function: