Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Report with Multiple Databases Degrading Over Time Post Reply Post New Topic
Author Message
jabucket
Newbie
Newbie


Joined: 15 Nov 2011
Location: United States
Online Status: Offline
Posts: 7
Quote jabucket Replybullet Topic: Report with Multiple Databases Degrading Over Time
    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.
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.