Report Builder Formatting Currency

Hi all

I need Report Builder to format Certain Numbers
as Currency by default. According to the documentation
I need to set the culture setting in the report's datasource.

I'm using a SSAS2005 Cube
The Report Manager then let's me create the Model wich is used
by Report Builder.

My Question is: Where do I set the culture setting?

I cannot find it in the Cube and viewing the model's xml hasn't helped.
Any help will be dearly appreciated

G

under format in properties of the textbox

change it to

$ ###, ###, ###.##

|||

Thanks X

But I know how to format the textbox.
The problem is that I want my measures to default to
currency format like this: (R #,##.##0.00;R (#,##.##)0.00;R ##.#0)
when added to the table/matrix

The docementation for Report Builder says that it can be
done by setting the "Culture" Setting on the Datasource.?

They dont give any other specifics

Thanks for the responce

G

|||

maybe set it in Connection String ?

Data Source=myServer;Initial Catalog=myDatabase;Current Language=en-us

|||

Hi

No good, the report model does not contain a connection string.
As this is what Report Builder uses: I'm assuming that this is the datasource
that is being reffered to.

Still stuck

G

|||

GDavids - SAO wrote:

No good, the report model does not contain a connection string.
As this is what Report Builder uses: I'm assuming that this is the datasource
that is being reffered to.

report model have Datasources link in Properties

Datasource have connection string ;]

|||

thanks giret

Where do I view this?

In Report Manager? Because I dont find it..

Thanks for the reponces

|||

http://localhost/Reports/

click on Your model name

Properties Tab:

General

DataSources

Security

|||

This gives the path to my datasource.

Does this mean that I have to set the connection string for
that datasource that the path from the model refers to?