Database logged in on

[mart10]

I want to show on a report which database i am logged in ON rather than the database my crsytal was designed and connected TO

I did do a formula in SQL but that just picks up the design connection of the crsystal rather than showing which of 4 potential databases i maybe looged into (which all pickup the same crystal report)

Hope this make sense i am using CR16

 

[hilfy]

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

http://www.protiviti.com

 

[mart10]

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

 

[hilfy]

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

http://www.protiviti.com