Systems Engineering and RDBMS

SSRS and Excel rendering limitations

Posted by decipherinfosys on October 13, 2009

Ran into an issue at a client site today in which one of the columns of the report was getting a concatenated string of the DC’s for the suppliers.  It turns out that for one of them, the string was over the limit that excel could handle and as a result when the end user was trying to export out the data to excel, it failed.  Here is what the error was:

SSRS_ERR_1

And when you clicked on Yes, you would get this:

SSRS_ERR_2

Needless to say, both are cryptic messages – after looking up on technet and MSDN and googling/binging🙂 it for a while, came across the limitations of excel rendering which we thought that we would post here so that the readers can benefit from it as well.  The limitations are mentioned here:

http://msdn.microsoft.com/en-us/library/ms156418(SQL.90).aspx

The report design was changed as well since there was no need to have that concatenated list in this case but it is good to be aware of the limitations so that you know the next time what might be a possible cause for that weird error that excel throws at you.

2 Responses to “SSRS and Excel rendering limitations”

  1. Jerry Hammond said

    I believe those limitations are for Excel 2003. Excel 2007 has a much greater row and column range. 1,048,576 rows by 16,384 columns

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: