decimal separator

Hi

Im experimenting with the reportViewer control in a .net 2.0 winform application, and I'm having a little problem: I can find no way to change the decimal separator(or the thousand separator) of a column of numbers in a table. I have tried all sorts of Format(), formatNumber() and FormatCurrency(). I've also tried to explicitly set the CurrentCulture of the application to a new cultureinfo object, and I've tried to change the culture of the datasets that the reports are base on.

Also, when calling the FormatCurrency() the output allways shows $ even though I find no trace of using USD anywhere in my system.

Any constructive hints out there?

Than you in advance,

Snorre

In ReportViewer control properties you can change Language property and that will change format for number, date, currency ...
|||

Thanks for your reply. Although I can't find the Language property anywhere: In the property page, in the intellisence, on the LocalReport object or anywhere else. Are you using the winform version of the control? Are there different versions of the control? I'm using the one shipping with visual studio.

Thanks.

Snorre

|||

I finally figured this out.

There was a Language property as suggested, not on the controller, but on the textbox(and table/matrix/chart) element in the report. What confused me though was that this box was overridden when using something like:

=format(sum(Fields!myfield.Value),"#,###.00")

To correct this I had to put the format string in the property field instead, and remove the formatting from the formula. Hope this helps someone...

Snorre