The problem. Goes something like this, take seat, this may take a bit of time...
On Terminal server
Login in user Andrew run report - does not work
Login in user Robin run report - works
Login in user Debbie run report - works
Compare Andrew and Debbie (Robin is select up as an administrator)
Found that Debbie belongs to group Domain Admin
Add Andrew to group Domain Admin run report it works
Remove Andrew from group Domain Admin run report it does not work
Go thought all objects that Domain Admin has access to and make sure that Domain Users has access to them and made sure same permissions.
So at this point Domain Users has access to same objects as Domain Admin and Andrew is member of Domain Users
Run reports - does not work.
Made sure c:\temp was property of domain users
Run reports - does not work.
Made Andrew member of Domain Admin - report runs
Did a test of user on local machine and terminal server, on local machine works fine on TS did not work, add them to group Domain Admin and it works.
Another interesting point. If selection was small report would run, but over half options, then it appears to be wanting to use local disk and it would appear that user does not have permission for the local disk.
Do you know what local directory Crystal is trying to use?????????????