slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Reporting & Notification Forums - Reporting
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Reporting | New Thread

View: Search:

Author

Thread: user gets wrong data

Michael Litman
Posts: 94

user gets wrong data Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 16 Oct 06 1:25 PM

I have a user who runs a call report and is not seeing the same data as everyone else.
The user is not running a remote database they are in a citrix client. When we test the report it is correct when another user test they are getting the right data. The user has been walked through getting to the right place so it isn't user error (although I am not totally convinced of this).

Any ideas what would cause this?
Thanks for the help ML

[Reply][Quote]

Frank Chaffin
Posts: 475

Re: user gets wrong data Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 16 Oct 06 2:48 PM

Is it a matter that the user is missing calls for some accounts/contacts? If so you should check the user's security and account ownership.

If this is not the case can you provide more details?

[Reply][Quote]

Michael Litman
Posts: 94

Re: user gets wrong data Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 16 Oct 06 3:55 PM

the user is missing to meetings that he completed and are not showing on the call report.

More info: We run 6.2.3.1092. No remotes we use citrix. User is a citrix user. The users call a custom call report that gives some detail of the activitys that the users has completed between dates that the users sets when they open the report. We just upgraded from 6.1 to 6.2.3 this is when the user started to report the missing activities on the call report.

Q: when a user picks a date as a parameter at the beginning of a report does the user have to select today and if they don't change it it comes back with the first day of the month or some other random date? I ask because this is the one place I would think that the user could be causing the error and it just feels like a user error.

Thanks for the help ML

[Reply][Quote]

John Gundrum
Posts: 632

Re: user gets wrong data Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Oct 06 7:41 AM

the user is missing to meetings that he completed and are not showing on the call report.

Just to verify, are those two meetings associated with a contact and account? We ran into a similar report issue here where it turned out that it was meetings that were imported from outlook which default to no contact or account links. Since the report joined history based on contactid it would not pull the recrods that had no contact associated with them. Once associated to a contact (and account) the history records showed up in the report.

John G.

[Reply][Quote]

Michael Litman
Posts: 94

Re: user gets wrong data Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Oct 06 8:45 AM

The meetings have the correct associated contact and account.

It is just this user that is seeing the wrong results. I would ilke to have someone else run the report on his machine but he lives in another state

.

I am convinced this is pilot error unless anyone can think of a reason way a single machine would filter out just these two records. Thanks ML

[Reply][Quote]

Frank Chaffin
Posts: 475

Re: user gets wrong data Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Oct 06 9:04 AM

Didn't you say you have no remote and are using Citrix? Just log onto the Citrix server as the user and run the report.

[Reply][Quote]

Frank Chaffin
Posts: 475

Re: user gets wrong data Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Oct 06 9:07 AM

Quote:

Originally posted by Michael Litman

I am convinced this is pilot error unless anyone can think of a reason way a single machine would filter out just these two records. Thanks ML

Check the user's regional settings to make sure he has the correct date setting.

[Reply][Quote]

Michael Litman
Posts: 94

Re: user gets wrong data Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Oct 06 9:10 AM

This has been done and the correct data is displayed it is just on the users machine that the data is incorrect. we are going to try netmeeting and run the report for him on his machine. Thanks ML

[Reply][Quote]

Frank Chaffin
Posts: 475

Re: user gets wrong data Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Oct 06 9:16 AM

The report is not being run on his machine. It is being run on the Citrix server. The users sPC is just a display device.

Sounds like a Citrix user profile issue.

[Reply][Quote]

Carla Tillman
Posts: 290

Re: user gets wrong data Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Oct 06 11:18 AM

Micheal,

I didn't see if you answered Frank's question about ownership? Did you verify that the missing information (with associated seccodeid) is available to your user? Can the user view these contacts and accounts?

Sometimes it is better to review this via backend rather than through the Administrator tool. SLX Administrator tool has a couple of bugs when viewing security tress etc.

Run the following statement:

Select * from secrights where accessid = 'USERID' and seccodeid = ' MissingInfoSECcodeid '

If you get a record, user does have access. If you do not get a result set; user is not allowed to view that data.

Carla

[Reply][Quote]

Michael Litman
Posts: 94

Re: user gets wrong data Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 18 Oct 06 8:28 AM

Thanks Carla,

I get a result set, any other suggestions? Thx ML

[Reply][Quote]

Carla Tillman
Posts: 290

Re: user gets wrong data Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 19 Oct 06 12:11 PM

Micheal,

When the users pull this particular report; is it individualized by the userid?

If so; the next troubleshooting I would perform would be ro review the Tabel Joins set up in the Crystal report. Make sure there are left joins as opposed to inner joins on the main tables. That way is one piece of silly information is missing, there will still be an entry for the meetings, etc.

i.e.

History --Left join -->Activities All history (closed Activities) show regardless.

History --Left join --> Contact/Account/Userinfo All History shows even if associated information is not available.

Activities --Left join --> Contact All activities show even if a contact has been deleted. No information for the Contact, but you get the Activity information

Activities --Left join --> UserInformation - All activities show weather the userid is good or not

Hope this helps.

Carla

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 7:20:47 AM