Solved

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

Posted on 2011-09-13
5
212 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

791 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