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 |
|
bushfoot
Yak Posting Veteran
53 Posts |
 Posted - 2009-02-18 : 10:38:57
|
| I have a report that contains a table. The proc for the report returns approx 120 000 rows. Using Report Viewer object to generate reportsI have added the ado dataset containing all the rows to the datasource (120000)When the report is generated it contains ONLY 65 000 rows. Is there any properties on the reportViewer to indicate NOT to truncate the rows? Is this a limitation of the table object? |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-02-18 : 13:18:14
|
| That's a limitation of excel, 65k row maximum.Mike"oh, that monkey is going to pay" |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-18 : 13:33:45
|
| what you could try is to use document map in report and span the data across seperate tables/containers based on some category and export to excel so that it will come over different sheets |
|
|
|
bushfoot
Yak Posting Veteran
53 Posts |
Posted - 2009-02-18 : 13:36:51
|
| I dont think it is excel. I have written a rendering extension and there is no excel at the point when rows go from 120 000 (the DataSet.DataTable.Row.Count) to 65 000 (Microsoft.ReportingServices.ReportRendering.Table). |
|
|
|
Cody
Starting Member
24 Posts |
Posted - 2009-02-18 : 16:27:45
|
| Which version of Excel? The limit was about 65000 rows, which increased in the last version or two. |
|
|
|
|
|
|
Exporting Table report to excel -stops at 65000