February 6, 2014

Error: The conditional format is not inside a table and can therefore not be applied to a table row (RTF template work around for this error)


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