Solved

.XSD file updates not being seen in a report

Posted on 2013-12-24
5
238 Views
Last Modified: 2014-01-05
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?
0
Comment
Question by:steve_webber
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 39740325
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.
0
 

Author Comment

by:steve_webber
ID: 39740466
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.
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 39740476
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.
0
 

Accepted Solution

by:
steve_webber earned 0 total points
ID: 39748617
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.
0
 

Author Closing Comment

by:steve_webber
ID: 39757138
This explains the behavior well.
0

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…
Suggested Courses

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question