Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't access Dynamics Tables through Crystal Reports

Status
Not open for further replies.

debrichards

Vendor
Sep 26, 2003
9
US
Previously I had access to my Dyamics tables using Crystal Reports (8.5). Then a while back we had a version update for Dynamics (To 6.00g52). My previous tables were accessed like the example below.

Table: Caltc.dbo.SOP30300
Server Type: ODBC-CALTECH
Server Name: dynsql
Database: master
User ID: XXXX

After the update this path no longer led to the tables I was used to seeing but to other information such as:

master.dbo.MSreplication_otions
master.dbo.spt_committab

An outside computer support person has me accessing the tables as follows:

Table: CALTC.dbo.30300
Server Type: ODBC-CALTC
Server Name: CALTC
Database: CALTC
User ID: XXXX

Unfortunately before they left we did not verify that I could actually get information from the tables only that they were visible to me.

So now when I build a report using these table I access NO information. I am very discouraged and would like to fix this problem on my own with someones help of course.

Is there something I can do (or am not doing correct)or is it going to be necessary to call back in computer support?

Any help would be appreciated.

Thanks,

Debbie R
 
This is pretty database/application specific. I would post this to the Great Plains forum.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top