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 sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Show data source on report 1

Status
Not open for further replies.

deb13

Technical User
Nov 20, 2003
49
GB
(CR10 Developer) I have a report which can be used against three different databases by setting the data source location accordingly. In the report header I want to show which database has been pointed to. I can't see it as a special field - anyone know how to do this?

Cheers

Deb
 
Is there a table in the database that contains information specific to each data directory (i.e. a table that holds the company name)? If so, one option would be to create a subreport in the report header to go out and grab the 'name' of the database.

Peter Shirley
 
Thanks Peter - that was a good tip and works perfectly.

Deb
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top