Conditional format in BI publisher 10.1.3.4.1
In above report I need to print two column
values (Dept & Backlog WO’s Except
SD) in red
color if the
Backlog WO’s Except SD count was greater than 20%
So we need to do conditional format in RTF
template.
When I am doing conditional format in RTF
template I am getting below error
Error: The conditional format is not inside a table and
can therefore not be applied to a table row
But this is the bug.
For this issue there was one work around.
1)
Create one dummy table as shown
in below screen shot.
2)
In first row insert few fields
as shown in below screen shot.
3)
Select any field and click on
create conditional format
4)
I already having the percentage
field…. So I am giving the condition according to my requirement as shown in below screen shot.
5)
To check whether conditional
format is working or not just create a group as shown in below screen shot.
And load sample XML to
check conditional format
And the preview is
Here we applied
conditional format only for skill field. So it will display in red.
Now copy the conditional
field from dummy table and past in original table like below.
Note: Copy only conditional format i.e C
And copy to original table
(TO both columns Dept & Backlog WO’s
Except SD ) as shown in below screen shot.
Now delete the dummy table
and click on preview.
If you want to apply to
entire row … there will be one check box we need to check (Apply to entire row)
check that box and apply to original table.
Output will be as below.
No comments:
Post a Comment