Missing Row in Excel

All,
We have found a problem with the Excel export today that we cannot
explain at all. We have a plain tabular report that our users
constantly export to Excel.
So far, we haven't had any issues whatsoever, but we have found a very
specific scenario in which the last row doesn't get exported to Excel;
This problem happens only for the Excel export, as all other formats
don't miss the row and the export is 100% sucessful. Bear in mind,
that if we display a different set of results for the same report, the
export is correct. This behaviour is not random, and it can be
repeated time after time.
We would like to know if anybody else as experienced this problem
before, or if there is any known solution.
By the way, we also have seen that when the report doesn't produce any
results at all, that is, only the column headers are displayed, the
export fails with the following error: "Width of excel cell in the
excel sheet exceeded the maximum limit of 1726.5 Points". We know
this problem is documented, but when is it going to be corrected?
Cheers,
Justo.Justo,
I am going to contact you directly about getting a reproduction for the
first issue.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Justo Ruiz" <justoruiz@.hotmail.com> wrote in message
news:d9bb778e.0408200604.5d12c446@.posting.google.com...
> All,
> We have found a problem with the Excel export today that we cannot
> explain at all. We have a plain tabular report that our users
> constantly export to Excel.
> So far, we haven't had any issues whatsoever, but we have found a very
> specific scenario in which the last row doesn't get exported to Excel;
> This problem happens only for the Excel export, as all other formats
> don't miss the row and the export is 100% sucessful. Bear in mind,
> that if we display a different set of results for the same report, the
> export is correct. This behaviour is not random, and it can be
> repeated time after time.
> We would like to know if anybody else as experienced this problem
> before, or if there is any known solution.
> By the way, we also have seen that when the report doesn't produce any
> results at all, that is, only the column headers are displayed, the
> export fails with the following error: "Width of excel cell in the
> excel sheet exceeded the maximum limit of 1726.5 Points". We know
> this problem is documented, but when is it going to be corrected?
> Cheers,
> Justo.|||Bruce/Justo,
Did you resolve this issue? I am experiencing exactly the same
problem...the last row missing only in Excel exports.
Any ideas?
Thanks
TJ
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:%23OqJmTthEHA.704@.TK2MSFTNGP12.phx.gbl...
> Justo,
> I am going to contact you directly about getting a reproduction for the
> first issue.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Justo Ruiz" <justoruiz@.hotmail.com> wrote in message
> news:d9bb778e.0408200604.5d12c446@.posting.google.com...
> > All,
> >
> > We have found a problem with the Excel export today that we cannot
> > explain at all. We have a plain tabular report that our users
> > constantly export to Excel.
> >
> > So far, we haven't had any issues whatsoever, but we have found a very
> > specific scenario in which the last row doesn't get exported to Excel;
> > This problem happens only for the Excel export, as all other formats
> > don't miss the row and the export is 100% sucessful. Bear in mind,
> > that if we display a different set of results for the same report, the
> > export is correct. This behaviour is not random, and it can be
> > repeated time after time.
> >
> > We would like to know if anybody else as experienced this problem
> > before, or if there is any known solution.
> >
> > By the way, we also have seen that when the report doesn't produce any
> > results at all, that is, only the column headers are displayed, the
> > export fails with the following error: "Width of excel cell in the
> > excel sheet exceeded the maximum limit of 1726.5 Points". We know
> > this problem is documented, but when is it going to be corrected?
> >
> > Cheers,
> >
> > Justo.
>

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 Last Row in Excel Output

I am experiencing an issue when I try to export a few of my reports to Excel.
Sometimes when I export to Excel I lose the last row. My reports are very
simple and do not include anything other than a table. I can export it one
day and all of the rows will be included and the next day I will lose the
last row. This is causing confusion among my end users because many of them
also receive a pdf document with the same information; however the pdf is
always correct.
Would someone from Microsoft please let me know if this is a known bug
because I can see nothing wrong with my report.
Thank you,
TimTim,
I am experiencing the same behaviour. Did you ever found out what the
issue was? If so, please share.
One of my report has 161 rows (including headers). When I export this
report to Excel, the last row is missing. Export to other formats work
fine. If I limit the number of rows in the report to 160, all of them
show up in the exported excel. Is there a limit on number of rows
exported on a tab to excel? How do I reset it?
Thanks|||Try adding an additional footer row to the table you are trying to export.
In the first cell enter a value of =" ". This isn't a fix but at least will
you will be able export the table with all of your data.
Tim
"kkaps" wrote:
> Tim,
> I am experiencing the same behaviour. Did you ever found out what the
> issue was? If so, please share.
> One of my report has 161 rows (including headers). When I export this
> report to Excel, the last row is missing. Export to other formats work
> fine. If I limit the number of rows in the report to 160, all of them
> show up in the exported excel. Is there a limit on number of rows
> exported on a tab to excel? How do I reset it?
> Thanks
>|||I had the same issue with a report that contains a matrix object...the
last row of matrix data was being dropped upon Export to Excel. I
simply put a small, empty textbox object directly below my matrix
object...this fixed the problem!

Missing Images in rendered HTML View

Hi,

i have a report with an image on the footer. When i view the report in the designer/report manager or export to any format, everythings fine. Now i have a ASP.NET site which makes a webservice call to get HTML output from my report. in this case no image show up. The Url of the image is like that: h**p://servername/ReportServer?%2fDocuments%2fGerman%2fOrder%2fOrderResponse&rs%3aFormat=HTML4.0&rs%3aImageID=ac8c4a8c-8a63-4ff9-ba74-6d6a7076a0ef

When i check the HTML version of the Report Manager the url of the image is like: h**p://servername/Reports/Reserved.ReportViewerWebControl.axd?ReportSession=iuwsgfikvz4ezfmd0tqmyj45&ControlID=cee4d933-5ab6-413f-8c28-4c3a2b3ff230&Culture=1031&UICulture=7&ReportStack=1&OpType=ReportImage&StreamID=84e7491d-eab4-4502-adac-2bec4254da90

I take the byte stream of the report from the RS Service an put it to the HttpResponse of the ASP.NET page.

What could be the problem?

When you render a report which contains an image or a chart (which is really just an image), you not only have to call Render(), but then you call RenderStream() for each image in the report. Books online has some good examples of this.|||

Ok, when i understand it correctly, the RenderStream method provides the functionality to get each image stream for this report.

The images in my report are external images and are part of the project. In this case i can use the DeviceInfo - parameter HTMLFragment set to true. But this doesn't work.

What could be te problem?