Jump to content

Conditional Format for Blank Cells in Crosstab


katepassaro

Recommended Posts

 Hello - 

I have finally gotten conditional formatting to work within a crosstab based on the help of this thread - http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=47374

My problem is that the formatting is only working in cells for a row header where the cell is not blank - so it's not very neat. I would like all cells for a certain row to highlight (or not highlight) regardless of it they are blank. 

Here is what I'd like                               Column A             Column B              Column C                   Column D

Row Header A - Row Sub-Header 1          x                                                               x                                     x                    (No format in all)

Row Header A - Row Sub-Header 2                                                                          x                                                            (no format in all)

Row Header B- Row Sub-Header 1                                          x                                                                      x                     (all columns color)

Row Header C - Row Sub-Header 1         x                                                                                                       x

Row Header C - Row Sub-Header 2        x                                                                                                       x     

Row Header C - Row Sub-Header 3        x                                                                                                                              (no format)   

Right now it's highlighting the appropriate rows, but leaving the blanks unformatted. I have attached my XML.

Any help would be greatly appreciated. 

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...