about .rpt file

How can I open a .rpt extension file in MS Access
LVL 2
sonchoyAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Connect With a Mentor 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
0
 
GRayLCommented:
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
0
 
TextReportCommented:
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
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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

mlmcc
0
 
sonchoyAuthor Commented:
I just want to run it. How can I do that?
0
 
sonchoyAuthor Commented:
How can I use Crystal components?
0
 
mlmccConnect With a Mentor 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
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
OR ... maybe you can get the CR API separately from the full CR ... then tap in to the object model ?

mx
0
 
TextReportCommented:
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
0
 
mlmccCommented:
CR doesnt have a command line ability

mlmcc
0
 
GRayLCommented:
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.  
0
 
sonchoyAuthor Commented:
GRayl, If I can't open a report (which has .rpt extension) in Access, how can I export/save it as rtf?
0
 
sonchoyAuthor 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?
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)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
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Seems you could open it in NotePad, WordPad or Word ... BUT ... probably not readable.

mx
0
 
TextReportConnect With a Mentor Commented:
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
0
 
sonchoyAuthor 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.
0
 
sonchoyAuthor Commented:
TextReport, your idea is also great!
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"If it's not readable, does it make any sense to open it? "

Not really.  
0
 
TextReportCommented:
I thought so especially the "useful features such as command line API "
0
 
TextReportCommented:
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
0
 
sonchoyAuthor 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.
0
 
sonchoyAuthor Commented:
Is it clear now
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Good To Go :-)

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

From novice to tech pro — start learning today.