right to left string in crystal report

Question

Consider Below Query in SQL Server

below picture is result of this query in Crystal Reports.

as you can see the right part is exactly same as query result in sql server and left part is converted by a locked function to meet right to left property of Persian language.

I need to Obtain this Function.

Answer 1

First you have re-write you sql statement to be as follow:

  SELECT N'Your Text'

and in crystal report on your text object > right click > Format Object > Paragraph tab > Reading Order > Select Right to Left as Image Below