Missing Row in CSV Export

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
ChadIf you add rectangle/ blank image / blank label above your report, CSV export
will work.
"Chad McKee" wrote:
> 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
> Chad
>|||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.
"Chad McKee" <cmckee@.startech-comp.com> wrote in message
news:%2340961OeFHA.3048@.TK2MSFTNGP12.phx.gbl...
> 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
> Chad|||> 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.
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|||Thanks to everyone who replied. The Hotfix fixed the issue.
Thanks
Chad
Brian Welcker [MSFT] wrote:
> 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.
>

Missing Header Footer in

Hey all-

We have a number of reports that have headers and footers in HTML and PDF, but when exporting to Excel the headers and footers disappear.

Has anyone else seen this happen? Any ideas on how to re-enable the headers?

Thanks in advance,

Tristan

Tristan, did you find a way to do this? I am in a very similar position where the footers are not displayed.

Thanks,
AJ

Missing file: c:\stylesheet.css

I'm exporting a matrix report generated by Reporting Services to Excel. When
I open the report in Excel the first time, I get no messages. IF I open this
report in Excel and click the SAVE option (whether I made changes or not),
the next time I try to open the Excel file I get the message:
Missing file: c:\stylesheet.css
While you can click OK and ignore this message and the file will open, I
would like to find a way to prevent this when this report is put into
production.
FYI: I'm on Reporting Services SP2, SQL Server 2000, Excel 2003 SP1
Thanks.
--
DJansonI am experiencing this same error. Have you found a solution to it?
"DJanson" wrote:
> I'm exporting a matrix report generated by Reporting Services to Excel. When
> I open the report in Excel the first time, I get no messages. IF I open this
> report in Excel and click the SAVE option (whether I made changes or not),
> the next time I try to open the Excel file I get the message:
> Missing file: c:\stylesheet.css
> While you can click OK and ignore this message and the file will open, I
> would like to find a way to prevent this when this report is put into
> production.
> FYI: I'm on Reporting Services SP2, SQL Server 2000, Excel 2003 SP1
>
> Thanks.
> --
> DJanson|||No, but I did find out that not everyone who runs/opens this report has this
problem. I sent the exported file to another user and they did not get this
message.
--
DJanson
"DJanson" wrote:
> I'm exporting a matrix report generated by Reporting Services to Excel. When
> I open the report in Excel the first time, I get no messages. IF I open this
> report in Excel and click the SAVE option (whether I made changes or not),
> the next time I try to open the Excel file I get the message:
> Missing file: c:\stylesheet.css
> While you can click OK and ignore this message and the file will open, I
> would like to find a way to prevent this when this report is put into
> production.
> FYI: I'm on Reporting Services SP2, SQL Server 2000, Excel 2003 SP1
>
> Thanks.
> --
> DJanson