Problem With Sort in Farsi Or Arabic language

Posted by: vahidnavidi on 4 August 2017, 3:11 pm EST

  • Posted 4 August 2017, 3:11 pm EST

    when my Database iz Farsi or arabic,cant sort properly !

    can help me ?
  • Replied 4 August 2017, 3:11 pm EST

    ActiveReports does not perform any kind of sorting when displaying data.  I assume you are adding a 'Sort' clause to your SQL query.  This means that the database will sort the data, and then return the sorted data to ActiveReports.  If sorting is not working properly with specific languages, then this is likely an issue or limitation of the database you are using.
  • Replied 4 August 2017, 3:11 pm EST

    I use of access Database and for sort Use of  ORDER BY Fields Name ASC !

     

    but not work properly !

     

     
  • Replied 4 August 2017, 3:11 pm EST

    Please note that ActiveReports does not handle any form of sorting or ordering functionality.  This is handled by the database (in this case Access). You may need to contact Microsoft in regards to this problem as it may be an issue or limitation of the version of Access you are using.
  • Replied 4 August 2017, 3:11 pm EST

    My Database version is access 97 !

     

    when open MDB file in access,can sort verywell

    but when report in active report,not work !
  • Replied 4 August 2017, 3:11 pm EST

    You cannot sort data on a report after it has been rendered. If you want data to appear sorted on your report, you must sort it before binding it to the reporting engine. If you are binding to a relational database, like Access, this is typically done with an ORDER BY clause in your SQL query. (To sort the data a different way after running the report, you must rerun the report again.)

    The Microsoft Access documentation contains information on writing SQL statements for use with Microsoft Jet. Please take a look under the clauses section to find information on the ORDER BY clause.

    http://office.microsoft.com/en-us/access/CH062526881033.aspx

    Tim
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels