How to flter XML BI Publisher report in RTF Template

Question

How do I combine filter conditions in an RTF Template?

Desired filter condition:

APPLICATION=('AC','LD')
AND 
CATEGORY=('1001','1002')

I tried using <?for-each-group:G_1[contains(category,'1001')];./grouping_element?>, but it is filtering with only one condition.

Early i Used ,But It Filtering Only with one value – Imranullah Syed Nov 30 '16 at 05:41 — Imranullah Syed, Nov 30 '16 at 05:41

score 1 · Answer 1 · answered Dec 06 '16 at 16:23

1

You can use AND and OR in the standard filters.

<?for-each-group:G_1[(category="1001" or category="1002") and (application="LD" or application ="AC")];./grouping_element?>

answered Dec 06 '16 at 16:23

EdHayes3

score 0 · Answer 2 · edited May 27 '19 at 10:30

0

Refer Below & change accordingly,

<?for-each:G_MAIN?><?if@row:(contains(TASK_NUMBER,'-00-000') or contains(TASK_NUMBER,'0000'))?>

edited May 27 '19 at 10:30

Bhargav Rao

answered May 27 '19 at 10:07

Abbas

2 Answers2