Is available a function to display database name in footer? 1

[hallux]

Is there available a function to display the database name in the footer of a report?
Thanks,
Hallux

 

[synapsevampire]

There might be, but you'll need to learn the name of your software and display it here, both the Crystal product you're using and the database type amd version.

 

[hallux]

Crystal Reports 11
SQL Server 2000

 

[synapsevampire]

Create a subreport which has the following as a Command object (data source):

SELECT name = DB_NAME()

Place it in the report footer.

This assumes that you meant the Report Footer, again, you don't take time to state specifics, which wastes yours and others time.

If you need it in the page footer, palce the subreport in the page footer, and then create a shared variable to return it to the main report.

-k

 

[synapsevampire]

You might also use a SQL Expression of:

DB_NAME()

This will return for every row though.

-k

 

[hallux]

The page footer is the section that needs the database name.

I created the command object in the subreport.

Thanks, that worked well with my setup.

-Hallux