1. Home
  2. Knowledge Base
  3. MAPADOC - Sage 100 Cloud
  4. Crystal Reports | Forms
  5. MAPADOC Reports have no data except for headings

Issue

MAPADOC Reports have no data except for headings. This issue can occur in versions 4.10 or higher and is caused by ODBC permissions for MAPADOC–if so enabled within the Sage system.

Resolution

If the MAPADOC reports contain no data except for report headings and footers, go into Library Master’s Role Maintenance and make sure that the MAPADOC module is checked on the ODBC Security tab. Note that this tab is not available on every system – only if the system has ODBC security enabled.

If the ODBC Security tab is enabled you must give permissions to the MAPADOC tables. If the tab is not enabled you must turn on ODBC Security by going to File>Register and checking the “Enable ODBC Security within Role Maintenance”, return to Role Maintenance and give permission to the MAPADOC tables, and then turn ODBC Security back off.

Was this article helpful?

Related Articles