Runtime Error 20515. Error in Formula CDate({?EDate})

this only happen when i not install the Crystal Report Program in this PC.
Then i suspect i not included some dlls file to that pc.

i am using the VB6.0, Seagate Crystal Report 8.0 -> Active X (crystl32.ocx)
anybody knows wat is the runtimes files that i need to setup my package file for installation?

urgent! thanks!


regards,
suehwee
suehweeAsked:
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.

mlmccCommented:
0
bhagyeshtCommented:
the crystal reports helps (deployment section) contains this help.
0
suehweeAuthor Commented:
that's mean when i doing the Package and Development Wizard.
i only include the belows dll file to Package Dpendency File?

Crystal ActiveX Control (OCX)
===================
CRYSTL32.OCX      
\WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)      
MFCANS32.DLL      
\WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)      
OLEPRO32.DLL      
\WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)       
CRPE32.DLL      
\WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)      
CRPAIG80.DLL      
\WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)
IMPLODE.DLL      
\WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)
MFC42.DLL      
\WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)      
MSVCIRT.DLL      
\WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)      
MSVCP60.DLL      
\WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)

Report Designer Component
==================
SSCSDK80.DLL (Charting DLL)      
\PROGRAM FILES\SEAGATE SOFTWARE\SHARED      
CRPAIG80.DLL      
\WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)      
MFC42.DLL
\WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)      
MSVCRT.DLL      
\WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)      

So, when i install to the client pc, i only register CRYSTL32.ocx using regsvr32.exe?


0
Ultimate Tool Kit for Technology Solution Provider

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 now.

bhagyeshtCommented:
u need to register all the ocx and the com dlls
0
bhagyeshtCommented:
you need to deploy the required dlls also often an ocx requires one or more dlls to be present on the system
0
suehweeAuthor Commented:
i am using Package and Development Wizard to create the package file.
then how to add those crystal report dll files to my package file?
0
bhagyeshtCommented:
you can add extra files using the add file.

better will be to make a dependency list and then use innosetup (third party software opensource freeware software) for installing the look and feel of ur installable will be much better.

u can download innosetup from
http://www.jrsoftware.org/isdl.php
0
mlmccCommented:
You need all these that you listed
Crystal ActiveX Control (OCX)
===================
CRYSTL32.OCX    
\WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)    
MFCANS32.DLL    
\WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)    
OLEPRO32.DLL    
\WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)      
CRPE32.DLL    
\WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)    
CRPAIG80.DLL    
\WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)
IMPLODE.DLL    
\WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)
MFC42.DLL    
\WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)    
MSVCIRT.DLL    
\WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)    
MSVCP60.DLL    
\WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)


I know t the end it says NT Only.  That is referring to the system32 directory.

mlmcc
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
mingzCommented:
I dont think you are missing any files..

There should be an error in your programming
1) refering to a wrong file "wrongfile.rpt"?
2) error in fomular "CDate({?EDate})"?
   example: CrystalReport1.ReplaceSelectionFormula ("table.column = CDate({" & EDate & "})")
3) no permission/not connected to the databese?? CrystalReport1.Connect = connectionstring?

mingz
:)
0
mingzCommented:
sorry the example is worng...
should be:

example: CrystalReport1.ReplaceSelectionFormula ("{table.column} = '" & CDate(EDate & "'")
0
bhagyeshtCommented:
you need to include all the dependent files irrespective of "NT only"
like mlmcc said its windows\system for non nt system or winnt\system32 or windows\system32 for NT based systems if you use an installer you need not worry whether its winnt\system32 or windows\system as the installer takes care.
0
mlmccCommented:
Should have asked earlier.  What edition of Crystal 8 do you have?  If you don't have the Developers edition you won't be able to do what you want since the appropriate files for distribution and the license to distribute is not available.  That would be why it works when you install CR but not otherwise.

mlmcc
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
Programming

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.