Group header data and first data row ommit
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
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
Comments
Instead of using a group, try to use "Duplicates" property of the Text object. Set it to "Hide" or "Clear".
Ok, that hides the times that are equal. But is there a way to set it to some string? For aesthetics sake