My firm is in the process of installing a new computer system
with are changing from sage mms to a new application called dimensions by access. (access, dimensions)
(the application is for warehouse management, like SAP)
This application uses sql to store its databases/tables. We have installed SQL 2005.
The system works fine.
We then wish to run reports using crystal reports 9. I spoke with the support people and they advised my to run the reports from within dimension as the table references too confusing to run directly against the sql database.
When i do this it opens the document and looks like it will work, but when you refresh the report it advises that all the tables can not be accessed.
does any one have any experience with this software, if so does anyone have an answer.
If you have any questions, please ask.
Note, I am a beginner with all the products. sql 2005, access dimensions, crystal reports 9.