Very strange. I am assuming that you don't have any section access to reduce data based on user name or type, or anything in that nature.
Any chance you can test with SR4? I have worked on many reports on SR1 as well, but never seen such a problem.
Anyway, good to know another QV person in Atlanta..
Thanks for your suggestions Rakesh,
I do use section access for data reduction, but I have access to everything on the report. Either way I expect it to see identical results in the designer as I do a published report with full access.
In the report I am displaying phone calls with a drill down group that starts with a month then down to a manager, then to a sales rep, then the number of calls made. In some cases the missing data is an entire manager and underlying sales people, and sometimes there are missing sales people under the a manager.
This report has been in production for quite some time with few problems. I made a change recently, but have backed out the change trying to understand and correct the problem.
I am going to upgrade my design client for the heck of it as I am seeing other odd things as well (design elements displayed on the published report that I have deleted from the report in the designer).
Are you part of the Qlikview group in Atlanta?
Were you able to figure this out? I have the same exact situation. An application using Section Access is returning different results when I use it on the desktop version than when I use it from the server via Access Point. The frustrating part is that I believe the desktop results are the correct ones. I too am using an account that has full access to the data.
Thanks (from Boston),