Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
Skilled Commentator
Posts: 5
Registered: ‎06-19-2009

Crystal Reports with multiple Data Sources

In our 7.5 version of SalesLogix we have data that is being brought in from an AS400 system via a Linked Server that we created views for in SalesLogix. We want to have the reports that we create go against SalesLogix and the actual AS400 system and not the Link Server. When we run the report during creation it works fine. It's only when we add it to the architect and release it that the errors start.  We get an error message stating that the table, which is on the AS400, can not be found. 

 

Does anybody know or have a way to use multiple sources in crystal and SalesLogix  and have the data come back without errors?

 

Thanks in advance

Moderator
Posts: 440
Registered: ‎05-07-2008

Re: Crystal Reports with multiple Data Sources

Are the views added in DB Manager?

John Perona

Director, Infor CRM Development

Infor CRM

Infor CRM

Skilled Commentator
Posts: 5
Registered: ‎06-19-2009

Re: Crystal Reports with multiple Data Sources

Yes the views are in the DB Manager