Print Page | Close Window

Report with Multiple Databases Degrading Over Time Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2022 Forum Name: Data Connectivity Forum Discription: How to connect to data sources and export reports URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14988 Printed Date: 22 Apr 2025 at 6:16am Topic: Report with Multiple Databases Degrading Over Time Posted By: jabucket Subject: Report with Multiple Databases Degrading Over Time Date Posted: 21 Nov 2011 at 8:08am I have a report which is using one database for billing/receiving information and another database for cost details. Both tables in each respective DB have a common table which contains the code for each billable unit. When I initially create the inner join and add the cost data to the table, it works well. What happens next is very odd to me. One parameter for the report is the date range, and I notice that as I continue to work on the report, the available dates in that parameter eventually degrade to only January 2011. When I browse data, the available dates are all still there, but the report doesn't see it. If I remove the cost database from the database expert, the full range of dates returns. Replies: Posted By: kostya1122 Date Posted: 23 Nov 2011 at 11:11am i would suggest to create a  stored procedure then work of it. crystal report and multiple data sources don't seem to work well. another thought is a sub report.

Print Page | Close Window