export to csv file places all detail line on 1 line of CSV?

trying to write a report that when exported (csv) each detail line in my
report would be a seperate line in the csv file currently the csv places all
detail line on the same line in the csv and delimits the row by comma. is
there a way in the csv rendering to allow the RecordDelimiter to be a
<cr><lf>?thanks you are correct but maybe I'm not being clear on my end the columns
are not the issue. I have 3 detail line in the report each line has 3 columns
report table
detail line1
detail line2
detail line3
but when i export to csv i get
(record1) line1,line2,line3
next(record) line1,line2,line3
etc...
what i'm looking for is
(record1)
line 1
line 2
line 3
(nextrecord)
line1
line2
line3
make any more sense?
thanks in advance for all the help
"Bruce L-C [MVP]" wrote:
> I assume you want Excel to open this up. RS defaults to unicode which Excel
> does not recognize. If RS 2005 you can configure RS to export it as Ascii
> which Excel will then properly split into cells.Even if what you want is a
> file for some other reason, I have RS configured for ASCII csv and my rows
> are NOT separated by a comma. So I think regardless of what you want to do
> follow the below and see if it resolves it for you:
> You only need to change in one place, rsreportserver.config. Reboot after
> the change. The below shows commenting out the existing entry and putting in
> the needed change to have CSV export as ASCII.
> .. <!--
> <Extension Name="CSV"
> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
> -->
> <Extension Name="CSV"
> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
> <Configuration>
> <DeviceInfo>
> <Encoding>ASCII</Encoding>
> </DeviceInfo>
> </Configuration>
> </Extension>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "gackinclose" <gackinclose@.discussions.microsoft.com> wrote in message
> news:CFE91818-CC7B-4297-8802-0C15BBB52998@.microsoft.com...
> > trying to write a report that when exported (csv) each detail line in my
> > report would be a seperate line in the csv file currently the csv places
> > all
> > detail line on the same line in the csv and delimits the row by comma. is
> > there a way in the csv rendering to allow the RecordDelimiter to be a
> > <cr><lf>?
> >
>
>|||I assume you want Excel to open this up. RS defaults to unicode which Excel
does not recognize. If RS 2005 you can configure RS to export it as Ascii
which Excel will then properly split into cells.Even if what you want is a
file for some other reason, I have RS configured for ASCII csv and my rows
are NOT separated by a comma. So I think regardless of what you want to do
follow the below and see if it resolves it for you:
You only need to change in one place, rsreportserver.config. Reboot after
the change. The below shows commenting out the existing entry and putting in
the needed change to have CSV export as ASCII.
. <!--
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
-->
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"gackinclose" <gackinclose@.discussions.microsoft.com> wrote in message
news:CFE91818-CC7B-4297-8802-0C15BBB52998@.microsoft.com...
> trying to write a report that when exported (csv) each detail line in my
> report would be a seperate line in the csv file currently the csv places
> all
> detail line on the same line in the csv and delimits the row by comma. is
> there a way in the csv rendering to allow the RecordDelimiter to be a
> <cr><lf>?
>|||Ahh, multiple detail lines. No, they are all considered one line of data for
export. I am not aware of a way to do what you want.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"gackinclose" <gackinclose@.discussions.microsoft.com> wrote in message
news:7DA88C6E-4683-483D-9554-E576566EED48@.microsoft.com...
> thanks you are correct but maybe I'm not being clear on my end the columns
> are not the issue. I have 3 detail line in the report each line has 3
> columns
> report table
> detail line1
> detail line2
> detail line3
> but when i export to csv i get
> (record1) line1,line2,line3
> next(record) line1,line2,line3
> etc...
> what i'm looking for is
> (record1)
> line 1
> line 2
> line 3
> (nextrecord)
> line1
> line2
> line3
>
> make any more sense?
> thanks in advance for all the help
>
> "Bruce L-C [MVP]" wrote:
>> I assume you want Excel to open this up. RS defaults to unicode which
>> Excel
>> does not recognize. If RS 2005 you can configure RS to export it as Ascii
>> which Excel will then properly split into cells.Even if what you want is
>> a
>> file for some other reason, I have RS configured for ASCII csv and my
>> rows
>> are NOT separated by a comma. So I think regardless of what you want to
>> do
>> follow the below and see if it resolves it for you:
>> You only need to change in one place, rsreportserver.config. Reboot after
>> the change. The below shows commenting out the existing entry and putting
>> in
>> the needed change to have CSV export as ASCII.
>> .. <!--
>> <Extension Name="CSV"
>> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
>> -->
>> <Extension Name="CSV"
>> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
>> <Configuration>
>> <DeviceInfo>
>> <Encoding>ASCII</Encoding>
>> </DeviceInfo>
>> </Configuration>
>> </Extension>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "gackinclose" <gackinclose@.discussions.microsoft.com> wrote in message
>> news:CFE91818-CC7B-4297-8802-0C15BBB52998@.microsoft.com...
>> > trying to write a report that when exported (csv) each detail line in
>> > my
>> > report would be a seperate line in the csv file currently the csv
>> > places
>> > all
>> > detail line on the same line in the csv and delimits the row by comma.
>> > is
>> > there a way in the csv rendering to allow the RecordDelimiter to be a
>> > <cr><lf>?
>> >
>>