Updating an xsd file... why does Crystal Reports ALWAYS kick my Axx?? -- Part IV [End for now]

After the Altiris-a-rama was complete, I finally got back to this.

Very possibly the workstation was in a 'weird mode' Friday, Monday AND yesterday during my other problems, <start spin> but it doesn't excuse the other things that were going on surrounding Crystal Reports, e.g. the Exception message</start spin>

I worked as if I only had one shot to get it right:

  • Got a Diet Dr. Pepper and 2 Extra-Strength Excedrines
  • Refreshed from Version Control
  • Modified the element I wanted to replace in the xsd, all the way to desired end result
  • Deleted the xsx and cs files, then saved the xsd to reproduce them
  • Close Project, Exit VS
  • Reopen both, open the rpt file, go to the main report, right-click, Database->Set Location and pick the Visual Studio Class then pick the ds name in both boxes and hit the Replace button
  • Close Project, exit VS (because the Field Explorer still showed the original)
  • Reopened both, went to the subreport, and Field Explorer was now correct. Drag both new fields to the report, take the defaults for now
  • In the code behind, modified the query to read from my new table
  • Press F5 and pray (at this point, the pray part is more important than the above)
  • It works!
  • Very carefully modify the rpt visual effects to get the two new fields the way I want them and get the Heck out of the code

I did a complete release rebuild and tested, Saved to Version Control, deployed it to the Intranet, and tested it there to be correct before I took a really deep breath.

What a deal... glad it works... on to more fun things!

posted @ Wednesday, November 08, 2006 2:32 PM

Print

Comments on this entry:

# re: Updating an xsd file... why does Crystal Reports ALWAYS kick my Axx?? -- Part IV [End for now]

Left by Wayne at 8/21/2007 3:12 PM
Gravatar
Since this is almost a year old, this may not help. Doubly-so since you're doing this through VS and not the Crystal Reports program. In CR, there is an ability to refresh your data source. At that point it re-reads your attached tables/views/whatever and will reflect whatever underlying changes that you've made to your data. I have no idea how you'd do that from within VS, but if you have the full CR also installed, then that would be one way to do it.

Sorry I can't be more specific, I'm a SQL Server DBA/developer rather than an actual Crystal or VB programmer.

Good luck!

# re: Updating an xsd file... why does Crystal Reports ALWAYS kick my Axx?? -- Part IV [End for now]

Left by Barbara at 9/23/2007 3:51 PM
Gravatar
This article helped with a problem I'd been struggling all weekend with. Namely that a different stored procedure was used as a datasource in the report designer than was used in the codebehind file! Thanks so much. I mean, I spent around 5 hours on this this weekend, but now I feel better that I solved the problem!

Your comment:



 (will not be displayed)


 
 
 
Please add 1 and 5 and type the answer here:
 

Live Comment Preview:

 
«August»
SunMonTueWedThuFriSat
272829303112
3456789
10111213141516
17181920212223
24252627282930
31123456