We help IT Professionals succeed at work.

about .rpt file

How can I open a .rpt extension file in MS Access
Comment
Watch Question

Commented:
You can't in Access.  I just may be a rich text file so open WordPad and browse for the file name from that application
What are you trying to achieve by opening the .RPT file? I am assuming this is a Crystal Reports report file. If you are trying to import the report structure then I doubt there will be a way, if you are trying to run the report then you can use the SHELL command and run Crystal Reports.
Cheers, Andrew
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Do you have a copy of Crystal Reports?  If so you can open the reports in Access through Crystal components.

mlmcc

Author

Commented:
I just want to run it. How can I do that?

Author

Commented:
How can I use Crystal components?
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
You need a copy of Crystal Reports or buy a Crystal viewer.

You can try the free viewer from Business Objects but I believe you need a copy of rystal to use it.

mlmcc
Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007
Commented:
The only way I can see this happening is if ... you have CR installed ... and then via VBA you can tap into the CR Object Model by setting a reference to it. Of course at this point, you could just open it with CR!


mx
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
OR ... maybe you can get the CR API separately from the full CR ... then tap in to the object model ?

mx
As stated earlier CR will probably have a command line option so you can use the SHELL command something like

SHELL "CR " & FileName

Cheers, Andrew
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
CR doesnt have a command line ability

mlmcc

Commented:
Have we counted out the possibility that WordPad or Word may be able to view the rpt document?   Access can export a report as a rtf  or Save As, which can then be read by WordPad or Word.  

Author

Commented:
GRayl, If I can't open a report (which has .rpt extension) in Access, how can I export/save it as rtf?

Author

Commented:
I may need Crystal Report. I already requested our help desk to install CR in my machine. But, I am just thinking, is there any way I can open a .rpt extension file in ms word/excel/access?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
I think we are beating a dead camel here.  I think we have exposed all the possibly ways you *might* do this.  Again, my best guess is you would at least need a CR API (if one exists) such that you could use some VBA code to tap into that and open the .RPT file.

mx
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
Seems you could open it in NotePad, WordPad or Word ... BUT ... probably not readable.

mx
What you need is either the full version of Crystal Reports or DataLinkViewer ($25 for single license).

The DataLink Viewer - check out http://www.milletsoftware.com/DataLink_Viewer.htm
View, Print, and Export Crystal Reports
While the creation and design changes of Crystal reports (.rpt files) require the full Crystal Reports software, you can let other PCs view, print, and export these reports by installing DataLink Viewer.

DataLink Viewer provides several useful features such as command line API (allowing you to schedule printing and trigger viewing of reports from your application, task scheduler, batch files, or desktop shortcuts), an intuitive Grid for organizing and selecting previously opened reports, reduced login frustrations via integrated authentication, choice of alternative data sources, selective parameter refresh, dynamic and cascading parameters even for versions prior to XI, auto-refresh, user-based row-level security, and more...

Cheers, Andrew

Author

Commented:
If it's not readable, does it make any sense to open it? Anyways, I learned that I must need CR to open it. Access can't help me out.
Thanks guys for your wise answers. I'll split up points.

Author

Commented:
TextReport, your idea is also great!
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
"If it's not readable, does it make any sense to open it? "

Not really.  
I thought so especially the "useful features such as command line API "
I suppose what has not been established in this question is what you are expecting to do with it once you have opened it? The choices I can think of are

1. Print it or allow it to be read by a person
2. Grab the data and import into access
3. Create an Access report based on its design

Cheers, Andrew

Author

Commented:
Well, we actually have a general user (not IT guy) who generate crystal (just double click on it) report and using Access as database back-end. He doesn't have any idea how the reports are generated or where is it come from? All on a sudden, he started getting data anomally/missing in his report. I was assigned to fix it but I don't have crystal report in my machine. I have Access and tried to open it but couldn't be able to.
I'll get Crystal Report in my machine but it takes a while.

Author

Commented:
Is it clear now
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
Good To Go :-)

mx

Author

Commented:
I took DatabaseMX and TextReport's suggestion, mlmcc also helped me out. Thanks everybody!!