Extract Data from Crystal repor

Question

0.00/5 (No votes)

See more:

Hi All,

My problem is that I have a crystal report (a .rpt file) and I want to load that file in a different project and extact the database objects used in that report, like Columns, tables , datatypes etc.

I had done lots of googling but didn't find any solution.

Hope you guys can help.
Thanks in advance

Step by Step Details:

I have a Crystal Report which is dynamically bind on a table.
Lets assume its the table (In actual I have no idea about that table):

ID Name Age Gender Phone

In the report I have only 3 fields, i.e. ID, Name and Age.

Now I have to create a project that will take that .rpt file as a parameter and show the fields used in the report (In this case they are: ID, Name and Age), their datatypes, Keys used (if any).

I hope this is clear now.

Posted 11-Jan-11 21:25pm

astrovirgin

Updated 11-Jan-11 22:17pm

v4

Add a Solution

Comments

Dalek Dave 12-Jan-11 3:49am

Edited for Grammar and Readability.

Sandeep Mewara 12-Jan-11 3:51am

Not clear.

thatraja 12-Jan-11 4:09am

Confusing question, clear it step by step

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Anupama Roy · Answer 1 · 2011-01-11T23:21:00

Solution 1

Convert your rpt to csv & then read the csv from C#.

Check this link

http://stackoverflow.com/questions/3101187/how-do-i-convert-rpt-files-to-csv[^]

You can convert csv to a dataset too & then make use of the columns.

If you are able to do it this way,post it as a Tip/Trick in codeproject so that it will help others too.

Posted 11-Jan-11 23:21pm

Anupama Roy

Updated 11-Jan-11 23:24pm

v2

Comments

Espen Harlinn 12-Jan-11 5:52am

5+ Nice and simple solution :)

Anupama Roy 12-Jan-11 6:49am

Thank you!

Kathaliya · Answer 2 · 2011-01-18T16:05:00

Solution 2

Sweet this is a life saver for those of you who prefer c#

ReportDocument report = new ReportDocument();
report.Load(@"reportname.rpt");        report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.ExcelRecord, @"filename.xls");

Posted 18-Jan-11 16:05pm

Kathaliya

Updated 18-Jan-11 17:30pm

v2

Comments

RaviRanjanKr 18-Jan-11 23:31pm

Code is wrapped in "pre" tags for Make it better readability.