How to convert date from gregorian to hijri in SSRS report?

(0) Share

Report

Posted on by Rana Anees

1,813

Hii,

In SSRS reports we have some dates like TransDate and showing in gregorian date format and requirement is to show same date in hijri in next column.

Gregorian: 19/12/2017

Hijri Data: 01/03/1439

But we need to show Hijri date in Arabic alphabets, like in the image below.

1. Please guide is there any class and functions that take Gregorian date and convert into Hijri date on report level?
2. Or do we have in x++?
3. Should we add new columns for Hijri dates in temp tables and in RDP class insert after converting to Hijri Date and alphabets?
We need Hijri dates to show on reports only.

Regards,

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (3)

Verified answer

Fx 425 on at

Like (0)

Report
Hello,

I've maybe half of the solution, maybe you can complement by using CultureInfo namespace to change the text style:

Here is the date conversion

System.Globalization.UmAlQuraCalendar hijriCal = new System.Globalization.UmAlQuraCalendar(); System.Globalization.GregorianCalendar gregCal = new System.Globalization.GregorianCalendar(); System.DateTime dt = new System.DateTime(2013, 9, 29, gregCal); // Gregorian str yearStr, monthStr, dayOfMonthStr; yearStr = hijriCal.GetYear(dt); // 1434 monthStr = hijriCal.GetMonth(dt); // 11 dayOfMonthStr = hijriCal.GetDayOfMonth(dt); // 23 info(dt.ToString()); //9/29/2013 12:00:00 AM info(dayOfMonthStr + '/' + monthStr + '/' + yearStr); //23/11/1434

Regards

FX

Was this reply helpful? Yes No
Rana Anees 1,813 on at

Like (0)

Report

Thanks François,

That sounds ok. Now the remaining part is to convert into Arabic numeric.

Regards,

Was this reply helpful? Yes No
Rana Anees 1,813 on at

Like (0)

Report

some ideas please to convert numbers into Arabic numeric. Thanks.

Was this reply helpful? Yes No
Verified answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

[deleted]

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (1)

Report

I thought this is already supported by SSRS and doesn't require any custom code.

Please try using a date value and setting the Language property of the text box to an arabic language the Calendar property to Hijri.

Was this reply helpful? Yes No
Rana Anees 1,813 on at

Like (0)

Report

Thanks Martin,

That will be great. The language and calendar properties are at SSRS report level? Could you please help with more detail.

Thanks again.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,801 Most Valuable Professional on at

Like (2)

Report

They're are properties of TextBox control in SSRS designer.

Just note that I can't test at the moment; I just assume it'll give you what you need.

Was this reply helpful? Yes No
Rana Anees 1,813 on at

Like (0)

Report

Hii Martin, I set Calendar and Language for date text-boxes and it works fine.
Now the thing is to show Hijri date in Arabic letters.
Ca we do it on SSRS level?

Thanks,

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (1)

Report

I'm sorry, but I don't know the answer and I can't start playing with it in the moment. I suggest you ask your question in an SSRS forum; there you'll find more experts in SSRS than in AX forums.

Was this reply helpful? Yes No