Date format issue in RDLC

Question

Hello everyone I had created a report in using RDLC report. The report showing correct date format according to my system configuration i.e dd/MM/yyyy but when I export it to PDF the format is changed to MM/dd/yyyy. Image of date format at report Image of date format when exported to PDF How to solve that. I didn't changed the format anywhere else Thanks Devendra

Rajanikant Hawaldar · Answer

Hi dear I suggest you to use dd/MMM/yyyy format at ur report Thanks

Devendra Kumar · Answer

@Suraj I tried that way also but the format still not stable and changes its format. can anyone help me on this. Thanks Devendra

Suraj Kumar · Answer

I want to say you that the format is needed to change in report not on the actual query. As in report you have to only view the data. After changing the type the data will be same. Any reason you don't want to convert date? I have also show you the second option to add a blank string to that data at the beginning and end. You need to only apply formula at the design time.

Devendra Kumar · Answer

Hi Suraj thanks for your reply actually we cannot convert the format to varchar because the date is fetched from the database and when we do that we don't have the command to change the format. As mentioned in report it is showing as per system settings this only happens when the report gets exported to either pdf word or excel

Suraj Kumar · Answer

Try with this format to your date field. Keep your data type as varchar and in textbox expression =cstr(Fields!Expr1.Value) You can also try this =  +Fields!YourFieldName.Value +