October 19, 2010 at 8:00 am
We have recently upgraded our report services install from 2005 to 2008. We have a subscription to are report that generates a file that is exported of site everyday. We have added an export option to reportserver.config for ASCII encoded CSV.
<Extension Name="TXT" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
<OverrideNames>
<Name Language="en-US">TXT (ASCII-encoded CSV)</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
<ExcelMode>false</ExcelMode>
<FileExtension>csv</FileExtension>
<NoHeader>true</NoHeader>
</DeviceInfo>
</Configuration>
</Extension>
This subscription exports to file, and in 2005 an empty dataset would produce an empty file. After the upgrade to 2008, this subscription is saving a single row of commas when the dataset is empty.
I understand the the renderer underwent some fairly major revision. Does anyone know a way for me to prevent the row of commas from being produced when the dataset is empty?
October 26, 2010 at 12:04 pm
*bump*
I think it has something to do with the DataElementOutput property of the tablix static members, but I can't seem to find a setting that works. When I set the column group static members DataElementOutput property to NoOutput, exporting to CSV results in a blank file but does so whether or not the dataset has rows. If the dataset returns data, I obviously want to export those rows, but if the dataset is empty, I want to export an empty file.
I have tried setting that property in the row group static members also to no avail.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply