Solved

Additional Function not showing up.

Posted on 2002-04-05
8
322 Views
Last Modified: 2012-06-22
Hi Experts
 
 I have been trying to add my own User Defined Function to Crystal 8.5 with no success.  I have compiled my VB code as a dll and placed this dll in the WINNT\Crystal directory and registered it. At this point I would expect it to be visible under 'Additonal Funtions' in Funtions in the Formula editor.  We have been able to do this in verions 7 of Crystal but ever since we upgraded we have not been able to get it to work.

Here is my VB code.  It is one I found off of Crystals web site.

Option Explicit
Public UFPrefixFunctions As Boolean

Private Sub Class_Initialize()
  UFPrefixFunctions = False
End Sub

Public Function DateToString(date1 As Date) As String
     DateToString = Format(date1, "Long Date")
End Function


Does anyone know what I am missing?

Thanks

0
Comment
Question by:Brighton
  • 4
  • 4
8 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 6922389
I assume since you have done this before you are naming the dll correctly.  It must be CRUFLxxx.DLL.

mlmcc
0
 
LVL 1

Author Comment

by:Brighton
ID: 6925369
Yes.  The program listed above is compiled and registered as CRUFLTraining.DLL in my WINNT\Crystal directory.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 6925544
What name are you looking for in the Additional Functions List.

CR renames your function.  As a guess look for

TrainingDateToString

mlmcc
0
 
LVL 1

Author Comment

by:Brighton
ID: 6925715
Yes, I was expecting to see TrainingDateToString or something with Training or even DateToString in the name.
I have looked at all the additonal functions and none of them are even close to what I was looking for.
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 100

Expert Comment

by:mlmcc
ID: 6926226
I just created an ActiveX DLL using your code and compiled it in VB.  I compiled it to my library directory (not windows\system) and CR recognized it immediately.

My first attempt didn't work (wouldn't compile) but when I started from a fresh project it did.

Suggest you create a new ActiveX dll project, add a class module, then type in your code and make the dll and see if it is rcognized.

mlmcc
0
 
LVL 1

Author Comment

by:Brighton
ID: 6926525
I redid the DLL as you suggested but still no luck.  Is there a reference that needs to be check in VB?

Thanks
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 200 total points
ID: 6929205
I didn't add any references or components.
Here is what it defaulted

The Project Properties
General Tab
project type  -  ActiveX DLL
startup object - (none)
Project name - cruflTraining
Upgrade ActiveX controls - checked
Threading model - Apartment Threaded

Make Tab
Application Title - CRUFLTraining
Remove information about unused ActiveX controls - checked

Compile Tab
Compile to Native code - selected
Optimize for fast Code - selected

Component Tab
Project compatubility - selected
cruflTraining.dll in the text box


Project References
VB for Applications
VB runtime objects and procedures
VB objects and procedures
OLE Automation


Project Components
Designers Tab
Data Environment
Data Report
DHTML Page
WebClass


mlmcc
0
 
LVL 1

Author Comment

by:Brighton
ID: 6942210
Thanks!  It appears to be case sensitive. Once I changed the project name to lowercase and recompiled it worked but that doesn't make sense.  Why just changing the project name and nothing else make it work?  Thanks Again.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now