Solved

Retrieve Crystal Report data from .rpt file

Posted on 2004-10-11
13
430 Views
Last Modified: 2010-05-02
I need to read in crystal report data from a saved report where the data is saved WITH the report.

the report is sent from an external source, so the database does not exist on MY computer.

i need to know how to read in each record, for only particular fields...
i'll then put all of that data into my own access database.

can you help me?

thanks,
jeremy

*** points WILL be raised upon refund of a previous question that i have closed.
0
Comment
Question by:Jeremy Daley
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
13 Comments
 
LVL 3

Expert Comment

by:kenspencer
ID: 12278956
Hi,
I am not sure how to read data straight from a crystal .rpt file, but perhaps you could open the report and export it?

Ken
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 12278958
I don't think there is an easy way to do what you want.  Unless you can get the report file format it won't be possible.

mlmcc
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 12279956
That's a good idea Ken.  I didn't think of that but you could export the report to a CSV or Excel format and use an application to read the data.

mlmcc
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
LVL 4

Author Comment

by:Jeremy Daley
ID: 12280015
i have exported to an excel file and read in the cells which was a perfect idea... but it just so happens that this report contains 2 subreports (which have vital information in THEM)

for some reason, crystal reports won't export the sub report data to the excel file... so i don't know any other way that i can retrieve this information except for reading in the records by their specific field name as they're labelled in crystal reports.

i figured it would not be possible since the databases don't exist on my computer... but the fact that the data is saved WITH the report... i thought it would be very possible to do so.

------------------------
mlmcc... i'm not sure what you mean by:
"Unless you can get the report file format it won't be possible." --> what format do you mean?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 12281733
You want to read information from the report file instead of displaying it.  To do that you need the format of the file so you can easily find the values you desire.

I haven't looked at a report file that has data saved but I doubt there is an area with the records laid out in a way you can get the information.

You are correct about the export, however there are 3rd-party applications that export the subreports so it must be possible.

Here is a list.  In particular look at Visual Cut.  It has received some very good comments from experts on this site.

http://www.kenhamady.com/bookmarks.html

mlmcc
0
 
LVL 4

Author Comment

by:Jeremy Daley
ID: 12287890
i still don't know what you mean by "format of the file"...

and the records have to be somewhere, or else they wouldn't display on the report...

3rd party software is out of the question.
my boss is definitely not going to go for buying a $200 program for performing such a little function.

thanks for the suggestion though

***point increase to 250
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 12559904
Do you still need help?

>>still don't know what you mean by "format of the file"...
The Report file has a format that Crystal understands and uses to display the report or allow you to edit the report.  If you look at it, it is basically jibberish.  Unless you know the format and where.how the data is stored in it, you can't read it and make sense from it.

mlmcc
0
 
LVL 4

Author Comment

by:Jeremy Daley
ID: 12561367
what i did found out is that if you export to a Microsoft Word document, it will keep the subreport data somehow.

i don't want to cheat anyone, but i'm going to request a refund on this question unless there are objections.

...please let me know.

jeremy
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 12733320
Do you still want to pursue this any further?

If so how are you doing the export?

Are the subreports visible in the report or do you have to open them by clicking?

mlmcc
0
 
LVL 4

Author Comment

by:Jeremy Daley
ID: 12741309
i'm done with this question...
everything above explains the whole situation... please refer to that.
thanks
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 12752477
PAQed with points refunded (250)

modulo
Community Support Moderator
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses
Course of the Month9 days, 20 hours left to enroll

623 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