Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Expression - system function syntax

Status
Not open for further replies.
jcl5

jcl5

IS-IT--Management
Dec 6, 2002
89
0
0
GB
Hi

Using Crystal 9 and Oracle 9

We have a number of databases holding similar data; Live, Test, Training etc and I would like to display which database the report has been run on in the report footer.

I thought I might be able to use a sql expression formula using the system function {fn DATABASE()} but don't know how to use this.

Can anyone help with the use of this or suggest a better way of doing this.

Many thanks

jcl5
 
Status
Not open for further replies.

Similar threads

elly00
  • Locked
  • Question
SQL EXPRESSION
Replies
5
Views
87
elly00
elly00
crytalbria
  • Locked
  • Question
SQL Expression Field wtih multiple FROMs
Replies
3
Views
170
hilfy
hilfy
azeemkhn
  • Locked
  • Question
is there any function in SQL SERVER
Replies
4
Views
46
kray4660
kray4660
Cryst4LN00B
  • Locked
  • Question
Convert Query SQL into Select Expert Crystal
Replies
4
Views
78
kray4660
kray4660
n2nuk
  • Locked
  • Question
SQL Expression date conversion error
Replies
2
Views
57
n2nuk
n2nuk

Part and Inventory Search

Sponsor

Back
Top