All Standard Crystal Forms and Report are not populating data in Sage 100 2022 PU1...ODBC Issue

SUGGESTED

I have just upgraded my client's live Sage 100c advanced 2019 PU 4 to Sage 100c 2022 PU 1.  Everything migrated to new server properly and the data for the live company was converted fine too.  I am experiencing an issue with the ODBC both for User and System DSN for both 32 Bit and 64 for bit.  None of the Crystal Standard Reports and/or forms are populating with data within the application (Sage 100c 2022 on MS Server 2022 Standard).  I cannot even records extracted vi MS Query to Excel.  The number of record count is proper in all the standard Crystal reports/forms and MS Query rows however, no data is returned to either the report or the MS Excel workbook.  In case of Crystal reports, the only thing that is printed and/or previewed are the number of blank pages for each report/form.  In case of MS Query the data that is extract to MS Excel, the number of blank records and the column heading labels are extracted with proper number of rows but each row is just blank.

The ODBC Security is not enabled and the user has full permission to all modules' tasks  and Security Options.  I have removed and reinstalled the client workstations (on Windows 2022 Server standard) but this has not made any difference.  I have reached out to Sage 100 Technical Support but no resolution has evolved yet.   I am wondering if  anyone has experienced this issue before and if so, how it was resolved.  

Parents Reply Children
No Data