We had to do something similar with ARS 4.5 and
Crystal 8. But when we switched to ARS 5.1x
and Crystal 9, we now load an Active-X control to run the custom reports
from either the 5.1.2 Mid-Tier or any 5.x or 6.x user tool. Once all the
clients set the Tools/Option flag to "ODBC Use Underscores", it has worked
great. (No error, just most of the fields are blank if it's not
set).
Sorry, I didn't set-up the Crystal Reports so I can't tell
you how. I'll have to research this myself in two weeks as I finish our
migration to ARS 6.3.
Take Care,
Harry
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ron Tavares
Sent: Wednesday, August 23, 2006 9:39 AM
To: arslist@ARSLIST.ORG
Subject: Re: Custom Crystal reports only work with Crystal installed
I had a similar issue a couple of years back. At the time I was on
version 5 Crystal 8, so I don't know if this will work for you but it resovled
the issue for us. I compared the files that existed in the Crystal Install
Path, between the machine with the Crystal isntalled and one with only the
User Tool. I found that the Crystal install had some additional .dll files
that did not exist on the machine with just the User Tool. We simply
copied these files over and the reports ran fine.
Hope this helps.
.ron
On 8/23/06, Tracey
Meikle <[EMAIL PROTECTED]>
wrote:
I've input a couple custom Crystal Reports into Remedy's Report Console
and they are running fine... However, they can be run only from a machine
where Crystal is installed. Those without Crystal can run the out-of-the-
box Crystal reports, but when they run any custom report they get a
warning:
"Error in file c:\DOCUME~1\tmeikl\LOCAL~1\Temp\WeeklyCRStatusCCS.rpt.
Failed to load database information."
When okay is clicked, they get an error:
"Error occurred in generating report (ARERR 1658)"
Does anyone have a suggestion to correct this issue? So far I've done the
following:
- tried very basic reports off of standard tables (same issue)
- turned on and off the "use underscores" option
- made sure the crpe32.dll is the same as on a machine that can run them
- made sure the crdb_odbc.dll is the same
Crystal version: 9.2.0.488
Remedy: 6.00.00
Thanks everyone,
Tracey
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___