Hello,

Bob Archer helped me with the answer to this question. First, you go to Set Datasource Location, then you open the properties on the table. Next, you highlight 'Overridden Qualified Table Name:' and hit the F2 key so you can add 'dbo.[tablename]' after the colon. Finally, you have to force a save of the report by doing a Save As. NOTE: replace tablename with the real name of the table.

Hope this saves someone some time!

TFISHER

>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