Database logged in on

I can think of a couple of possible ways to do this:

1. Have an extra table in the database that has the database name in it - it would have one column and one row. Include that table in the report (or in a subreport).

2. Depending on what type of database you're using, there may be a system function that will give you this information. If you're just linking tables together, you could then use a SQL Expression to call that function. If you're using a command, you would just add that as a column in your query.

MS SQL Server: "DB_NAME"
Oracle: "ora_database_name"
MySQL: "database()"

For other databases, google <database type> get current database name.

-Dell

Senior Manager, Data & Analytics
Protiviti

Thanks but its a vendor SQL application so I cant add tables. You would think from the splash screen login where you select which db to login you could pick that up but the vendor is not being helpful at all

If you know what the back-end database is for the application, you might still be able to use the second option that I described. Unfortunately, there is no way to do this natively in Crystal.

-Dell

Senior Manager, Data & Analytics
Protiviti