about .rpt file

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

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
mlmccCommented:
Do you have a copy of Crystal Reports?  If so you can open the reports in Access through Crystal components.

mlmcc
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

sonchoyAuthor Commented:
I just want to run it. How can I do that?
0
sonchoyAuthor Commented:
How can I use Crystal components?
0
mlmccCommented:
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 Access MVP)Database Architect / Systems AnalystCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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 Access MVP)Database Architect / Systems AnalystCommented:
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 Access MVP)Database Architect / Systems AnalystCommented:
Seems you could open it in NotePad, WordPad or Word ... BUT ... probably not readable.

mx
0
TextReportCommented:
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 Access MVP)Database Architect / Systems AnalystCommented:
"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 Access MVP)Database Architect / Systems AnalystCommented:
Good To Go :-)

mx
0
sonchoyAuthor Commented:
I took DatabaseMX and TextReport's suggestion, mlmcc also helped me out. Thanks everybody!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.