for-each-group:G_1[columnvalue=1];./FIELDVALUE first use filter followed by grouping

might be due to syntax errors please upload RTF template with sample xml data. will send you updated RTF . Thanks

modified Template working as expected , i have issue in uploading dcoument , please share your email , i will farward. Thanks

sent , please check

This is the format to import from catalog to main template , import:xdoxsl:///Customer Reports/Templates/Common Components.xsb Make sure you are saving sub template in shared folder otherwise you have to do extra configuration. still issues , please post complete log file.

please create two data sets within 1 data model and generate xml and upload here , Thanks

My suggestion is apply all logic in data source and filter in RTF template example : create a custom column in sql query , logic for this column is if column value start with A, B,C,D,E,F then name it as value1 , for G TO P name it as value2 and for R name it as value 3 , once you are created column , the column will have…

for filter use for-each-group:G_1[custom_column='value1']

https://docs.oracle.com/middleware/12211/bip/BIPRD/GUID-43E24DE3-F1DE-47E1-8B2F-C8ED59D619BA.htm#BIPRD3069

what is the version of bip ? There are problems with 11g even though you delete the job from bip UI , but still entry not deleted from backened, so better pause the job with owner who created then recreate job with different name with required owner. Thanks

References : https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-C5A6173D-9D9A-47BD-9F8E-45A72B5E08A4.htm#BIPRD2532

if its null value in database then you can use database functions like create one column using function case when element is null then 'put here your value' end column_name. you can use at RTF level : required value or edit data model , go to column properties , there you will find ifnull function , just replace own value…

first please check in bip data model how the null value is generating. example in bip 12c null value can be treated as '' in bip 11g it will treat as '*' , sometimes RTF template wont recognise null as null it will treat as * value. please try with different combinations as '' or '*'.

xdofx:if $FAC!='*' then 'ALL FACILITIES' else $FAC end if ?> ,replace $fac with your variable OR <?xdofx:if $FAC!='' then 'ALL FACILITIES' else $FAC end if

what exactly my variable is storing ? it is number or varchar. what is the source for myvariable ?

can you upload xml and rtf template. Thanks

please mark it as correct so that we can close thread.

for 2007 office , you can use any 11g version

are you scheduling the report to email server , if yes then you can schedule trigger https://docs.oracle.com/middleware/12212/bip/BIPDM/GUID-30C07845-5BCD-4D02-A829-BA6D85B8599D.htm#BIPDM389

looks this is not related to bip (but we can implemnent VPD in BIP to restrict row or column level security , VPD (virtual private database) if you are asking about how set up VPD then =please ask question in oracle database community.