[Solved] Sorted in Query but not in Report

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

[Solved] Sorted in Query but not in Report

Postby nathan3553 » Sat Oct 18, 2014 6:43 pm

 Edit: Split from initial topic: Sorted in Query but not in Report, Hagar, Moderator. 


Similar issue as above.

Query outputs as it should:
select a.mail_name as "Name",a.address,a.city,a.state,a.zipcode, b.check_num as "Check #", b.cash as "Cash", b.non_money as "Non Money", b.amount as "Amount",b.date_contributed as "Date",c.fund as "Fund" from family a inner join contribution b on a.id=b.family_id inner join fund c on b.fund_id=c.id where b.date_contributed >= '2014-01-01' and b.date_contributed <= '2014-12-31' order by "Name","Date"

Report: It is sorting by A.ID

Any work around or fix in the works? How are you using Calc to create a report that looks professional?
Last edited by RoryOF on Fri Jan 16, 2015 6:45 pm, edited 2 times in total.
Reason: tagged solved
OpenOffice 4 on Windows 7/OpenOffice 4 on MacOSX
nathan3553
 
Posts: 17
Joined: Sat Oct 18, 2014 6:35 pm

Re: Sorted in Query but not in Report

Postby F3K Total » Sat Oct 18, 2014 8:09 pm

Hi,
try to use a VIEW instead of a QUERY as datasource of the report.
HTH R
    MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
    my current system
  • Windows 10 AOO, LOLinux Mint AOO, LO
F3K Total
Volunteer
 
Posts: 950
Joined: Fri Dec 16, 2011 8:20 pm

Re: Sorted in Query but not in Report

Postby Villeroy » Sat Oct 18, 2014 8:39 pm

nathan3553 wrote:Any work around or fix in the works? How are you using Calc to create a report that looks professional?

I use to use a well formatted spreadsheet or the Oracle Report Builder extension.
F3K Total wrote:try to use a VIEW instead of a QUERY as datasource of the report.

I tried and it works indeed.
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.4
User avatar
Villeroy
Volunteer
 
Posts: 27760
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

[SOLVED]Re: Sorted in Query but not in Report

Postby nathan3553 » Sat Oct 18, 2014 9:49 pm

Creating a view did work! I've been struggling with this for days. Thanks.
OpenOffice 4 on Windows 7/OpenOffice 4 on MacOSX
nathan3553
 
Posts: 17
Joined: Sat Oct 18, 2014 6:35 pm

Re: [Solved] Sorted in Query but not in Report

Postby arfgh » Fri Jan 16, 2015 6:42 pm

what you mean guys with 'create a view' ?

i also want to be able to sort on reports that seems not working.
OpenOffice last version | Mageia Linux x64 | Windows 8.1 Enterprise x64 | Windows XP Pro x64 SP2 | Java 1.8.0_231
arfgh
 
Posts: 502
Joined: Tue Mar 05, 2013 6:44 pm

Re: [Solved] Sorted in Query but not in Report

Postby F3K Total » Fri Jan 16, 2015 7:31 pm

open your eyes
CV.PNG
CV.PNG (6.58 KiB) Viewed 1648 times
and use F1
F3K Total
Volunteer
 
Posts: 950
Joined: Fri Dec 16, 2011 8:20 pm

Re: [Solved] Sorted in Query but not in Report

Postby arfgh » Fri Jan 16, 2015 8:15 pm

so creating a 'view', we will be able to obtain sorting on reports ? howto ?
OpenOffice last version | Mageia Linux x64 | Windows 8.1 Enterprise x64 | Windows XP Pro x64 SP2 | Java 1.8.0_231
arfgh
 
Posts: 502
Joined: Tue Mar 05, 2013 6:44 pm

Re: [Solved] Sorted in Query but not in Report

Postby eremmel » Fri Jan 16, 2015 10:44 pm

I suggest, that before asking for the obvious, you list your efforts executed far to obtain the knowledge yourself. This makes it posible for others to be more effective.
It's Microsoft marketing that tells you computers are qualified for non-technicians
eremmel
 
Posts: 1041
Joined: Tue Dec 30, 2008 1:15 am


Return to Reporting

Who is online

Users browsing this forum: No registered users and 2 guests