1 2 Previous Next 24 Replies Latest reply: Oct 29, 2013 11:36 AM by 1042851 RSS

    BI Publisher conditional formatting

    @2*728768*
      Hi guys

      Can anyone help me how to apply conditional formatting in BI Publisher rtf file..... for eg if value is less than 0 then data should show in red colour..

      Thanks & regards
        • 1. Re: BI Publisher conditional formatting
          Domnic_BI
          Have a look at this, http://winrichman.blogspot.com/search/label/formatting, it details the steps to be done, if you still cannot figure it out, mail me your template and XML file to domnic26ATgmailDOTcom
          • 2. Re: BI Publisher conditional formatting
            @2*728768*
            hi Domnic

            thanks for your help, i saw the link which you have sent but it is little difficult to do same thing in my report.

            My report has table with 5 columns and VAL is the number column on which i want conditional formatting to be done the below mentioned code i worte in ADVANCED tab by right click table and selected BI Publisher properties and in that window i wrote code in

            i wrote the code below mentioned but while validating template it is giving me an error;

            ERROR:--------[040710_031731066][][ERROR] [Line 553.53] Incorrect XPath: number(VAL[.!="])<0
            <?for-each:/ROWSET/ROW?>
            <?choose@inlines:?><?when@inlines:number(VAL[.!="])<0?>
            <?attribute@incontext:color;'red'?>
            <?end for-each?>
            {code}
            
            Please help me to solve this                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
            • 3. Re: BI Publisher conditional formatting
              Domnic_BI
              send me your template and xml file, my email id is in the previous post.
              • 4. Re: BI Publisher conditional formatting
                @2*728768*
                Hi domnic

                i have sent you files on ur mail... could you please help me in that

                Thanks
                • 5. Re: BI Publisher conditional formatting
                  524753
                  <?for-each:/ROWSET/ROW?>
                  <?if:(VAL!='') and(VAL <0)?><?attribute@incontext:color;'red'?><?end if?>
                  <?end for-each?>
                  do this,
                  • 6. Re: BI Publisher conditional formatting
                    @2*728768*
                    Hi Vetsrini

                    Thanks for your reply.... when i am uploading template then it is giving me below mentioned error.....

                    -2147467261
                    Load report parameters error: object reference set to an instance of an object

                    Could you please tell me what i am doing wrong

                    Regards
                    • 7. Re: BI Publisher conditional formatting
                      @2*728768*
                      Any suggestion please............
                      • 8. Re: BI Publisher conditional formatting
                        @2*728768*
                        I am new to BI Publisher so may be i am writing code at wrong place....

                        Please help me to do this

                        Thanks
                        • 9. Re: BI Publisher conditional formatting
                          524753
                          Paste you xml and xplain the output you needed in here
                          • 10. Re: BI Publisher conditional formatting
                            @2*728768*
                            Hi
                            Please find the xml code for the report and i want VAL value to be red when it is -ve..... i have created simple table format report in word
                              <?xml version="1.0" encoding="UTF-8" ?> 
                            - <ROWSET>
                            - <ROW>
                              <TRAN_DATE>2003-11-14T00:00:00.000+00:00</TRAN_DATE> 
                              <STAT>B</STAT> 
                              <VAL>2086.29</VAL> 
                              </ROW>
                            - <ROW>
                              <TRAN_DATE>2004-07-26T00:00:00.000+01:00</TRAN_DATE> 
                              <STAT>B</STAT> 
                              <VAL>950</VAL> 
                              </ROW>
                            - <ROW>
                              <TRAN_DATE>2006-11-24T00:00:00.000+00:00</TRAN_DATE> 
                              <STAT>B</STAT> 
                              <VAL>11494.95</VAL> 
                              </ROW>
                            - <ROW>
                              <TRAN_DATE>2007-04-02T00:00:00.000+01:00</TRAN_DATE> 
                              <STAT>B</STAT> 
                              <VAL>1188</VAL> 
                              </ROW>
                            - <ROW>
                              <TRAN_DATE>2009-10-07T00:00:00.000+01:00</TRAN_DATE> 
                              <STAT>B</STAT> 
                              <VAL>535</VAL> 
                              </ROW>
                            - <ROW>
                              <TRAN_DATE>2009-10-09T00:00:00.000+01:00</TRAN_DATE> 
                              <STAT>B</STAT> 
                              <VAL>160.5</VAL> 
                              </ROW>
                            - <ROW>
                              <TRAN_DATE>2009-10-28T00:00:00.000+00:00</TRAN_DATE> 
                              <STAT>B</STAT> 
                              <VAL>1820</VAL> 
                              </ROW>
                            - <ROW>
                              <TRAN_DATE>2009-11-27T00:00:00.000+00:00</TRAN_DATE> 
                              <STAT>B</STAT> 
                              <VAL>1285</VAL> 
                              </ROW>
                            - <ROW>
                              <TRAN_DATE>2009-12-02T00:00:00.000+00:00</TRAN_DATE> 
                              <STAT>J</STAT> 
                              <VAL>-100</VAL> 
                              </ROW>
                            - <ROW>
                              <TRAN_DATE>2009-12-07T00:00:00.000+00:00</TRAN_DATE> 
                              <STAT>J</STAT> 
                              <VAL>-100</VAL> 
                              </ROW>
                            - <ROW>
                              <TRAN_DATE>2010-01-12T00:00:00.000+00:00</TRAN_DATE> 
                              <STAT>J</STAT> 
                              <VAL>-100</VAL> 
                              </ROW>
                            - <ROW>
                              <TRAN_DATE>2010-02-05T00:00:00.000+00:00</TRAN_DATE> 
                              <STAT>B</STAT> 
                              <VAL>322.5</VAL> 
                              </ROW>
                            - <ROW>
                              <TRAN_DATE>2010-02-24T00:00:00.000+00:00</TRAN_DATE> 
                              <STAT>J</STAT> 
                              <VAL>-1207.99</VAL> 
                              </ROW>
                            - <ROW>
                              <TRAN_DATE>2010-02-25T00:00:00.000+00:00</TRAN_DATE> 
                              <STAT>J</STAT> 
                              <VAL>-15</VAL> 
                              </ROW>
                            - <ROW>
                              <TRAN_DATE>2010-03-01T00:00:00.000+00:00</TRAN_DATE> 
                              <STAT>J</STAT> 
                              <VAL>-940</VAL> 
                              </ROW>
                            - <ROW>
                              <TRAN_DATE>2010-03-01T00:00:00.000+00:00</TRAN_DATE> 
                              <STAT>J</STAT> 
                              <VAL>-191.8</VAL> 
                              </ROW>
                            - <ROW>
                              <TRAN_DATE>2010-03-01T00:00:00.000+00:00</TRAN_DATE> 
                              <STAT>J</STAT> 
                              <VAL>-120</VAL> 
                              </ROW>
                            - <ROW>
                              <TRAN_DATE>2010-03-02T00:00:00.000+00:00</TRAN_DATE> 
                              <STAT>J</STAT> 
                              <VAL>-2050</VAL> 
                              </ROW>
                              </ROWSET>
                            • 11. Re: BI Publisher conditional formatting
                              524753
                              http://winrichman.blogspot.com/2010/04/conditional-formats.html
                              http://winrichman.blogspot.com/2010/04/bip-formatting.html
                              • 12. Re: BI Publisher conditional formatting
                                @2*728768*
                                Hi Vetsrini

                                Thanks for ur reply.... could you please tell me how to get field browser window in ms word

                                i have tried alot to get this window but without any success.

                                Sorry for asking very basic question

                                Regards
                                • 13. Re: BI Publisher conditional formatting
                                  BIPuser
                                  Add-Ins -> Tools -> Field Browser
                                  • 14. Re: BI Publisher conditional formatting
                                    @2*728768*
                                    Hi Vetsrini

                                    thanks for your kind help i am able to see the -ve values in red colour but other values are not showing up.... could you please tell me how to add IF COND.... row in field browser?

                                    regards

                                    Edited by: user11933655 on Apr 7, 2010 10:37 AM
                                    1 2 Previous Next