Numeric format - International settings

Hey,
I have following problem :
When is make a query in the enterprice manager I receive all numbers in an
european way (decimal = , no thousand separator is shown ex 1000,52).
When I make the same query in the query analyser i receive the output as
follows 1000.5200
I want it in an european format : 1000,52.
Is there a way to declare this in the query (like you can do with the
datatimes : set dateformat dmy).
I have the same problem when I export the data via a DTS. Can I not say to
him that he have to export numbers in a european format?
Thanks in advance
jacJac,
Try the Query Analyzer setting Tools|Options|Connections Tab|"Use
regional options when displaying currency, numbers, dates, and times."
The display in Query Analyzer will then conform to the Control Panel
settings for Regional display options.
Steve Kass
Drew University
jac wrote:

>Hey,
>I have following problem :
>When is make a query in the enterprice manager I receive all numbers in an
>european way (decimal = , no thousand separator is shown ex 1000,52).
>When I make the same query in the query analyser i receive the output as
>follows 1000.5200
>I want it in an european format : 1000,52.
>Is there a way to declare this in the query (like you can do with the
>datatimes : set dateformat dmy).
>I have the same problem when I export the data via a DTS. Can I not say to
>him that he have to export numbers in a european format?
>Thanks in advance
>jac
>|||Thanks Steve.
But how I say to my DTS (makes a query select * from XXX and export it in a
textfile) that he has to use the regional settings?
Thanks
"Steve Kass" wrote:

> Jac,
> Try the Query Analyzer setting Tools|Options|Connections Tab|"Use
> regional options when displaying currency, numbers, dates, and times."
> The display in Query Analyzer will then conform to the Control Panel
> settings for Regional display options.
> Steve Kass
> Drew University
> jac wrote:
>
>

Numeric format - International settings

Hey,
I have following problem :
When is make a query in the enterprice manager I receive all numbers in an
european way (decimal = , no thousand separator is shown ex 1000,52).
When I make the same query in the query analyser i receive the output as
follows 1000.5200
I want it in an european format : 1000,52.
Is there a way to declare this in the query (like you can do with the
datatimes : set dateformat dmy).
I have the same problem when I export the data via a DTS. Can I not say to
him that he have to export numbers in a european format?
Thanks in advance
jacJac,
Try the Query Analyzer setting Tools|Options|Connections Tab|"Use
regional options when displaying currency, numbers, dates, and times."
The display in Query Analyzer will then conform to the Control Panel
settings for Regional display options.
Steve Kass
Drew University
jac wrote:
>Hey,
>I have following problem :
>When is make a query in the enterprice manager I receive all numbers in an
>european way (decimal = , no thousand separator is shown ex 1000,52).
>When I make the same query in the query analyser i receive the output as
>follows 1000.5200
>I want it in an european format : 1000,52.
>Is there a way to declare this in the query (like you can do with the
>datatimes : set dateformat dmy).
>I have the same problem when I export the data via a DTS. Can I not say to
>him that he have to export numbers in a european format?
>Thanks in advance
>jac
>|||Thanks Steve.
But how I say to my DTS (makes a query select * from XXX and export it in a
textfile) that he has to use the regional settings?
Thanks
"Steve Kass" wrote:
> Jac,
> Try the Query Analyzer setting Tools|Options|Connections Tab|"Use
> regional options when displaying currency, numbers, dates, and times."
> The display in Query Analyzer will then conform to the Control Panel
> settings for Regional display options.
> Steve Kass
> Drew University
> jac wrote:
> >Hey,
> >
> >I have following problem :
> >When is make a query in the enterprice manager I receive all numbers in an
> >european way (decimal = , no thousand separator is shown ex 1000,52).
> >
> >When I make the same query in the query analyser i receive the output as
> >follows 1000.5200
> >I want it in an european format : 1000,52.
> >
> >Is there a way to declare this in the query (like you can do with the
> >datatimes : set dateformat dmy).
> >
> >I have the same problem when I export the data via a DTS. Can I not say to
> >him that he have to export numbers in a european format?
> >
> >Thanks in advance
> >jac
> >
> >
>

Numeric format - International settings

