Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
can I view crystal from access without using crystal itself?
- Thread starter mickymoo
- Start date
I have had to do this. The coding is easy but you will need to create a distribution package for your users so that they get the appropriate dll's installed on there PC. Here is the link to the code sample at CD:
I would just say that you should look at how many users may be using it and the overhead of having to load the dll's on each PC. I did this while I was still green and wished that I had used a web app for viewing instead.
I would just say that you should look at how many users may be using it and the overhead of having to load the dll's on each PC. I did this while I was still green and wished that I had used a web app for viewing instead.
- Thread starter
- #3
- Thread starter
- #4
Excellent BDReed - the form worked brilliantly. Now if you can pardon my ignorance how doI go about create a distribution package for the dlls. I only have about 12 infrequent users. Do I just copy the files and then register them with each computer or is there a simpler way?
Cheers
Mickymoo
Cheers
Mickymoo
Mickymoo:
I did the following to create a distribution package, as this is what CD advised me to do.
First Locate the runtime.hlp file that should have installed with Crystal. Mine was located here C:\Program Files\Seagate Software\Crystal Reports\Developer Files\Help.
Read through it as it will explain when the different files are required, where to find them, and were they should go on the target PC.
I gathered all the files we would need and stored them on a network directory.
Next, I created a simple batch file that installs each file from the network directory to were it needs to go. Some of the files will need to be registered as well.
I hope this helps. I will continue to check this if you have any other difficulties.
-Brian
I did the following to create a distribution package, as this is what CD advised me to do.
First Locate the runtime.hlp file that should have installed with Crystal. Mine was located here C:\Program Files\Seagate Software\Crystal Reports\Developer Files\Help.
Read through it as it will explain when the different files are required, where to find them, and were they should go on the target PC.
I gathered all the files we would need and stored them on a network directory.
Next, I created a simple batch file that installs each file from the network directory to were it needs to go. Some of the files will need to be registered as well.
I hope this helps. I will continue to check this if you have any other difficulties.
-Brian
- Thread starter
- #6
- Thread starter
- #7
Ah HA!
Well progress has been made. I read the articles if runtime.hlp files and as far as I can see I only need craxddrt.dll and crystalviewer.dll. I manually transferred and registered these and it seems happier.
My problem is now that running a crystal report from a network location, it open on one PC but not the other. The other says "Cannot open Student at location Student".
Why not? I have set the database location to the network version in my Crystal report. It opens a blank report OK so I am presuming it cannot find the db to connect to
Any advice Oracle?
Well progress has been made. I read the articles if runtime.hlp files and as far as I can see I only need craxddrt.dll and crystalviewer.dll. I manually transferred and registered these and it seems happier.
My problem is now that running a crystal report from a network location, it open on one PC but not the other. The other says "Cannot open Student at location Student".
Why not? I have set the database location to the network version in my Crystal report. It opens a blank report OK so I am presuming it cannot find the db to connect to
Any advice Oracle?
mickymoo:
Are your reports reading data from Access or Oracle? If your reports are reading from Oracle, you may need to add the Oracle driver to your package. Also, if your users want to export, you probably want to add some of the export dll's.
Take a look through runtime.hlp for which possible data access drivers pertain to your deployment. You may also want to look at seeing if the account on the PC in questions has the appropriate permissions. I don't have much experience with Oracle.
Keep me posted.
-Brian
Are your reports reading data from Access or Oracle? If your reports are reading from Oracle, you may need to add the Oracle driver to your package. Also, if your users want to export, you probably want to add some of the export dll's.
Take a look through runtime.hlp for which possible data access drivers pertain to your deployment. You may also want to look at seeing if the account on the PC in questions has the appropriate permissions. I don't have much experience with Oracle.
Keep me posted.
-Brian
- Thread starter
- #9
I did as you said and I have included the Excel export. I am not using Oracle. I am connecting directly to an Access database.
On my colleagues computer (who of course has crystal) the DB works fine.
However on a different computer it doesn't. I guess this pretty much indicates I have a dll missing as the Crystal viewer is working perfectly when asked to view a blank report.
I don't have crystal developer so the runtime.hlp files are not present.
When I check on my computer and the one on which I am trying to get it to work on, the references in both look the same.
What else might be different that I need to check?
I know I am close but I cannot seem to get past this niggle.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question