Crystal Report Error when in Epicor

When I'm Epicor and try to open a modified Crystal Report I receive this error...

"Invalid login for (login:userID:server:database:table) = "jdoe":"sysprogress":"OpenEdge10C":"":"Customer"."

There are 3 people in the company of about 50 that are receiving this error. Epicor said that I have to go through EVERY report and change the ODBC connection. However, when i do that the report works for us 3, but then the other 47 people in the company get that error. There has to be a more logical solution here