Link to home
Start Free TrialLog in
Avatar of shpresa
shpresaFlag for United States of America

asked on

Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

Hello
When i expert a report in excel it gives me this errror: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

It is so strange to me, the report itself is fine, it works with my old database, but recently i upgraded to a cloud solution and it gave the above error. All other reports work but this.

Any suggestion?
Avatar of zephyr_hex (Megan)
zephyr_hex (Megan)
Flag of United States of America image

How is the report export being done?
ASKER CERTIFIED SOLUTION
Avatar of Fernando Soto
Fernando Soto
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of shpresa

ASKER

I understand,
to me what makes it more weird is the the same code works fine when connected to my old database, the error does not show, once i connect it to the new database which it should be identical, the error shows up. It sounds to me that something within the database is bothering it. I have a lots of coding on this as it involves a whole report but I will and see if i can find anything within the database. Thanks
Avatar of shpresa

ASKER

Apperently i had done a chance on the database that effected it. I had reduced a value, or taken a row down. Thanks.
Not a problem shpresa, glad to help.