Improve company productivity with a Business Account.Sign Up

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

Retrieve Crystal Report data from .rpt file

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
Jeremy Daley
Asked:
Jeremy Daley
1 Solution
 
kenspencerCommented:
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
 
mlmccCommented:
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
 
mlmccCommented:
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
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
Jeremy DaleySenior DeveloperAuthor Commented:
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
 
mlmccCommented:
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
 
Jeremy DaleySenior DeveloperAuthor Commented:
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
 
mlmccCommented:
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
 
Jeremy DaleySenior DeveloperAuthor Commented:
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
 
mlmccCommented:
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
 
Jeremy DaleySenior DeveloperAuthor Commented:
i'm done with this question...
everything above explains the whole situation... please refer to that.
thanks
0
 
moduloCommented:
PAQed with points refunded (250)

modulo
Community Support Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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