.XSD file updates not being seen in a report

I have created a report using SQL Server 2008 R2 in VS2010 that uses a TableAdapter in an XSD file created within VS. Now when I change the query in the table adapter, the changes don't seem to be applied to the report. Is the XSD query information being cached somewhere?
steve_webberAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
You probably need to to a "Verify Database" in Crystal Reports to pull in the latest changes to the file.  Crystal Reports expects table structure to remain consistent, so if changes have occurred you need to confirm them.  Within the standalone copy of Crystal Reports, it's a simple matter of using the menu Database|Verify Database.  There may be a similar function in the VS2010 version.
steve_webberAuthor Commented:
I am not using Crystal Reports (although I'm not sure what technology is embedded in Visual studio). I'm just using the built-in capabilities of VS. I have refreshed the database information that VS has read from the server. You may be right in that there may be another way to refresh the definition file, but I have not been able to find it.
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
sorry about that, this came up in my list of neglected questions and I'm a Crystal Reports expert. I just assumed it was a question regarding the VS2010 version of Crystal Reports.
steve_webberAuthor Commented:
I have found the problem here. The problem was that the Dataset used when defining a report is not used when executing the report for display purposes. You need to explicitly specify a dataset at report display time.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
steve_webberAuthor Commented:
This explains the behavior well.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.