Problem if query postgre order by - not execute

Stimulsoft Reports.WEB discussion
Post Reply
mcrmcr2@gmail.com
Posts: 2
Joined: Tue Nov 22, 2016 1:03 pm

Problem if query postgre order by - not execute

Post 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
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Problem if query postgre order by - not execute

Post 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.
mcrmcr2@gmail.com
Posts: 2
Joined: Tue Nov 22, 2016 1:03 pm

Re: Problem if query postgre order by - not execute

Post 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
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Problem if query postgre order by - not execute

Post by Alex K. »

Hello,

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

Thank you.
Attachments
Capture.PNG
Capture.PNG (59.16 KiB) Viewed 1879 times
Post Reply