Missing fields when report is reloaded through server
I have an ODBC connection to an MS SQL CRM database, and the ODBC connection works just fine, every field comes through when used on my desktop. However, if I want to reload this QV report through the QV Server, some fields are missing, or even worse, has missing data! I have already checked the rights of the server in CRM database, every right is given to it, so it can't be a problem.
Have any of you encountered such problem? If so, how could you solve it?