Solved

Retrieve Crystal Report data from .rpt file

Posted on 2004-10-11
13
404 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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
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 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…

706 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

12 Experts available now in Live!

Get 1:1 Help Now