Crystal 9 - database logon prompt

Hi,

We have used crystal reports for our invoices the for last 5 years, but recently we have changed the datasource (to another server) to point the reports at. Although we have setup the ODBC manager and set the logon details in the report, the report continues to prompt for the logon from the user. Once entered by the user (which we dont want them to do) it is valid until that session ends, then prompts again.

We want the report not to prompt for the log on at all.

Please help?

Thanks,

Ally