You’re offline. This is a read only version of the page.
Hello:
We are on Management Reporter 2012 CU13 with the Legacy Adapter.
Within a column definition, we created a "CALC" column containing an "If, then" formula. When we ran the report, the column displayed accurate data. Good!
When we went back into the column definition, afterward, we tried to insert a column to the right of this "CALC" column. Upon doing so, though, we were kicked out of Report Designer and the following error appeared:
"Index and length must refer to a location within the string."
I have seen two postings here in the Community on this error but no resolution. Also, I went on CustomerSource for Dynamics GP and none of the service pack fix lists address this error.
Does anyone know how to eliminate this error?
Thank you!
John
*This post is locked for comments
I have the same question (0)Our client's setup is SL with MR2012 CU14. They received the same error when inserting a column in an existing column format. Experimenting with variations of the column layout, we found that MR was able to update cell references for simple column calculations; a formula like C + D = E would be updated on inserting a column. A more complex calculation would not update when inserting a column. IF D = 0 then D else C/D would not automatically update. Removing the formula that was not automatically updated allowed inserting a new column without error. We removed the problem formulas before inserting a column, pasting them to Excel for updating the column references, then pasted them back into MR after inserting a column.
It seems like a low level bug, hopefully one that will be addressed in a later MR update.
Share
Report
All responses (
Answers (
719
