You cannot use GP logins for this for two reasons:
1. Unless you're on GP 8.0 or earlier, when a user is created in GP, the password is encrypted, so you cannot use it in another application, like Crystal, since it will not be recognized.
2. Even if what I wrote in #1 above was not the case, a SQL user created by GP has access to ALL tables in the GP databases by default and security is handled by the GP application inside the GP application. Setting permissions in GP for this would only work in GP, not in another application like Crystal.
To accomplish what you need, you can either create another SQL user for this, or grant access to the needed SQL tables to the report writer's AD account.
Another option is to create a separate environment or database for the report writer and only copy the needed tables in there. This may or may not be preferable or possible depending on the complexity of what they are doing, just another idea to consider.
Victoria Yudin
Dynamics GP MVP 2005 - 2010
Use Crystal Reports and SSRS with GP:
blog:
