Print Page | Close Window

Calling User Defined Functions from Crystal report

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5237
Printed Date: 05 May 2024 at 12:37am


Topic: Calling User Defined Functions from Crystal report
Posted By: sathisherp
Subject: Calling User Defined Functions from Crystal report
Date Posted: 16 Jan 2009 at 3:57am

How to call user defined Oracle functions from Crystal reports 9?

i know i can write a query and add it to sql expression command but already i have created my report through standerd report wizard ,i just want to add one column using my function to the report.
 
Please help if any one knows this...
 
 
 
Regards,
sathish.


-------------
Sat


Replies:
Posted By: AntDC
Date Posted: 16 Jan 2009 at 4:45am
Can you not add a Command which calls the function and link it to you reports main dataset appropriately?

DC

Posted By: hilfy
Date Posted: 20 Jan 2009 at 1:46pm

Does the function you want to call work from data that is in one of the tables in your report?  If so, you should be able to create a SQL Expression in the Field Explorer in Crystal.  I regularly use this to call a stored function to translate an employee ID to a user name without having to include the Employee table in the report.

-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window