[Solved] Report sort by ID

Getting your data onto paper - or the web - Discussing the reports features of Base

[Solved] Report sort by ID

Postby Aphex » Thu May 29, 2014 11:47 pm

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.
Last edited by Hagar Delest on Wed Jun 04, 2014 9:24 pm, edited 1 time in total.
Reason: tagged [Solved].
LibreOffice 4.2
Aphex
 
Posts: 7
Joined: Thu May 29, 2014 11:44 pm

Re: Report sort by ID

Postby MTP » Fri May 30, 2014 6:27 pm

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.
OpenOffice 4.1.1 on Windows 10, HSQLDB 1.8 split database
User avatar
MTP
Volunteer
 
Posts: 1620
Joined: Mon Sep 10, 2012 7:31 pm
Location: Midwest USA

Re: Report sort by ID

Postby Aphex » Sun Jun 01, 2014 3:41 pm

where can i edit SQL in reports?
LibreOffice 4.2
Aphex
 
Posts: 7
Joined: Thu May 29, 2014 11:44 pm

Re: Report sort by ID

Postby MTP » Mon Jun 02, 2014 5:58 pm

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?
OpenOffice 4.1.1 on Windows 10, HSQLDB 1.8 split database
User avatar
MTP
Volunteer
 
Posts: 1620
Joined: Mon Sep 10, 2012 7:31 pm
Location: Midwest USA

Re: Report sort by ID

Postby Aphex » Wed Jun 04, 2014 1:34 pm

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

Thank you.
LibreOffice 4.2
Aphex
 
Posts: 7
Joined: Thu May 29, 2014 11:44 pm


Return to Reporting

Who is online

Users browsing this forum: No registered users and 2 guests