Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Facing issues in extracting 80k rows into excel using SSRS 2008 R2 (looking for fix) Expand / Collapse
Author
Message
Posted Monday, February 11, 2013 12:06 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, August 2, 2014 2:11 PM
Points: 34, Visits: 100
getting an error which says no. of rows cannot exceed 65k in order to extract to excel.
Post #1418592
Posted Monday, February 11, 2013 12:30 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 31, 2014 3:18 PM
Points: 103, Visits: 122
Prior to Excel 2007, the limit was 65K. Are you running a pre-2007 version?
Post #1418601
Posted Monday, February 11, 2013 10:44 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 12, 2013 5:02 AM
Points: 1, Visits: 83
Hi

check out below link


http://msbitips.wordpress.com/2012/10/18/solution-for-issue-max-65536-rows-limitation-while-exporting-ssrs-report-to-excel-2003/
Post #1418753
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse