Post reply

SSRS Exporting issues when client has multiple versions of Excel

  • October 17, 2011 at 2:46 pm

    #390637

    Our users have two versions of Excel (2003 & 2007) on their machines. We have several reports that return more than 65K records. By default SSRS is looking for the 2003 version and failing when the users export the report because of the limitations of Excel 2003. The obvious solution would be to uninstall Excel 2003 - but this is not an option. Is there a way to tell SSRS to look for the 2007 version first? We are using SSRS 2008. (we are not on R2).

    Any help would be appreciated!

    Thanks,

    Beth

  • October 17, 2011 at 3:32 pm

    #1395613

    Actually - the problem is not that they have both versions - they do not. However it seems SSRS 2008 is using the same constraints as Excel 2003. I guess the question is - how can I allow users to export large datasets directly into Excel?

  • October 17, 2011 at 4:09 pm

    #1395625

    Export to a tab delimited file and import that to Excel.

  • October 17, 2011 at 4:19 pm

    #1395626

    Lynn Pettis (10/17/2011)

    Export to a tab delimited file and import that to Excel.

    Does that import in the correct format? Does it keep calculated columns on the report or that csv is just the dataset?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply