Oracle Report Builder: Sorting without grouping?

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

Oracle Report Builder: Sorting without grouping?

Postby rogmufa » Tue Mar 10, 2015 12:55 pm

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
rogmufa
 
Posts: 2
Joined: Fri Mar 06, 2015 5:22 pm

Re: Oracle Report Builder: Sorting without grouping?

Postby eremmel » Tue Mar 10, 2015 3:06 pm

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
eremmel
 
Posts: 1037
Joined: Tue Dec 30, 2008 1:15 am

Re: Oracle Report Builder: Sorting without grouping?

Postby rogmufa » Tue Mar 10, 2015 3:20 pm

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
rogmufa
 
Posts: 2
Joined: Fri Mar 06, 2015 5:22 pm

Re: Oracle Report Builder: Sorting without grouping?

Postby Nocton » Fri Mar 27, 2015 1:43 pm

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.2.0 on Windows 10
Nocton
Volunteer
 
Posts: 506
Joined: Fri Nov 05, 2010 10:27 am
Location: UK

Re: Oracle Report Builder: Sorting without grouping?

Postby pyotr-4 » Tue Oct 04, 2016 6:16 pm

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
pyotr-4
 
Posts: 3
Joined: Tue Oct 04, 2016 4:19 pm

Re: Oracle Report Builder: Sorting without grouping?

Postby longi » Wed Oct 05, 2016 9:25 am

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
longi
 
Posts: 108
Joined: Mon Jul 15, 2013 5:04 pm

Re: Oracle Report Builder: Sorting without grouping?

Postby Villeroy » Wed Oct 05, 2016 10:42 am

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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27300
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Oracle Report Builder: Sorting without grouping?

Postby pyotr-4 » Mon Oct 10, 2016 3:04 am

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
pyotr-4
 
Posts: 3
Joined: Tue Oct 04, 2016 4:19 pm


Return to Reporting

Who is online

Users browsing this forum: No registered users and 1 guest