Hey,
I have following problem :
When is make a query in the enterprice manager I receive all numbers in an
european way (decimal = , no thousand separator is shown ex 1000,52).
When I make the same query in the query analyser i receive the output as
follows 1000.5200
I want it in an european format : 1000,52.
Is there a way to declare this in the query (like you can do with the
datatimes : set dateformat dmy).
I have the same problem when I export the data via a DTS. Can I not say to
him that he have to export numbers in a european format?
Thanks in advance
jac
Jac,
Try the Query Analyzer setting Tools|Options|Connections Tab|"Use
regional options when displaying currency, numbers, dates, and times."
The display in Query Analyzer will then conform to the Control Panel
settings for Regional display options.
Steve Kass
Drew University
jac wrote:

>Hey,
>I have following problem :
>When is make a query in the enterprice manager I receive all numbers in an
>european way (decimal = , no thousand separator is shown ex 1000,52).
>When I make the same query in the query analyser i receive the output as
>follows 1000.5200
>I want it in an european format : 1000,52.
>Is there a way to declare this in the query (like you can do with the
>datatimes : set dateformat dmy).
>I have the same problem when I export the data via a DTS. Can I not say to
>him that he have to export numbers in a european format?
>Thanks in advance
>jac
>
|||Thanks Steve.
But how I say to my DTS (makes a query select * from XXX and export it in a
textfile) that he has to use the regional settings?
Thanks
"Steve Kass" wrote:

> Jac,
> Try the Query Analyzer setting Tools|Options|Connections Tab|"Use
> regional options when displaying currency, numbers, dates, and times."
> The display in Query Analyzer will then conform to the Control Panel
> settings for Regional display options.
> Steve Kass
> Drew University
> jac wrote:
>
sql

Number Format

Hi all,

I have developed a report in which I need the thousand seperator to be a decimal point.

Instead of presenting the number as 12,923.23 i require that the representation be 12.923,23.

I have tried to customize the the format with the hash value but have had no joy. Any help would be much appreciated.

Ivan

Here's one way to do it. Also if this will be done on the fly, it probably will work best as a user-defined function. You could also nest all of the replace functions for a single select for production, but I did it this way to be more readable.

declare @.test money

Set @.test = '12923.23'

Select Replace(Convert(varchar(50),@.test,1),',','[,]')

Select Replace(Convert(varchar(50),@.test,1),'.','[.]')

Select Replace(Convert(varchar(50),@.test,1),'[,]','.')

Select Replace(Convert(varchar(50),@.test,1),'[.]',',')

print @.test

|||

Thanks for the help, its much appreciated.

I ended up sorting out the issue by changing the language property to Italian on the table and entering 'N' in the format property in the desired column.

This then gives the numerical representation which I was looking for.It works because this is the way that the Italians and many other countries represent their numbers.

|||where will i write this code? i right click the textbox carrying the number.From the menu choose properties and then select format tab.Then in the expression area if i write this code , there is an error.Could you help me?|||

You must not write these code in expression editor.

you can write a code as a function in vb.net in report code editor. you need to call that fuction in expression editor.

you can impliment custom code to get the desired results

Number Format

Hi all,

I have developed a report in which I need the thousand seperator to be a decimal point.

Instead of presenting the number as 12,923.23 i require that the representation be 12.923,23.

I have tried to customize the the format with the hash value but have had no joy. Any help would be much appreciated.

Ivan

Here's one way to do it. Also if this will be done on the fly, it probably will work best as a user-defined function. You could also nest all of the replace functions for a single select for production, but I did it this way to be more readable.

declare @.test money

Set @.test = '12923.23'

Select Replace(Convert(varchar(50),@.test,1),',','[,]')

Select Replace(Convert(varchar(50),@.test,1),'.','[.]')

Select Replace(Convert(varchar(50),@.test,1),'[,]','.')

Select Replace(Convert(varchar(50),@.test,1),'[.]',',')

print @.test

|||

Thanks for the help, its much appreciated.

I ended up sorting out the issue by changing the language property to Italian on the table and entering 'N' in the format property in the desired column.

This then gives the numerical representation which I was looking for.It works because this is the way that the Italians and many other countries represent their numbers.

|||where will i write this code? i right click the textbox carrying the number.From the menu choose properties and then select format tab.Then in the expression area if i write this code , there is an error.Could you help me?
|||

You must not write these code in expression editor.

you can write a code as a function in vb.net in report code editor. you need to call that fuction in expression editor.

you can impliment custom code to get the desired results