Link to home
Start Free TrialLog in
Avatar of STEVEN WEBBER
STEVEN WEBBERFlag for United States of America

asked on

.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?
Avatar of Kurt Reinhardt
Kurt Reinhardt
Flag of United States of America image

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.
Avatar of STEVEN WEBBER

ASKER

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.
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.
ASKER CERTIFIED SOLUTION
Avatar of STEVEN WEBBER
STEVEN WEBBER
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This explains the behavior well.