Solved

Calling Function from within SQL Expression

Posted on 2007-11-21
4
782 Views
Last Modified: 2008-02-01
I have an oracle function that I use that takes in three values and returns one string.  I can call this function from within any sql query/view etc.
Is it possible to call an oracle function from within an SQL Expression in Crystal Reports?
0
Comment
Question by:obrienj
  • 2
  • 2
4 Comments
 
LVL 23

Expert Comment

by:Ashish Patel
ID: 20328947
Yes it should, if other sql functions can be called.
0
 

Author Comment

by:obrienj
ID: 20329040
well, I don't konw if they can or not, I seem to be having trouble doing so.  I have never called a function from an SQL Expression before.  Do you know the syntax for doing such a thing?
0
 
LVL 23

Accepted Solution

by:
Ashish Patel earned 250 total points
ID: 20329092
I searched it and No you cannot do that.
0
 

Author Comment

by:obrienj
ID: 20329741
okay, thanks.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Crystal Report fractions 4 68
Crystal Reports - Trim Data 7 40
Crystal Reports Subreport details 16 50
Crystal report highlighting 5 28
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 …
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

914 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

13 Experts available now in Live!

Get 1:1 Help Now