Oracle Report Builder: Sorting without grouping?

Getting your data onto paper - or the web - Discussing the reports features of Base
Post Reply
rogmufa
Posts: 14
Joined: Fri Mar 06, 2015 5:22 pm
Location: Denmark

Oracle Report Builder: Sorting without grouping?

Post by rogmufa »

Hi

I can't get Oracle Report Builder to sort the report data.
I made a very simple report (e.g. 2 columns) made with the Report Guide from Base, asking for one of the columns to be sorted (and no grouping). However, the rows come out in random order.

If I edit the report using the 'Grouping and sorting' menu in Report Builder it seems to do a grouping (e.g. one row per page!) - unless I ask for the (group?) page header not to be shown; but then there are no column headers at all (when asking for sorting (grouping?) the main Page Header field disappears (with all the column headings)).

(By the way, I installed the Oracle Report Builder after the inbuilt Base report builder failed to show any data if I asked for a sorting!)

All I need is a simple sorted report with a few columns and column headings!

Any ideas appreciated! I am using Windows XP and OO Base 4.

Thanks
Roger
Open Office 3.4.0 on Wnidows XP
eremmel
Posts: 1080
Joined: Tue Dec 30, 2008 1:15 am

Re: Oracle Report Builder: Sorting without grouping?

Post by eremmel »

Get your report data via a query and use order by in the query.
It's Microsoft marketing that tells you computers are qualified for non-technicians
W11 22H2 (build 22621), LO 7.4.2.3(x64)
rogmufa
Posts: 14
Joined: Fri Mar 06, 2015 5:22 pm
Location: Denmark

Re: Oracle Report Builder: Sorting without grouping?

Post by rogmufa »

Thanks, I'll try it. But I WAS using a query - AND I remember that the builtin Base report did not take any notice of ordering in a query (so I did not expect Oracle's to either).
Regards, Roger
Open Office 3.4.0 on Wnidows XP
Nocton
Volunteer
Posts: 533
Joined: Fri Nov 05, 2010 10:27 am
Location: UK

Re: Oracle Report Builder: Sorting without grouping?

Post by Nocton »

I do not understand your problem. I use Oracle Report Builder a lot. In my experience it always shows the order given in the report query. The Sorting options also work OK. So it suggests that there is something you are not doing quite right. I suggest you upload your database, or a part of it, with any sensitive information removed and then we can see what the problem is.

Regards,

Nocton
OpenOffice 4.1.12 on Windows 10
pyotr-4
Posts: 3
Joined: Tue Oct 04, 2016 4:19 pm

Re: Oracle Report Builder: Sorting without grouping?

Post by pyotr-4 »

Having similar problem:
Query has book titles in order, with Author Lastname, Firstname
Report has Book title is "some" order, apparently grouped by Lastname
eg:
100 Days in the Arena Winter David
Down & Out in Paris & London Orwell George
1984 Orwell George
Animal Farm Orwell George
Call Me Manneschewitz McMenamin
1984 & Beyond Calder Nigel

:crazy:

I have a long list of things which need doing, and this is way down on it.
OpenOffice 4.1 on Windows 7
longi
Posts: 110
Joined: Mon Jul 15, 2013 5:04 pm

Re: Oracle Report Builder: Sorting without grouping?

Post by longi »

Hi!
Same opinion that Nocton has.
It could be a good thing if you show us a little example, without personal informations.
It's possible to use some tools by code, but ORB has to work properly.

Bye!
OpenOffice 4.1.5 on Windows 10
LibreOffice 5.1 on Windows 7
LibreOffice 6.0.1 on Windows10
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Oracle Report Builder: Sorting without grouping?

Post by Villeroy »

The irritating thing is that the report does not change the sort order when the querie's sort order changes.
download/file.php?id=11250 is one of my example databases.
Query "qPersonListbox" has a visible text column and an integer primary key. It is not sorted explicitly (though it should be), so it appears in ascending order of the primary key.

Code: Select all

SELECT "Name" || ',' || "Name2" || ',' || "Date" AS "Person", "ID" FROM "Persons" AS "Persons"
I create a most simple report (right-click>Report Wizard, add both columns, finish) and the report is sorted by the integer field.
Then I append ORDER BY "Person" ASC to the query, save, run the report again and the report's sort order remains the same.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
pyotr-4
Posts: 3
Joined: Tue Oct 04, 2016 4:19 pm

Re: Oracle Report Builder: Sorting without grouping?

Post by pyotr-4 »

longi wrote:Hi!
Same opinion that Nocton has.
It could be a good thing if you show us a little example, without personal informations.
It's possible to use some tools by code, but ORB has to work properly.

Bye!
Thanks.

After a couple more days wrassleing with the whole thing, decided I don't
have the time or interest to dig that deep in to DB development. Not now.

Yeah, I gave up.

Sigh.
OpenOffice 4.1 on Windows 7
Post Reply