Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ciupaz
Posting Yak Master
232 Posts |
 Posted - 2011-10-25 : 05:36:28
|
| Hi all,maybe someone has already this happened, but I'm experiencing a strange behavior when I export to Excel a generated report with Reporting Services 2003 by an ASP.NET.Precisely cut the last record, which appears in the pop-up web but then mysteriously disappears in the Excel file generated.Does anyone have idea why happens this strange behavior?Happens with both Excel 2007 and 2010.Thanks in advance. Luigi |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-25 : 06:12:29
|
| is it going beyond excel max row limit?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Ciupaz
Posting Yak Master
232 Posts |
Posted - 2011-10-25 : 06:24:24
|
| It seems that the Excel can not grow over 32 rows. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-25 : 07:31:19
|
quote:
Originally posted by Ciupaz
It seems that the Excel can not grow over 32 rows.
nope thats not true anyways------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Ciupaz
Posting Yak Master
232 Posts |
Posted - 2011-10-25 : 07:42:35
|
| Where I can check if there is something that limit the rows? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-25 : 07:47:14
|
| check if you've any paging applied in your report?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Ciupaz
Posting Yak Master
232 Posts |
Posted - 2011-10-25 : 08:22:19
|
| No, none paging at all, I think (where I can check it, in SSRS 2003?) |
|
|
|
Ciupaz
Posting Yak Master
232 Posts |
Posted - 2011-10-25 : 08:27:12
|
| If I put my 2 tables (header and content) in separate sheets (make a page break after the first one, for example) all the records appears. I really don't understand. |
|
|
|
|
|
|
[RS 2003] Excel export cut last record