Print Database Name on Report

[jdaily]

Am I missing something in Crystal 10? I am trying to print the database name and location on a report but cannot figure this out.
Example: "c:/temp/database.mdb"

Any ideas?

Running Crystal Reports 10 on WinXP Pro, acccessing databases over a network.

Thanks,

John

 

[Turkbear]

Hi,
Since it is static and known when designing the report, why not just insert a text object with the info?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[jdaily]

It won't be static, that's the problem. Once a month I will have to take my report and connect to another database. The databases are generated from a program by the user and this is done monthly or as needed. The user of the crystal report will have to update the database with the new database (all fields will stay the same).

 

[Madawc]

What you need are 'date-stamps' on the database. Each record has a field giving the data when it was taken from the live data. That would make it a much better database, since you could also look back at how a particular record had changed over the months. And for ordinary purposes, you just get the detials for the current month.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[jdaily]

I won't need date stamps. I just want to put the current database name on my report. How do I do this?

 

[Madawc]

Update a static field at the same time as you move databases?

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[GJParker]

jdaily

Whether this is possible will depend on the database type, from your example above I assume the db is Access. If so then this is not possible.

If the db isn't Access then try creating a new SQL Expression and have a which functions are available under the system folder.

HTH

Gary

Gary Parker
MIS Data Analyst
Manchester, England