Hello,

I am using Crystal version 9.2.3.850.

I use SQL server for my database. I have identical SQL databases set up for each client. The only difference is each database is named for the client so I can keep them separate. I also have separate DSN names for each ODBC connection.

When I was using Crystal 8.5, I created several reports and I was able to use them with each of my clients even though the datasource had the name of one of my clients.

I modified one of the reports, using Crystal 9, and now, I only get data on the report when I am using that specific clients database. Before I modified the report, I could use any client's database and get data on the report from the client I was using at the time.

Anyone have any suggestions? I really don't want to have a different report for each client.

Thanks,

TFISHER