Solved

Retrieve Crystal Report data from .rpt file

Posted on 2004-10-11
13
406 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:daleyjem
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 100

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 100

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
 
LVL 4

Author Comment

by:daleyjem
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 100

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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 4

Author Comment

by:daleyjem
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 100

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:daleyjem
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 100

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:daleyjem
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
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…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

929 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now