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 |
|
davidagnew37
Starting Member
33 Posts |
 Posted - 2007-09-05 : 13:51:44
|
| I get this error when exporting to Excel from the designer or from the Report Manager:"Exception: Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index"One solution is:(1) One Detail Cell in my table contained a number like #.#########. Aparently this freaks out Excel. I converted it to a string like this:=Convert.ToString(Format((ReportItems!ValueOne.Value / ReportItems!ValueTwo.Value), "#.#########")) This sometimes works but makes the export have text fields and numbers under 0 show just .01 instead of 0.01 for example. (2) Apparently disabling the Document Map Labels has the same effect and cures the problem - HOW DO YOU DO THIS?????? There is a label property for text boxes - but these are not populated. Reading the internet..says that the SP2 for SQL server should slolve it. It hasnt. please help..ThanksDavid |
|
|
jimbob051
Starting Member
1 Post |
Posted - 2007-09-10 : 05:23:17
|
| Hi David,Do you have any images in your report? I've just discovered that the size of an image can cause the renderer to throw this error. In my case I had a company logo that measured 5.07937cm x 2.1164cm. Changing this to 5cm x 2cm fixed the problem.The following article lists image size as a possible cause (3rd item down):http://technet.microsoft.com/en-us/library/aa337266.aspxHope this helps,James |
 |
|
|
|
|
|
SSRS Index out of range