Hi Kevin
Tried it without the login and I got the Logon error...
Here's the amendended line of code...
crReportDocument.Database.Tables(0).SetDataSource(dsOrder)
There is only the one table in the report...
Thanks but please don't let me stop you working, I am sure you are busy if you are (like me) woring on a Sunday!
>hmm....I'll take a look at the original code again to see if I can find anything.
>
>Only thing that immediately springs to mind is that if you're setting the datasource for the individual tables 'manually', i'm not sure if it's necessary to apply the login-info that's being done in the loop. (since the only 'connection' to the report should be the manual datatables that you're setting)
>
>Kevin