Page 1 of 1

Problem if query postgre order by - not execute

Posted: Tue Nov 22, 2016 1:10 pm
by mcrmcr2@gmail.com
Hello,

I need to pass the data order per query, but sort by only works if I set the dataBand.

Example:
SELECT * from tabel

WHERE DATA BETWEEN '2016-08-22' AND '2016-08-25'

ORDER BY DATA ASC

This order does not work.

I wait,

Hugs

Abraços

Re: Problem if query postgre order by - not execute

Posted: Tue Nov 22, 2016 2:37 pm
by HighAley
Hello.

The order of the data could be changed by our report engine.
If you need to sort data in the report, please use the Sort property of the data band.

Thank you.

Re: Problem if query postgre order by - not execute

Posted: Tue Nov 22, 2016 6:56 pm
by mcrmcr2@gmail.com
Ok,

But i using parameters in the link web: http://www.site.com/relatorio/1.php?par ... 2016-08-30, because usually the user uses the form to generate the report.

How could I use this information to generate the report?

Thanks

Re: Problem if query postgre order by - not execute

Posted: Wed Nov 23, 2016 10:11 am
by Alex K.
Hello,

We couldn't reproduce this bug.
Please send us your report with test data for analysis.

Thank you.