Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Update XSD file after modifying [:^(] Post Reply Post New Topic
Author Message
HDMiller
Newbie
Newbie


Joined: 30 Nov 2016
Location: United States
Online Status: Offline
Posts: 5
Quote HDMiller Replybullet Topic: Update XSD file after modifying [:^(]
    Posted: 20 Jan 2017 at 4:41am
Hello Everyone! I'm have an issue with XSD files. A little background, my company uses crystal to generate forms for our customers. I've been added the team to modify reports (the core team is in Germany so support is difficult). We use XSD files to access a SQL database. My company made the SQL DB so twisted linked internally that it's like bowl of spaghetti. I can't figure out the internal mapping. Anyway, I know how to modify the XSD to add new nodes, no problem. The issue I have is making crystal use that newly modified XSD file! I have created a new connection, mapped it to that folder and it shows up in crystal, with the little plug (I'm assuming that plug means it's connected) Problem is when I copy that XSD to a new machine, yes in the exact same folder, it continues to use the old XSD. I've verified the DB, Logged off the old XSD, even found out how to delete the old XSD from my PC. It always seems to remember that old DAMN XSD file. Does anyone have any tricks to force crystal to use my new XSD file? Any help is greatly appreciated, I've been fighting this for weeks now.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 20 Jan 2017 at 5:13am
There are two possibilities and I'm not sure which will work.

1. Use "Verify Database" to see if it will read the new XSD. This will be the easiest if it works.

2. Use "Set Location" to connect to the new XSD through a new connection.

In either case, you'll have to save the .rpt file and then distribute it with the new .xsd file.

-Dell
IP IP Logged
HDMiller
Newbie
Newbie


Joined: 30 Nov 2016
Location: United States
Online Status: Offline
Posts: 5
Quote HDMiller Replybullet Posted: 20 Jan 2017 at 8:29am
Thanks for the reply Dell. That is what I've done. It just seems to always remember that old connection in the report and ignore my new one.
Is there a way to wipe the connection from the report? Each time I open it it loads that old XLS information.   
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 20 Jan 2017 at 9:34am
Try this:

1. Open a fresh copy of Crystal.
2. Open a report that does NOT use the XSD you're having issues with.
3. Delete the connection to the old XSD.
4. Create a connection to the new XSD that has the same name as the one to the old XSD.
5. Open the report that connects to this and select "Verify Database".
6. Use something from the new XSD on the report.
7. Save the report and close Crystal.

Now try opening the saved report in Crystal and see whether that works.

-Dell
IP IP Logged
HDMiller
Newbie
Newbie


Joined: 30 Nov 2016
Location: United States
Online Status: Offline
Posts: 5
Quote HDMiller Replybullet Posted: 26 Jan 2017 at 11:38am
I'll give this a try and repost when I have time. Thank you for responding.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.014 seconds.