Displaying Price in Microsoft reporting services

hai

I am using Microsoft reporting services.
I am using XSD as report datasource to bind data to the report
In the report, i want to display Amount in french belgiun format in a column eg. 123.456,00 €
While passing the value through datasource, i cant able to pass the value as decimal.
I am only passing it as string. While exporting to excel ,i cant able to make calculations on this field
because it is exported as string.
Is there is any other way to dispaly the value as 123.456,00 € in the report and exported to excel as numeric
to perform calculations
Plz give your suggestions

Regards,

Sakthi

hai

I have solved this problem by using Laguage property for the report.

You can change the report language to french -belgium

And now you can able to display decimal value in french format

Regards

Sakthi