Reporting Services Currency Symbol

I have added User!Language to my report which returns en-GB but the currency
format 'C' still returns the values in $ and not £
MSDN and an earlier post here mentions the help text that has this section
'you can set a locale on the report and on individual text boxes by using
the Language property'
If I right click on the field on the report and select properties there is
no Language property so I do not understand where it is talking about
Any ideas?
TIA
NeilThe Language property shows up in the VS Property window (hit F4).
Note: every report has a global language property (in the VS Property
window, select "Report" from the top drop-down box and then look for the
Language property). It seems like it is set to "en-US" in your case. You
need to set the Report-Language to "Default" and republish it to the report
server. Then at runtime, the report will be processed in the thread culture
specified in the Internet Explorer language settings.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Neil" <Neil@.discussions.microsoft.com> wrote in message
news:210F44A1-EFFB-42F8-8A72-EEE76B40D3A1@.microsoft.com...
> I have added User!Language to my report which returns en-GB but the
currency
> format 'C' still returns the values in $ and not £
> MSDN and an earlier post here mentions the help text that has this section
> 'you can set a locale on the report and on individual text boxes by using
> the Language property'
> If I right click on the field on the report and select properties there is
> no Language property so I do not understand where it is talking about
> Any ideas?
> TIA
> Neil
>|||Hi Robert,
Thanks, I had just found that myself, the confusion was caused by the text
box having 2 property windows, one was right-click and the other the bottom
right hand corner window, and the help file did not state which to use, so I
was right clicking and selecting properties which had the currency format
style 'C'
thanks
Neil.
"Robert Bruckner [MSFT]" wrote:
> The Language property shows up in the VS Property window (hit F4).
> Note: every report has a global language property (in the VS Property
> window, select "Report" from the top drop-down box and then look for the
> Language property). It seems like it is set to "en-US" in your case. You
> need to set the Report-Language to "Default" and republish it to the report
> server. Then at runtime, the report will be processed in the thread culture
> specified in the Internet Explorer language settings.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Neil" <Neil@.discussions.microsoft.com> wrote in message
> news:210F44A1-EFFB-42F8-8A72-EEE76B40D3A1@.microsoft.com...
> > I have added User!Language to my report which returns en-GB but the
> currency
> > format 'C' still returns the values in $ and not £
> >
> > MSDN and an earlier post here mentions the help text that has this section
> > 'you can set a locale on the report and on individual text boxes by using
> > the Language property'
> >
> > If I right click on the field on the report and select properties there is
> > no Language property so I do not understand where it is talking about
> >
> > Any ideas?
> >
> > TIA
> >
> > Neil
> >
>
>