crystal reports

SUGGESTED

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

  • 0
    SUGGESTED

    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:

    1. Using ODBC Connections – 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.
    2. Linking Tables Properly – When pulling from multiple data sources, ensure that table relationships are correctly defined to avoid data integrity issues.
    3. Performance Considerations – 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.
    4. Using SQL Commands – If your sources are within the same SQL database, using SQL commands or views can streamline data retrieval.
    5. Alternative Approach – 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—any best practices to share?

    If this helps, please mark it as verified! Blush

    Warm Regards,
    Erzsi