Author |
Message |
HDMiller
Newbie
Joined: 30 Nov 2016
Location: United States
Online Status: Offline
Posts: 5
|
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 Logged |
|
hilfy
Admin Group
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
|
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 Logged |
|
HDMiller
Newbie
Joined: 30 Nov 2016
Location: United States
Online Status: Offline
Posts: 5
|
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 Logged |
|
hilfy
Admin Group
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
|
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 Logged |
|
HDMiller
Newbie
Joined: 30 Nov 2016
Location: United States
Online Status: Offline
Posts: 5
|
Posted: 26 Jan 2017 at 11:38am |
I'll give this a try and repost when I have time. Thank you for responding.
|
IP Logged |
|
|