[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

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

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
glenn_r
Asked:
glenn_r
  • 2
1 Solution
 
mlmccCommented:
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
 
Jacques Bourgeois (James Burger)Commented:
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
 
glenn_rAuthor Commented:
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
 
glenn_rAuthor Commented:
no solution
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now