[Solved] Report Creation

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

[Solved] Report Creation

Postby KMcCarthy » Wed Nov 08, 2017 9:04 pm

Hi.

I'm trying to create a simple report from a Query using the Report Wizard. When I just select the fields I want and just finish it through it creates fine. If I do a sort on any of the fields it generates a report with a single line which is not in the Query the report is to pull from. How do I correct the sorting?

Kristin
Last edited by Hagar Delest on Wed Feb 07, 2018 11:51 pm, edited 1 time in total.
Reason: tagged [Solved].
Apache OpenOffice 4.1.4 on Windows 10
KMcCarthy
 
Posts: 1
Joined: Wed Nov 08, 2017 9:00 pm

Re: Report Creation

Postby longi » Thu Nov 09, 2017 11:05 am

Hi!
If you are using AOO, then you have not to sort fields when you are generating your report (it doesn't work).
It's better to do that in the query.
The other way is changing the report origine and using a SQL sentence, in which you sort your fields.

Something to fix...!

Regards!
OpenOffice 4.1.5 on Windows 10
LibreOffice 5.1 on Windows 7
LibreOffice 6.0.1 on Windows10
longi
 
Posts: 107
Joined: Mon Jul 15, 2013 5:04 pm

Re: Report Creation

Postby Nocton » Fri Nov 17, 2017 8:43 pm

But if you install Oracle Report Builder you can sort in the report.
OpenOffice 4.2.0 on Windows 10
Nocton
Volunteer
 
Posts: 504
Joined: Fri Nov 05, 2010 10:27 am
Location: UK

Re: Report Creation

Postby NicksStillLearning » Tue Feb 06, 2018 3:38 am

I'm having the same issue as Kristin. In AOO, I created a query which sorts a table's date field and imposes criterion(>=CURRENT_DATE) on that same date field. The query returns the data perfectly, but when I create a report from that query (either with or without grouping and sorting), all I get is a single line of strange data. I'm confused! Can queries be used as data sources for reports, or not?

Thanks for any suggestions . . .
Nick R
Apache OpenOffice v 4.1.5
Windows 10 v. 1709
NicksStillLearning
 
Posts: 3
Joined: Mon Feb 05, 2018 10:45 pm

Re: Report Creation

Postby Sliderule » Tue Feb 06, 2018 4:01 am

NicksStillLearning wrote:I'm having the same issue as Kristin. In AOO, I created a query which sorts a table's date field and imposes criterion(>=CURRENT_DATE) on that same date field. The query returns the data perfectly, but when I create a report from that query (either with or without grouping and sorting), all I get is a single line of strange data. I'm confused! Can queries be used as data sources for reports, or not?

Thanks for any suggestions . . .

Yes. I do it all the time using the extension, Oracle Report Builder . It can be downloaded from:

https://extensions.openoffice.org/en/project/oracle-report-builder

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1170
Joined: Thu Nov 29, 2007 9:46 am

Re: Report Creation

Postby NicksStillLearning » Tue Feb 06, 2018 4:47 am

WHOA! The Report Builder is EXACTLY what I needed. Thanks so much for the link Sliderule!
Nick R
Apache OpenOffice v 4.1.5
Windows 10 v. 1709
NicksStillLearning
 
Posts: 3
Joined: Mon Feb 05, 2018 10:45 pm

Re: Report Creation

Postby Nocton » Tue Feb 06, 2018 10:15 am

I mentioned this on 17 Nov, NicksStillLearning. I assumed that posters would know how to get extensions, but clearly not everyone.
So after opening OpenOffice you might like to look at Tools/Extension Manager and click on 'Get more extensions online...' where you will find lots of interesting add-ons/extensions including the Oracle Report Builder
OpenOffice 4.2.0 on Windows 10
Nocton
Volunteer
 
Posts: 504
Joined: Fri Nov 05, 2010 10:27 am
Location: UK

Re: Report Creation

Postby NicksStillLearning » Tue Feb 06, 2018 11:58 pm

Will do Nocton. Thanks for the advice. I'm an old DBase III guy who's new to AOO and who only joined this forum a couple days ago. Still catching up . . .
Nick R
Apache OpenOffice v 4.1.5
Windows 10 v. 1709
NicksStillLearning
 
Posts: 3
Joined: Mon Feb 05, 2018 10:45 pm


Return to Reporting

Who is online

Users browsing this forum: No registered users and 4 guests