?
Solved

Report tools in Access Dimensions

Posted on 2008-06-24
1
Medium Priority
?
872 Views
Last Modified: 2013-12-08
HI all.
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.
0
Comment
Question by:dexterhome
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 5

Accepted Solution

by:
dexterhome earned 0 total points
ID: 21856208
Should have stated that the application uses crystal reports as standard within it and that it has set templates that i should be able to modify.
Should also state that if i try to re-link the tables from within crystal i get error messages stating that the field can not be found
0

Featured Post

Build and deliver software with DevOps

A digital transformation requires faster time to market, shorter software development lifecycles, and the ability to adapt rapidly to changing customer demands. DevOps provides the solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

These days socially coordinated efforts have turned into a critical requirement for enterprises.
Let’s face it: one of the reasons your organization chose a SaaS solution (whether Microsoft Dynamics 365, Netsuite or SAP) is that it is subscription-based. The upkeep is done. Or so you think.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question