Can a report parameter set the Database server name

[Former Member]

I know what my databases and tables are named, and that the connection will be an OLE DB connection to Microsoft SQL Server. However, I don't know the names of the servers on which databases will be installed. Would it be possbile to prompt for the server name and have Crystal create the connection based on that?

This is for Crystal Reports Developer XI.

[Former Member · Accepted solution]

Hi Levin,

We can select database from database expert.

While selecting database you have to find it out on which server your database exist.

I donu2019t think there is any option to prompt for the server name and have Crystal create the connection based on that.

Regards,

Shweta

[Former Member]

Levin,

If you are using BOE or Cr Server, you have the option of setting up dynamic data sources.

Jason