Group header data and first data row ommit

ezekiel

Hi!

Is there a way to make the Databand ignore the row that is used in the Group Header?

I have the following data:

Name Time
Mike 1.20
Bob 1.20
Ted 1.25
Harry 1.27
Larry 1.27

I am trying to print something like:
Name Time
Mike 1.20
Bob -||-
Ted 1.25
Harry 1.27
Larry -||-

So if the times repeat themselves print some string. I made a Group header that contains the Name and Time columns, where the Time is the Condition. I made the same two columns in the Data band - with the Time column being the desired string.

But at the moment I am getting the following:
Name Time
Mike 1.20
Mike -||-
Bob -||-
Ted 1.25
Ted -||-
Harry 1.27
Harry -||-
Larry -||-

So how can I make the databand skip the first row since its already printed as the group header? Is there any way to use an Expression that makes an IF sentence with the previous row or maybe a Filter of some sort?

Thanks
Miha

AlexTZ

Hello,

Instead of using a group, try to use "Duplicates" property of the Text object. Set it to "Hide" or "Clear".

ezekiel

Hi!

Ok, that hides the times that are equal. But is there a way to set it to some string? For aesthetics sake

AlexTZ

It can be done by putting another Text object (with "-//-" text in it) behind the object with duplicate data. You need to set Duplicates to Hide, and also set non-transparent background for the object with duplicate data.

ezekiel

Nice hack ... it works. Thanks!