[Solved] Sorted in Query but not in Report

[nathan3553]

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?

[F3K Total]

Hi,
try to use a VIEW instead of a QUERY as datasource of the report.
HTH R

[Villeroy]

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.

try to use a VIEW instead of a QUERY as datasource of the report.

I tried and it works indeed.

[nathan3553]

Creating a view did work! I've been struggling with this for days. Thanks.

[arfgh]

what you mean guys with 'create a view' ?

i also want to be able to sort on reports that seems not working.

[F3K Total]

open your eyes

CV.PNG (6.58 KiB) Viewed 3345 times

and use F1

[arfgh]

so creating a 'view', we will be able to obtain sorting on reports ? howto ?

[eremmel]

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.