When we run our report in CRM/ Web App automatically date format get change from MM/DD/YYYY to DD/MM/YYYY or vice versa in report parameters.
We can change the date time format in the report data using
1. CultureInfo (by adding the vb script in code section of the report) in Web App
2. CRM_CalendarTypeCode from the user settings in CRM.
Actually this is the limitation of the reporting service. By default the “language property of the report” is US English. But when we run the report in Client browser the date time format get decided by the Language settings of client browser not by the language property of the report.
The format of date time parameter is always decided by the Language settings of client browser regardless of the Language property of our report (or in CRM).
Examples:-
If we have the Client browser language settings in English (AU), the date format in parameter bar will be as (regardless of the Language property of our report (or in CRM)):-
But when we run the same in the Client browser where language settings is in French (Canada) the date format in parameter bar will be as (regardless of the Language property of our report (or in CRM)):-
The format of date time parameter is always decided by the Language settings of client browser regardless of the Language property of our report (or in CRM).
Examples:-
If we have the Client browser language settings in English (AU), the date format in parameter bar will be as (regardless of the Language property of our report (or in CRM)):-
But when we run the same in the Client browser where language settings is in French (Canada) the date format in parameter bar will be as (regardless of the Language property of our report (or in CRM)):- We can change the date time format in the report data using1. CultureInfo (by adding the vb script in code section of the report) in Web App
2. CRM_CalendarTypeCode from the user settings in CRM.
2 comments:
hello,
i have date parameter in ssrs report. the query is working in sql,in report project. but when i deploy it to crm. it doesn't give me any data. in query i am using activityointer view. i am comparaing the date parameter with modifiedon.
Please let me know why this is happening?
Your help is highly appreciated.
hello,
i have date parameter in ssrs report. the query is working in sql,in report project. but when i deploy it to crm. it doesn't give me any data. in query i am using activityointer view. i am comparaing the date parameter with modifiedon.
Please let me know why this is happening?
Your help is highly appreciated.
Post a Comment