Solved

How to export existing data fields/dataset to an xml file

Posted on 2011-09-13
5
193 Views
Last Modified: 2012-05-12
This report was made with vb.net 2005. I have an existing crystal report where its database fields were created from a dataset made in my vb project. Someone deleted and remove the dataset from the vb project. I know there's a way to export the database fields to an xml file or something where you can then reimport, add new columns and update it in the report. I don't remember how to do this. Can someone refresh my memory?
0
Comment
Question by:glenn_r
  • 2
5 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 36533038
I don't know if this example of feeding the report from the application has enough code or not ti help

http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx

mlmcc
0
 
LVL 40
ID: 36533740
No backup??? :-)

Exporting the structure of tables to XML is a feature that is implemented in different ways depending on each database.

In Access for example, where I had to do that job a few years ago, you can right-click on a table, select Export, xml file, and you will be asked if you want to save the data or only the schema. Since you are talking about a DataSet, there were probably many linked tables. In such a case, you create a query with the tables and their link and export the query as explained for the table.

In other database, it's done through a SQL command.

So consult your database documentation or tell us the database you are using. Somebody might be able to help.

In Visual Studio, when you open an xml document that contains a schema, the schema is exposed in a graphical representation that shows the tables and their links. You can change that schema with right clicks. Note that although xml is a standard, some schemas might not be recognized properly when you import them in Visual Studio.

Your greatest problem will be to recreate a DataSet that is exactly as the one that was there. Unless it was documented, it can be a pain.

I hope this helps.

Good luck.
0
 

Accepted Solution

by:
glenn_r earned 0 total points
ID: 36535907
Let me rephrase the question. I have a vb.ne project that contains a dataset with one table defined. I created a crystal report and then right click database fields and database expert from the context menu. Then click project data and finall ado.net datasets to add it to the project. Basically it displays the table name and the fields in the crystal field explorer. From here I drag the fields to the report designer to site them. I have a customer where they've delete the vb.net dataset. I need to add a few fields to the table and right now the only way to do that is to recreate the vb.net dataset, add the fields and then use the database fields set datasource command to update the crystal table and fields. Allot of work. I've done this in the past but forgot how. You can export the crystal table and fields and import it back into the project. Hope this clarifies my question.
0
 

Author Closing Comment

by:glenn_r
ID: 37736771
no solution
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

This article explains how to create and use a custom WaterMark textbox class.  The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.   IMAGE OF WATERMARKS STEPS Create VB …
If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

707 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now