Hi guys, I'm using Windows 7, VS 2010, .NET Framework 4 and Microsoft reports (*.rdlc) in my project.
The problem is with displaying decimal values on my reports. My regional settings are Croatian (Croatia) and I want decimal values to be displayed as 1.234,56 I tried all kinds of formating combinations but whatever I do it always displays 1,234.56. When I format the field to use the regional settings it always displays 1,234.56 even for dates 1/13/2010, like it always use some hidden English (US) regional settings. I tried different OS, and it's still the same, all except one, Windows Vista displays normal as it should be, i just set all fields to use regional settings and every field type is exactly as I want it to be. I fixed the dates with custom format 'd.M.yyyy' but decimal values still remain the problem. So what do you think? Where is the problem? Majority of my clients is using Windows XP or Windows 7 so I need to find the solution. It seems like that on XP or Windows 7 the report is ignoring OS regional settings and is forcing his internal hidden settings which is English (US). The last solution will probably be to edit my stored procedure to convert all decimal fields to string and then do replacing of ',' and '.' and then send it to my report. But I hope you can help me before that last solution which I would rather not use :(
