Only one data row per group

[tpontow]

Hello,

i have a report with SQL connection. One column of the data is an id which should be unique. So i grouped with a GroupHeaderBand with that id as condition. But sometimes it happens that i have two or more data rows with the same id in my data set.

So is it somehow possible to show only the first of the multiple data rows in the group?

I tried filter and conditions but with no result. I also cannot change the sql statement so i need to do it in the report!

Thanks and kind regards
Thorsten Pontow

[HighAley]

Hello.

Please, try to set Conditions of the Data Band to next:
Expression: Line>1
Component is Enabled: False.

Report.mrt

(21.32 KiB) Downloaded 645 times

Thank you.

[tpontow]

Hello Aleksey,

thanks for your quick response and the sample report. That solution works for me.

Thanks and kind regards
Thorsten Pontow

[HighAley]

Hello.

We are always glad to help you.
Do not hesitate to contact us in future.

Thank you.