Link Access to SQL tables using Crystal Reports
Link Access to SQL tables using Crystal Reports
(OP)
I'm new to Crystal. I using Crystal Reports to acccess my GoldMine database and wanted to inlcude fields from an access file as well.
So far I've been able to gather all of the GoldMine informaiton with no problem. However I have had problems including the Access information.
The Access file contains "county" data that I want to include in the report along with the GoldMine data. So, if the user want to access everyone who lives in Illinois, in the county of Cook.
So far I've been able to include the Access db in my report. I did get an error message "More than one datasource or stored procedure has been used in this report. Pls make sure htat no SQL Express is added and no server-side group by is performed". No idea what that means.
Any ideas or suggestions?
So far I've been able to gather all of the GoldMine informaiton with no problem. However I have had problems including the Access information.
The Access file contains "county" data that I want to include in the report along with the GoldMine data. So, if the user want to access everyone who lives in Illinois, in the county of Cook.
So far I've been able to include the Access db in my report. I did get an error message "More than one datasource or stored procedure has been used in this report. Pls make sure htat no SQL Express is added and no server-side group by is performed". No idea what that means.
Any ideas or suggestions?
RE: Link Access to SQL tables using Crystal Reports
Probably a better chance of getting a response here;
Business Objects: Crystal Reports 2 Data Access Forum
forum 766
Nuffsaid.
Nuffsaid.