Improve company productivity with a Business Account.Sign Up

x
?
Solved

User Defined Function

Posted on 2006-11-01
8
Medium Priority
?
392 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
6 Comments
 
LVL 23

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 23

Expert Comment

by:Ido Millet
ID: 17852115
Should work without a problem in a UFL.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 

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 23

Accepted Solution

by:
Ido Millet earned 252 total points
ID: 17852559
0
 
LVL 101

Assisted Solution

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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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.

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. …
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 …
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…
In the video, one can understand the process of resizing images in single or bulk. Kernel Bulk Image Resizer is an easy to use tool for resizing large number of images. One can add and resize multiple images with this tool in single go. The video sh…

608 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