How to get hijri calender for date picker

building reports crystal reports
1

Dear All

Can any one let us know that how to get Hijri date picker for Parameters in crystal reports.

Right now we are using Crystal Reports 2008.
Any help in this matter would be appreciated…

Thanks in advance

ASHFAQ

ashfaq_haseeb (BOB member since 2009-10-27)

2

Crystal itself doesn’t have this as far as I know. Might be in CR 2008 or there might be a custom function avaiilable but I wouldn’t know where to start looking.

If your underlying database is SQL the best bet is to convert the Gregorian dates before they are loaded into the parameter. SQL convert function has two options for this:
130 will provide the date in format: dd mon yyyy hh:mi:ss:mmmAM.
131 will provide the date in format: dd/mm/yy hh:mi:ss:mmmAM

KMB :uk: (BOB member since 2004-02-11)

3

Thanks a lot for your help. Actually I need to display hijri calender at user end.
i.e When user select parameter the calender should be hijri (Arabic)

Also Can you please let us know how to convert Gegorian date to Hijri date at crystal report level.

Thanks a lot in advance…

Ashfaq

ashfaq_haseeb (BOB member since 2009-10-27)