Crystal User Access

[AKPolarBear]

For some strange reason, some users cannot access one of the reports I recently created. The report runs okay, no errors are reported but no data is returned either, only zeros. I run the report, same parameters and it works just fine.
This sounds like a permission issue but I can't find where it might be. I have looked in the users permissions on the network and no problems found. Another user can run it with no issue.

We are SQL based and I suspect that is where the problem is.

 

[dgillz]

2 different users on the same workstation are getting different results, or on different workstations?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com

 

[AKPolarBear]

No PC workstations, only thinclients so the answer is different users accessing the same server get either correct results or no data returned.

Correct data is returned to an admin and one normal user.
Incorrect to another normal user.

Other users not yet tested.

 

[dgillz]

By thin client I assume you mean Citrix/Terminal Services?

If so I am a little bit out of my area of expertise but can you check the DSNs associated with the different users and confirm that they are pointed to the same database?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com

 

[AKPolarBear]

As far as I know, that is only set on the Metaframe server and applies to all users.

I checked some of the other users and they also can't run this one report. The one user I said could, still can. This is a test user account that I use.

When the users run the report, they enter an item number range. In the report, the item number and descriptions are returned without problem but the data from the IM transaction file returns a 0 instead of the data. The data is from a running total calculation.

Could this be an issue between Macola and MS-SQL permissions?

Odd that part of the report works and the other doesn't.

 

[crystalreporting]

If your reports are ODBC based, go to ODBC in the control panel and turn on ODBC trace - run the reports again for each user and view the resulting ODBC log to see what the differences are.

Peter Shirley

http://www.linkcorp.com

 

[AKPolarBear]

I ran the trace as normal user.

I found several of these errors in the log and my first error message when starting the report.

From the log:
Item Sales Fore 976-8b8 EXIT SQLSetConnectAttr with return code -1 (SQL_ERROR)
SQLHDBC 02011750
SQLINTEGER 1041 <unknown>
SQLPOINTER [Unknown attribute 1041]
SQLINTEGER -3

DIAG [S1092] [Microsoft][ODBC SQL Server Driver]Invalid attribute/option identifier (0)

The error message said:
error in formula <year>
//
the } is missing

Here is the year formula:

Year(NumberToDate({IMINVTRX_SQL.trx_dt}))

I don't see the error it referenced.

 

[AKPolarBear]

I just found this issue.

This formula:

Mid (ToText ({IMINVTRX_SQL.trx_dt}),5,2)

returns 01, 02, 03, 04 etc as expected

But the users get:
,0

In checking the data from the users login, the IMINVTRX_SQL.trx_dt, displays as XX,XXX,XXX or i.e. 20,010,721, 20,041,209. The data has commas where in what I see, it does not.

When I check the field format on my screen, I get the number format options and I don't on theirs.

I have checked settings and permissions and still can't see what is different.

 

[dgillz]

Modify your formula slightly to get rid of any numeric formatting such as thousands separators, decimals and currency sysbols:

Mid (ToText({IMINVTRX_SQL.trx_dt},0,""),5,2)

This has something to do with how crystal is set up on each machine and the "default" format of types of objects. However I never have had time to get into this I just write my formulas like the one above and move on.


Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com

 

[AKPolarBear]

That cleared up the commas, thanks.

But the report still does not run correctly for the users.

 

[NJAnalyst]

It could be that the users do not have access to the *.dlls that are used to provide those functions. The crystal directory is typically only installed for the user that was logged in when Crystal was installed on the workstation or server. Check the user specific directories on the Metaframe server. In our environment, it is the "Home" directory as specified in the user profile for Active Directory. It could also be in the C:\Documents and Settings\"User" on the server. There should be a Windows\Crystal directory under the user that contains the .dll's that provide access to those functions like numbertodate, etc.... Take the directory, which should exist under the user that currently functions correctly, and copy it to the other users profiles.

Jonathan Nelson
Business Systems Analyst
Horizon Group, USA

 

[dgillz]

Bob,

This is still the only report doing this right? Other crystal reports work fine for the same users?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com

 

[AKPolarBear]

DLL's:
I already tried that and yes, my directory did contain some different dll's but made no difference after copying them into 2 different user files. Report still did not work for them correctly.
As a matter of operation, I keep a copy of the Crystal dll's in a file and copy them into each users profile when adding new users. This keeps everybody with the same setup.

Other reports:
As far as I know, all the other reports are working normally. At least, I haven't had any complaints that they are not.

I still think it is a permission issue between the SQL access and the user but don't know what to check.

 

[NJAnalyst]

Did you assign security rights using a role in enterprise manager for Crystal access and does the user that works use the same role for access?

Jonathan Nelson
Business Systems Analyst
Horizon Group, USA

 

[crystalreporting]

System or user DSN? - make sure it's system, and check to make sure the ODBC settings (regional etc.) are the same as other workstations. This is one step, but I'm still leaning towards DLL's....

Peter Shirley

http://www.linkcorp.com

 

[AKPolarBear]

I have checked the System DSN and don't see a problem. No workstations to check-thinclients only.

Possibly related, the users have been locked up twice this morning while in Macola (not my day). It appears to be an SQL issue but I can't find any errors or hung processes that are causing the grief (except for me). The rest of the network is operating normally.
The only unresolved Macola issue I have is that earlier this week, somehow an OE got partially posted and is now stuck in the database. I have tried the easy stuff to correct it but it has not cleared up just yet. Any connection?

 

[kscheeler]

I would go back to what Jonathan said about SQL security. Is your DSN set up with SQL authentication or NT authentication.

If you are using NT authentication, you want to make sure you have group in NT and that the group has rights to the Macola databases that you want to report on. At least Public and Data Reader rights.

This is also assuming that for those people, none of the crystal reports work.


Kevin Scheeler