Table Background highlights using eventhandler

Hi

In my previous reports i have used event handler to highlight alternate rows in table. The code is a s follows:

public class TableCellBackgroundEventHandler extends RowEventAdapter {

private Integer count=0;
private static String grey = "#D8D8D8";
private static String white = "#FFFFFF";

public void onCreate(IRowInstance rowInstance, IReportContext reportContext) {
count++;
if (count % 2 == 0) {
rowInstance.getStyle().setBackgroundColor(grey);
} else {
rowInstance.getStyle().setBackgroundColor(white);
}
}

Now I have to highlight in the following pattern:

1
2
3-highlighted
4-highlighted
5
6
7-highlighted
8-highlighted
9
10
11-highlighted
12-highlighted

Can anyone please help me ?

Find more posts tagged with

Comments

mwilliams

"if (count%3 == 0 || count%4 == 0)" will find the two rows you want. Are you just doing one color now for the 3rd and 4th row? Or are you still alternating somehow?

Happy_20

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="74391" data-time="1299533269" data-date="07 March 2011 - 02:27 PM">
"if (count%3 == 0 || count%4 == 0)" will find the two rows you want. Are you just doing one color now for the 3rd and 4th row? Or are you still alternating somehow? </blockquote>
 
all the highlighted rows will be black in color and all the non-highlighted rows will be white in color. 
I need a fixed pattern for it.

Happy_20

<blockquote class='ipsBlockquote' data-author="'Happy_20'" data-cid="74400" data-time="1299536160" data-date="07 March 2011 - 03:16 PM">
all the highlighted rows will be black in color and all the non-highlighted rows will be white in color. 
I need a fixed pattern for it. I don't know the count of the rows.It is dynamically generated. I want alternate two rows white and black. </blockquote>

mwilliams

You would use a statement like the one I said above. If that statement is true, color black. else, color white.

Happy_20

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="74403" data-time="1299536937" data-date="07 March 2011 - 03:28 PM">
You would use a statement like the one I said above. If that statement is true, color black. else, color white. </blockquote>
The above condition will be satisfied only for 3rd and 4th row..again I want row 5 and 6 black, then 7 and 8 white, then 9 and 10 black..and so on 
 
I have used the following code which seems to be perfect, but still it is printing alternate row black and white. Don't know why 
 
public class TablePatternBackgroundEventHandler extends RowEventAdapter{ 
 
private Integer count = 0; 
 
private static String grey = "#D8D8D8"; 
private static String white = "#FFFFFF"; 
 
public void onCreate(IRowInstance rowInstance, IReportContext reportContext) 
{ 
 
count++; 
if (count % 2 == 0) { 
System.out.println("count increment" + count); 
Integer anotherCnt =0; 
do{ 
 
anotherCnt++; 
System.out.println("another count 1st increment" + anotherCnt); 
rowInstance.getStyle().setBackgroundColor(grey); 
}while(anotherCnt<2); 
} else { 
Integer anotherCnt=0; 
do{ 
anotherCnt++; 
System.out.println("another count 2nd increment" + anotherCnt); 
rowInstance.getStyle().setBackgroundColor(white); 
}while(anotherCnt<2); 
 
} 
}

mwilliams

You are right, I mixed it up a little. It needs to be something like:

if (count%4 == 3 || count%4 == 0){
black;
}
else{
white
}

If your row count starts at 0 instead of 1, it'd be 2 and 3 you'd be checking for rather than 3 and 0.

Hope this helps.

Happy_20

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="74434" data-time="1299595607" data-date="08 March 2011 - 07:46 AM">
You are right, I mixed it up a little. It needs to be something like: 
 
if (count%4 == 3 || count%4 == 0){ 
black; 
} 
else{ 
white 
} 
 
If your row count starts at 0 instead of 1, it'd be 2 and 3 you'd be checking for rather than 3 and 0. 
 
Hope this helps. </blockquote>
 
Thanks..it did

Happy_20

Need help again in the background highlight for crosstab

Please see the attached file (actual.pdf)

I need in help in first crosstab in the report (Region to Region Summary)
The Measures are in vertical dimension.
As you can see, every fourth row should be highlighted.

I wrote this code:

public void onCreateCell(ICrosstabCellInstance cell, IReportContext reportContext) {
try {
// For the header rows
if (cell.getCellType().equals("header")) {
if (cell.getDataValue("sourceRegion") != null) {
if (cell.getDataValue("sourceRegion") != headerValue) {
headerCount++;
headerValue = (String) cell.getDataValue("sourceRegion");
if (headerCount % 2 == 0) {
headerBackgroundColour = grey;
} else {
headerBackgroundColour = white;
}
}
}
cell.getStyle().setBackgroundColor(headerBackgroundColour);

}
// else { // if rows are not header rows, they are aggregation rows
// if (cell.getDataValue("targetRegion") != aggValue) {
// aggCount++;
// aggValue = (String) cell.getDataValue("targetRegion");
// if (aggCount % 2 == 0) {
// aggBackgroundColour = grey;
// } else {
// aggBackgroundColour = white;
// }
// }
// cell.getStyle().setBackgroundColor(aggBackgroundColour);
// }
}
catch (BirtException e) {
// No exception handling is required as execption get thrown if cells to not have attribute requested
}
}

}

I could get the first two columns highlighted the way I want ( see in sample.pdf)
Could not proceed further and so commented out the else part that highlights the aggregation rows.

Any help would be appreciated.

Thanks a lot

mwilliams

So, you want the measure rows associated with every other outer row dimension to be highlighted? Is this the case?

Happy_20

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="75975" data-time="1302902952" data-date="15 April 2011 - 02:29 PM">
So, you want the measure rows associated with every other outer row dimension to be highlighted? Is this the case? </blockquote>
 
yes you got it right. Can you guide me through it

mwilliams

What's your BIRT version again? I'll make a quick example.

Happy_20

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="75997" data-time="1303136482" data-date="18 April 2011 - 07:21 AM">
What's your BIRT version again? I'll make a quick example. </blockquote>
Birt Version - 2.6

mwilliams

Here's a way to do it. This example doesn't have just 4 inner rows for each outer dimension, it handles all amounts of inner rows per outer dimension. Let me know if you have questions.

Happy_20

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="76014" data-time="1303147929" data-date="18 April 2011 - 10:32 AM">
Here's a way to do it. This example doesn't have just 4 inner rows for each outer dimension, it handles all amounts of inner rows per outer dimension. Let me know if you have questions. </blockquote>
 
Thanks so much. It worked

Meanwhile I wrote eventhandler in java which also worked : 
 
public class CrossTabBackgroundInterNodalLatencySummary extends CrosstabEventHandlerAdapter { 
 
private Integer headerCount = 0; 
private String headerValue = ""; 
private String headerBackgroundColour; 
private static String grey = "#CCEA97"; 
private static String white = "#FFFFFF"; 
 
@Override 
public void onCreateCell(ICrosstabCellInstance cell, IReportContext reportContext) { 
try { 
if (cell.getDataValue("sourceRegion") != null) { 
if (cell.getDataValue("sourceRegion") != headerValue) { 
headerCount++; 
headerValue = (String) cell.getDataValue("sourceRegion"); 
if (headerCount % 2 == 0) { 
headerBackgroundColour = grey; 
} else { 
headerBackgroundColour = white; 
} 
} 
} 
cell.getStyle().setBackgroundColor(headerBackgroundColour); 
} 
catch (BirtException e) { 
// No exception handling is required as execption get thrown if cells to not have attribute requested 
} 
} 
 
 
}

mwilliams

Great! Glad to help!