I am running a report and get report error "invalid object name mscfld. I have changed the report form to the system report, no change, and searched the code for the word invalid, none was there.
Do you have a calculated field with a name it doesn't recognize? mscfld is a table with over 600 fields in it. My guess is it something to do with that, or that what you are doing needs one of those fields for the report.
Hi Char, Thanks for the input. But the report has been functional for 2+ years, and all of a sudden this comes up. There is no reference to any misc field table item. I'm very aware of those. Stumped,
Was there an update done? Maybe that affected it. Or the data that it is trying to pull is invalid?
Was there an update done? Maybe that affected it. Or the data that it is trying to pull is invalid?
Char, Thank You for your help, so very much. This has expanded into 3 separate Report Writer issues, and I am now working with someone at Sage in a leadership position to get help on all these issues. I will contact you directly once it is resolved to pass on the results. Any time you want to reach me, call 480-277-7550. Thanks again for your friendship and help all these last 20+ years. Jim
*Community Hub is the new name for Sage City