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!

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

display in tooltips the containings of the database

Status
Not open for further replies.

ledi

Programmer
Sep 12, 2003
3
IT
What should I write at the tooltip formula editor of a field so that the tooltip displays the corresponding database
 
Meaning that you want the name of the database?

This is dependent upon the database you're using, I don't know of a Crystal function for this.

For Oracle, create a SQL Expression such as:

SELECT UPPER(value)
FROM V$Parameter
WHERE UPPER(name) = 'DB_NAME'

Then just place the SQL Expression in the tooltips.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top