"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>???
>

"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>???
>> >
>>
>>
>>