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.