Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 9002
  • Last Modified:

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
0
suehwee
Asked:
suehwee
  • 5
  • 3
  • 2
  • +1
1 Solution
 
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now