Hello, Q1, Q2, Q4: Around encoding the BLOB column to Base64 in Oracle SQL, I recommend asking in their Forums here: https://forums.oracle.com/ords/apexds/domain/dev-community/category/3063-general_questions or here: https://forums.oracle.com/ords/apexds/domain/dev-community/category/sql_and_pl_sql Q3: I could not find…

Hello Jef, The decimal and grouping separator symbols used, are determined at runtime based on template locale. And this is a fixed value that you can't change based on Data. It is determined when you create the Template, thus having a Template for each locale is necessary, specially for currencies. Please see on…

Hello User_BPRZY, I recommend using Bursting and separate Templates. You can control which Template is used when doing Bursting, by using a CASE Clause. Your Bursting Query needs the CASE Clause in the TEMPLATE, like this example: select distinct DEPARTMENT_ID as "KEY", CASE WHEN DEPARTMENT_ID = 50 THEN 'Dep 50' ELSE…

Hello Shubham, There is no current way to get these details from backend. An option is to check from Reports Job history, which is not viable in case the expected count is too high. There is an idea raised already to expose backend tables:…

Hello Jayashree, You can find it on the Data Model Properties (Left side panel). There is a section "XML Output Options", there's the "Include Empty Tags for Null Elements" checkbox. Jorge