[Solved] Report sort by ID

[Aphex]

Hey guys,

Im working in this database with various tables.

When building a report, i choose building a report with 3 columns.

When i want to see the report made, i see that the 3 columns have the same exact infos in every each one of them.

I would like to know if theres a way to sort by ID the data, so it show all the table data but dont repeat them.

Im using libre 4.2 on windows 7 64 bit.

Thanks.

[MTP]

I think what you want is an aggregate function (e.g. GROUP BY). I know there are ways to do it in your underlying query and also in the report itself. We might be able to provide more details if you share your field names and what tables they are in.

[Aphex]

where can i edit SQL in reports?

[MTP]

Reports are really not my thing, so I don't have any specific answers. Have you tried opening the report in edit ("design") mode (right-click on the report name and choose "edit") and poking around?

[Aphex]

Just Solved the problem easier than i thought!! Just had to edit the columns.

Thank you.