How to implement grouping in FastReports?

Question

Delphi

Good afternoon!
There is such a report.

And everything was fine until one day there were double lines.
The result of the SQL query Execution

of the report

It is necessary, where the lines are doubled, to combine them so that it looks something like this

I understand that I need to write something in the code so that the fields add up, but what? I am an amateur in this matter

Answer 1

If I understand correctly, no additional calculations are required here. Do you need to visually merge lines with the same address? It can be done and probably even in different ways. That's just in words from memory it's all difficult to state - you need to try. The first option is in the question itself. You can use groups. Grouping by address. If you can get the number of the output line within the group, then you can set a handler for the text of the first 6 columns. which will print the text is only valid in the first one. Or maybe what is displayed from the 7th column should be made a nested report. The view should look like this. But I don’t remember just how it was with the results.
Look at examples to fastreport.

Answer 2

change sql query

Answer 3

Post your sql query and I'll help you. It is necessary to change request namely grouping.