Hi,

I want to create SSRS Report in Arabic language in SQL Server 2008r2 version. Till now, I am able to translate numeric values into Arabic in SSRS however, unable to translate text data into Arabic in the report.

It would be helpful if anybody give me some pointers.

Thanks in advance.

Sneha

• Edited by SnehaButala Wednesday, July 01, 2015 6:24 AM

You cant use Reporting Services as a translator. WHat you need to do is to store data in Arabic in your database using unicode fields ( nvarchar,nchar). Then in report use field in the dataset query and you will get Arabic data. You might have to change text direction to RTL to show them from right to left etc

Thank for the response Shrek.

Is there any other way to achieve this requirement, I mean using custom code (.Net) in ssrs?

Thanks,

Sneha

Thanks for the response Visakh.

But I am having English data source, and want translate in Arabic in report.

Thanks,

Sneha

Hi Sneha, 

If your database is English, the data is like A, B ,C. There is no way to convert the data to Arabic language. Only the data is hard coding string, the text can be converted to the corresponding language. 

Regards, 
Shrek Li

Hi Sneha,



1) Depending on the version of SSRS you are using, you can use GetReportDefinition method (http://msdn.microsoft.com/en-us/library/reportservice2005.reportingservice2005.getreportdefinition(v=sql.100).aspx) or GetItemDefinition (http://msdn.microsoft.com/en-us/library/reportservice2010.reportingservice2010.getitemdefinition.aspx)

2) You can use the RDL Object Model to edit the RDL, although it's not trivial and the classes of the Microsoft.ReportingServices.RdlObjectModel namespace are marked internal (SSRS 2008 R2 and higher). You can find sample code by Teo Lachev at http://prologika.com/CS/blogs/blog/archive/2010/03/08/where-is-rdlom-in-r2.aspx and by Lionel Ringenbach at http://ucodia.fr/2011/10/advanced-reporting-services-part1-rdl-object-model/ andhttp://ucodia.fr/2011/10/advanced-reporting-services-part2-rdl-serializer/.

For reference information about the classes and methods of the RDL Object Model, start at http://msdn.microsoft.com/en-us/library/ff493708.

3-4) I think it would be easier to deploy your edited report back to the server and then call it with the ReportViewer control. Then you can just leverage available methods in a straightforward manner. The ReportViewer control can handle the rendering directly. Here's information on deployment via the Web service: http://tomyrhymond.wordpress.com/2011/08/07/sql-server-reporting-services-deploying-rdl-files/

Regards,

Mahesh O.