I have a report in SSRS 2005 that renders fine in report manager and can be exported in every format except Excel. Export to Excel produces the following error occurs: Item has already been added. Key in dictionary: '_41_138' Key being added: _41_138. The report producing the error has a list containing a subreport. In fact it is only a list with a subreport. The subreport when run independently can be exported to Excel with no problem. Any help would be appreciated. Thanks! --John

By the way, I am using SQL 2005 (9.00.3054) SP2. Thanks.

I had this same problem, and opened a support case with Microsoft. This is how it was resolved... Thank you for choosing Microsoft. Problem: When exporting reports containing subreports to Excel, certain reports generate the following Exception: System.Exception: Item has already been added. Key in dictionary: '_41_82' Key being added: '_41_82' Environment: SQL Server Reporting Services 2005 SP2 Root Cause: A bug in the product. Resolution: Change the NumeralVariant property of each TextBox in the subreport from 1 to ="1". This can be done either in the BIDS designer or by adding the following tag to the <Styles> element of each TextBox in the RDL file: <NumeralVariant>="1"</NumeralVariant> According to the bug on file, this appears to have been fixed in the latest beta of SQL Server 2008.

You sir are a true gentleman and a scholar. That did the trick. Thanks! --John

I was having the same problem and the NumeralVariant solution didn't work for me. In my case, I found that the errors occurred when there were sections of the subreport that didn't have any data. I specified the "NoRows" parameter on each table of the subreport and it worked.

Thanks Chris, Even I was facing the same problem, Export to PDF was working and Excel wasnt. And your resolution worked for me. Thanks a lot. I had 1 main report and 9 sub reports in it. Initially it was difficult to find out in which subreport it was failing. Once I found which subreport was failing, I updated every textbox(including the textboxes in table) in that subreport, then it resoved the problem.