order by not working in stimulsoft query

[m.issa]

Hello

when i write my query inside my report, and when i write order by in my query, the report working fine by not ordered, although i write the same query in ms sql server and give me ordered results.

for example:

select * from Employee where EmpStatus = 1 orderBy EmpJoinDate ASC

so the report run properly but the result not ordered as i wrote in my condition in the query.

Thank you

[HighAley]

Hello.

Please, describe your issue more detailed. Where do you use the data that you get with this query?
Did you set the Sort property of the Band?
Please, try to use next query:

select * from Employee where EmpStatus = 1 orderBy EmpJoinDate ASC

Thank you.

[m.issa]

Hello

it is working, i set sort property of the data band then it is working properly, so the orderby working from sort properly not from query.

Thank you for your valuable informations that you always provide for all of us in this great forum.

[HighAley]

Hello.

Thank you for good words and for using our product.
We are always glad to help you.
Let us know if you will need any additional help.

Thank you.