Page 1 of 1

Oracle Report Builder: Sorting without grouping?

PostPosted: Tue Mar 10, 2015 12:55 pm
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

Re: Oracle Report Builder: Sorting without grouping?

PostPosted: Tue Mar 10, 2015 3:06 pm
by eremmel
Get your report data via a query and use order by in the query.

Re: Oracle Report Builder: Sorting without grouping?

PostPosted: Tue Mar 10, 2015 3:20 pm
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

Re: Oracle Report Builder: Sorting without grouping?

PostPosted: Fri Mar 27, 2015 1:43 pm
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

Re: Oracle Report Builder: Sorting without grouping?

PostPosted: Tue Oct 04, 2016 6:16 pm
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.

Re: Oracle Report Builder: Sorting without grouping?

PostPosted: Wed Oct 05, 2016 9:25 am
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!

Re: Oracle Report Builder: Sorting without grouping?

PostPosted: Wed Oct 05, 2016 10:42 am
by Villeroy
The irritating thing is that the report does not change the sort order when the querie's sort order changes.
https://forum.openoffice.org/en/forum/d ... p?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   Expand viewCollapse view
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.

Re: Oracle Report Builder: Sorting without grouping?

PostPosted: Mon Oct 10, 2016 3:04 am
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.