Solved

User Defined Function

Posted on 2006-11-01
8
377 Views
Last Modified: 2008-03-10
I need to make a User Defined Function in Crystal Reports. How do i go about it?

It is basically a Figures to Words converter, but the towords() function does not satisfy Indian Currency units.

I have the function already being used in various projects in VB, can that be used here?

Kalrani
0
Comment
Question by:kalrani
  • 3
  • 2
8 Comments
 
LVL 22

Expert Comment

by:Ido Millet
ID: 17851607
You can create a UFL (User Function Library) based on your VB code.  See BO's tech support site for documents on how you crate a UFL using Visual Basic.

If you post the VB code here, I can test and let you know if it works well in a UFL (basically a question of arguments & return data types).

Cheers,
- Ido
0
 

Author Comment

by:kalrani
ID: 17852093
simple function

function figurestowords(amount as double) as string

...
...
....code here

return figurestowords 'returns the amount in words suitable for indian currency'

end function
0
 
LVL 22

Expert Comment

by:Ido Millet
ID: 17852115
Should work without a problem in a UFL.
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:kalrani
ID: 17852306
Could you point to the correct Tech support page of Business Objects it is readily available with you.
0
 
LVL 22

Accepted Solution

by:
Ido Millet earned 63 total points
ID: 17852559
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 62 total points
ID: 17870911
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

777 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