My excel outout is missing the last row of the recordset. HTML, PDF, and the
other outputs are ok. This is a simple report with no grouping. Please help.Derek,
Have you tried to add a blank footer row to the table?
This way if the bug does occur it will just drop a blank footer and not your
data. (I know this is idea is just a band-aid not a fix but MS seems to be
ignoring this problem.)
I have not tested this theory myself because I have only seen this happen a
few times and each time I tried to dup the results everything worked fine.
Do you have a report that has a regular problem that you could test my theory
for me?
Tim
"Derek Howard" wrote:
> My excel outout is missing the last row of the recordset. HTML, PDF, and the
> other outputs are ok. This is a simple report with no grouping. Please help.
Showing posts with label missing. Show all posts
Showing posts with label missing. Show all posts
Wednesday, February 15, 2012
Excel Missing Rows (Managed NewsGroup Post)
Hello,
I am posting this through the MSDN Managed NewsGroup section. We are
experiencing the following problem:
When programatically exporting MS Reporting Services Reports to Excel - the
last row turns up missing. This does not happen 100% of the time but enough
that we cannot reliably send out to customers.
If you have never seen this happen I can provide you with a zip file with
sample data and the report. The report is a very simple column style report
that uses a stored procedure.
We have checked the stored procedure and it is returning the appropriate
data. When viewing in HTML all of the rows show up - it is only when the
report is exported to Excel that the last row comes up missing.Microsoft,
Please contact me and I will forward the report and the dataset to reproduce
the prolem.
"chanley54" wrote:
> Hello,
> I am posting this through the MSDN Managed NewsGroup section. We are
> experiencing the following problem:
> When programatically exporting MS Reporting Services Reports to Excel - the
> last row turns up missing. This does not happen 100% of the time but enough
> that we cannot reliably send out to customers.
> If you have never seen this happen I can provide you with a zip file with
> sample data and the report. The report is a very simple column style report
> that uses a stored procedure.
> We have checked the stored procedure and it is returning the appropriate
> data. When viewing in HTML all of the rows show up - it is only when the
> report is exported to Excel that the last row comes up missing.
I am posting this through the MSDN Managed NewsGroup section. We are
experiencing the following problem:
When programatically exporting MS Reporting Services Reports to Excel - the
last row turns up missing. This does not happen 100% of the time but enough
that we cannot reliably send out to customers.
If you have never seen this happen I can provide you with a zip file with
sample data and the report. The report is a very simple column style report
that uses a stored procedure.
We have checked the stored procedure and it is returning the appropriate
data. When viewing in HTML all of the rows show up - it is only when the
report is exported to Excel that the last row comes up missing.Microsoft,
Please contact me and I will forward the report and the dataset to reproduce
the prolem.
"chanley54" wrote:
> Hello,
> I am posting this through the MSDN Managed NewsGroup section. We are
> experiencing the following problem:
> When programatically exporting MS Reporting Services Reports to Excel - the
> last row turns up missing. This does not happen 100% of the time but enough
> that we cannot reliably send out to customers.
> If you have never seen this happen I can provide you with a zip file with
> sample data and the report. The report is a very simple column style report
> that uses a stored procedure.
> We have checked the stored procedure and it is returning the appropriate
> data. When viewing in HTML all of the rows show up - it is only when the
> report is exported to Excel that the last row comes up missing.
Subscribe to:
Posts (Atom)