Update XSD file after modifying [:^(]
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22198
Printed Date: 20 Apr 2024 at 3:29am
Topic: Update XSD file after modifying [:^(]
Posted By: HDMiller
Subject: Update XSD file after modifying [:^(]
Date 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.
|
Replies:
Posted By: hilfy
Date 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
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
Posted By: HDMiller
Date 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.
|
Posted By: hilfy
Date 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
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
Posted By: HDMiller
Date Posted: 26 Jan 2017 at 11:38am
|
I'll give this a try and repost when I have time. Thank you for responding.
|
|