connecting to GP 10 with Crystal reports 1

[VE]

Hi,

Currently people are using SA password to create and even just run Crystal reports. We would really like for them to be able to use their actual GP login to run their reports. We have a new report writer and we would like to keep him from accessing the payroll module tables.

Do we have to create a new user just in SQL and set permissions for each table or is there a setting somewhere that allows people to use their Great Plains login?


Thank you for your help.

VE

 

[VictoriaYudin]

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:

http://www.flex-solutions.com/gpreports.html

blog:

http://victoriayudin.com

 

[VE]

Thank you for your help. We are just going to give him access to the whole thing, since the tables are so cryptic and he will be busy figuring out other modules it seems that it would be unlikely that he would be poking around in there.

 

[slantsix]

Those tables are not as cryptic as you may think. There is a definite naming convention that anyone working with the tables should know. The prefix refers to the module GL, SOP, POP, et cetera. The rest of the numbers follow this scheme:

00000 Master Files
10000 Work Files
20000 Open Files
30000 History Files
40000 Setup Files
50000 Temp Files
60000 Relation Files
70000 Report Options
80000 Reprint Journals

Lesie