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
Oracle Report Builder: Sorting without grouping?
Oracle Report Builder: Sorting without grouping?
Open Office 3.4.0 on Wnidows XP
Re: Oracle Report Builder: Sorting without grouping?
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)
W11 22H2 (build 22621), LO 7.4.2.3(x64)
Re: Oracle Report Builder: Sorting without grouping?
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
Regards, Roger
Open Office 3.4.0 on Wnidows XP
Re: Oracle Report Builder: Sorting without grouping?
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
Regards,
Nocton
OpenOffice 4.1.12 on Windows 10
Re: Oracle Report Builder: Sorting without grouping?
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
I have a long list of things which need doing, and this is way down on it.
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
I have a long list of things which need doing, and this is way down on it.
OpenOffice 4.1 on Windows 7
Re: Oracle Report Builder: Sorting without grouping?
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!
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
LibreOffice 5.1 on Windows 7
LibreOffice 6.0.1 on Windows10
Re: Oracle Report Builder: Sorting without grouping?
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.
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.
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"
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Oracle Report Builder: Sorting without grouping?
Thanks.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!
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