Missing Row in CSV Export -- sql server reporting services

Chad McKee
6/24/2005 1:49:39 PM

Hi Everyone,

I'm having an issue with a row of data missing when exporting to CSV.
The report structure is as follows:

Group 1 Header - Grouping on State (Displays the State)
Group 2 Header - Grouping on Customer ID (Displays a summary for each
customer)
Detail Row - <This Row has Been Removed>
Group 2 Footer - <This Row has Been Removed>
Group 1 Footer - Displays totals for the state

The report renders fine to PDF and will export all data to XML. When I
export to CSV, the first row is always missing. I have two reports with
similar structure and suffers from the same issue.

Any help would be greatly appreciated.

Thanks

Sonali
6/24/2005 6:01:02 PM

If you add rectangle/ blank image / blank label above your report, CSV export
will work.

[quoted text, click to view]

Brian Welcker [MSFT]
6/25/2005 11:22:20 AM

We have posted a hotfix that includes a fix for this issue at
http://www.microsoft.com/downloads/details.aspx?FamilyId=7FFE50D4-AFF8-4C1E-9609-6798190C2D58&displaylang=en.

--
Brian Welcker
Group Program Manager
Microsoft SQL Server

This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Christoph Wienands
6/27/2005 8:57:32 AM

[quoted text, click to view]

Hmm, haven't looked into the problem but maybe the CSV export is getting
confused with header rows. In case you just can't find a work-around, a
custom CSV rendering extension might be the solution. I imagine that
shouldn't be too hard to accomplish.

Christoph

Chad McKee
6/27/2005 11:58:54 AM

Thanks to everyone who replied. The Hotfix fixed the issue.

Thanks
Chad

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Missing Row in CSV Export