crystal reports

Question

Can we pull from multiple data sources (besides just Estimating) in a custom report setup in Report Manager.

Erzsi_I · Answer

Hi @Jenny, 
 Thanks for reaching out! Yes, you can pull from multiple data sources in a custom report setup in Report Manager, but there are some key considerations and best practices: 
 
 Using ODBC Connections &ndash; Crystal Reports can connect to multiple databases via ODBC. If your additional data sources are accessible through ODBC, you can link them within the report. More details here . 
 Linking Tables Properly &ndash; When pulling from multiple data sources, ensure that table relationships are correctly defined to avoid data integrity issues. 
 Performance Considerations &ndash; Queries pulling from multiple sources can slow down reports. Using subreports or stored procedures can help optimize performance. Check out this guide for best practices . 
 Using SQL Commands &ndash; If your sources are within the same SQL database, using SQL commands or views can streamline data retrieval. 
 Alternative Approach &ndash; If combining sources directly in Crystal Reports is too complex, consider pre-aggregating the data in a separate reporting database or Excel before bringing it into Report Manager. This article might help . 
 
 Would love to hear if others in the community have tried this&mdash;any best practices to share? 
 If this helps, please mark it as verified! Warm Regards, Erzsi

Sage Construction & Real Estate

crystal reports

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING