Joined: 16 Jan 2009
Location: India
Online Status: Offline
Posts: 7
Topic: Calling User Defined Functions from Crystal report 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.
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
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.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
