exporting to CSV (comma delimited)

Hi,
I've done a report based on several fields and i want to export my report in
a CSV file. Unfortunatly my fields have commas in it. So, is there a
opportunity to change
the deliminator to e.g. ; or #?
Thanks for answering
Tom.Sufix the report URL with &rs:format=CSV&rc:FieldDelimiter=%23 for #
delimiter and &rs:format=CSV&rc:FieldDelimiter=";" for semi-colon delimiter.
Refer to
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_34fa.asp
for an explanation on FieldDelimiter CSV device info setting.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tom" <tom.suhr@.bbtsoftware.ch> wrote in message
news:uoNyKwlaEHA.996@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I've done a report based on several fields and i want to export my report
in
> a CSV file. Unfortunatly my fields have commas in it. So, is there a
> opportunity to change
> the deliminator to e.g. ; or #?
> Thanks for answering
> Tom.
>
>|||Hello,
thanks for your help. Unfortunatly I still have the problem.
because I do not wan't to programm enything. Is it possible
to define the deliminator in the report.rdl or whithin the report-manager?
My solution should be independent from any program, and I want,
that the administrator only has to define the time of the job. My locig
is all in a stored procedure.
Thanks for helping
Tom.
"Ravi Mumulla (Microsoft)" wrote:
> Sufix the report URL with &rs:format=CSV&rc:FieldDelimiter=%23 for #
> delimiter and &rs:format=CSV&rc:FieldDelimiter=";" for semi-colon delimiter.
> Refer to
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_34fa.asp
> for an explanation on FieldDelimiter CSV device info setting.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Tom" <tom.suhr@.bbtsoftware.ch> wrote in message
> news:uoNyKwlaEHA.996@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I've done a report based on several fields and i want to export my report
> in
> > a CSV file. Unfortunatly my fields have commas in it. So, is there a
> > opportunity to change
> > the deliminator to e.g. ; or #?
> >
> > Thanks for answering
> >
> > Tom.
> >
> >
> >
>
>|||Hello,
thanks for your help. Unfortunatly I still have the problem.
because I do not wan't to programm enything. Is it possible
to define the deliminator in the report.rdl or whithin the report-manager?
My solution should be independent from any program, and I want,
that the administrator only has to define the time of the job. My locig
is all in a stored procedure.
Thanks for helping
Tom.
"Ravi Mumulla (Microsoft)" wrote:
> Sufix the report URL with &rs:format=CSV&rc:FieldDelimiter=%23 for #
> delimiter and &rs:format=CSV&rc:FieldDelimiter=";" for semi-colon delimiter.
> Refer to
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_34fa.asp
> for an explanation on FieldDelimiter CSV device info setting.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Tom" <tom.suhr@.bbtsoftware.ch> wrote in message
> news:uoNyKwlaEHA.996@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I've done a report based on several fields and i want to export my report
> in
> > a CSV file. Unfortunatly my fields have commas in it. So, is there a
> > opportunity to change
> > the deliminator to e.g. ; or #?
> >
> > Thanks for answering
> >
> > Tom.
> >
> >
> >
>
>|||No. You'd have to specify the device info settings while accessing the
report via URL or rendering a report using SOAP API.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"tomline.se" <tomline.se@.discussions.microsoft.com> wrote in message
news:5298DD2A-AD06-4EE0-90B6-549746B063C4@.microsoft.com...
> Hello,
> thanks for your help. Unfortunatly I still have the problem.
> because I do not wan't to programm enything. Is it possible
> to define the deliminator in the report.rdl or whithin the report-manager?
> My solution should be independent from any program, and I want,
> that the administrator only has to define the time of the job. My locig
> is all in a stored procedure.
> Thanks for helping
> Tom.
>
> "Ravi Mumulla (Microsoft)" wrote:
> > Sufix the report URL with &rs:format=CSV&rc:FieldDelimiter=%23 for #
> > delimiter and &rs:format=CSV&rc:FieldDelimiter=";" for semi-colon
delimiter.
> > Refer to
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_34fa.asp
> > for an explanation on FieldDelimiter CSV device info setting.
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > "Tom" <tom.suhr@.bbtsoftware.ch> wrote in message
> > news:uoNyKwlaEHA.996@.TK2MSFTNGP12.phx.gbl...
> > > Hi,
> > >
> > > I've done a report based on several fields and i want to export my
report
> > in
> > > a CSV file. Unfortunatly my fields have commas in it. So, is there a
> > > opportunity to change
> > > the deliminator to e.g. ; or #?
> > >
> > > Thanks for answering
> > >
> > > Tom.
> > >
> > >
> > >
> >
> >
> >