Export report into csv format using reporting service?

Question

I used to default export option in reporting service to export the report in CSV format.

my table result is

         sno   sname     values          method
         1      aaa       123,124,145     aa
         2      bbb       234,454,565     bb
         3      ccc       454,511,455     cc

This table value i exported in csv format that time display wrong alignment...

         sno   sname     values        method          
         1      aaa       123           124        145     aa
         2      bbb       234           454        565     bb
         3      ccc       454           511        455     cc

is it possible to comma is no need to separate the value in csv....

plz help me soon....

comments like "plz help me soon...." will not encourage SO users to help you any faster. — user359040
– user359040, Commented Nov 19, 2010 at 11:41

user359040 · Accepted Answer · 2010-11-19 11:41:03Z

1

Select the cell holding the values field in the report designer, then check the Format property in the properties window - this will probably be set to something like #,### . To remove the commas from the values field, change the Format property to be # .

answered Nov 19, 2010 at 11:41

user359040

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Export report into csv format using reporting service?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related