sql server reporting services: default delimiter change from comma to semicolon -- sql server reporting services

You're in the

sql server reporting services

group:

default delimiter change from comma to semicolon

AG, NLB d.d.
11/9/2004 11:35:01 PM

sql server reporting services: Is this possible? I now that i can use custom application to do this, but is
it possible to change semicolon as a default delimiter on server.

Thank's in advance..

RE: default delimiter change from comma to semicolon

Glenn F. Henriksen
11/9/2004 11:58:01 PM

[quoted text, click to view]

This probably has to do with the default regional setting on the server. For
US formats comma is used as list seperator, but for most EU countires comma
is used as the decimal seperator so they use semicolon as list seperator.
Otherwise you could get into trouble with a list like this:
5,67,34,56,32,09
Is it 5;67;34;56;32;09 or is it 5,67;34,56;32,09 or any other combination.

In regional settings you can change what the seperator character should be.

Perhaps this link will help you:
http://www.adopenstatic.com/faq/systemdateformat.asp

RE: default delimiter change from comma to semicolon (export data fro)

AG, NLB d.d.
11/10/2004 7:08:05 AM

i'am sorry to mislead you.

I have a problem with exporting data in CSV format, because data includes
commas, so i have to use some other delimeter like semicolon as default
delimiter on server.

Thanks.

[quoted text, click to view]

RE: default delimiter change from comma to semicolon (export data

Glenn F. Henriksen
11/10/2004 2:03:07 PM

[quoted text, click to view]

Okay, I haven't tried this, but I think you could change the list seperator
value in the control panel->regional settings. But you have to do it for the
user that Reporting services is running under. You may have to change the
default user's settings. Make the change on your own account and then try to
set it to the default system value.

Another option is to make sure that your data in enclosed in quotes, like
this:
"35,54","this, is a test", "example.com, example.net"

--
Glenn F. Henriksen

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn