topic Re: Report working fine on server but not on Access Point in QlikView

Report working fine on server but not on Access Point

Mon, 26 Jan 2026 18:19:17 GMT

Hi Experts,

When I opened an application on SERVER it working fine but when I tried to open it with ACCESSPOINT it gives me some null values.

Section access is applied.

I am using QV11.2 SR5

BR,

Anta

Re: Report working fine on server but not on Access Point

marcus_sommer — Tue, 25 Aug 2015 14:33:06 GMT

Is there any section access within the application?

- Marcus

Re: Report working fine on server but not on Access Point

Wed, 26 Aug 2015 06:19:20 GMT

yes, we are using section access.

Re: Report working fine on server but not on Access Point

jonathandienst — Wed, 26 Aug 2015 06:25:13 GMT

Then it is possible that data reduction is causing some expressions to return null values.

Re: Report working fine on server but not on Access Point

Wed, 26 Aug 2015 06:27:45 GMT

ok.. but same copy of document working fine on server and causing problem when we try to open it with Access Point

Re: Report working fine on server but not on Access Point

jonathandienst — Wed, 26 Aug 2015 06:33:05 GMT

You may be opening it with ADMIN access when you open it on the server - I assume that you are using QV desktop on the server?

When you open in the access point, you are opening in USER mode, regardless of your access level in the section access script.

Re: Report working fine on server but not on Access Point

Anonymous — Wed, 26 Aug 2015 06:36:59 GMT

It will happen if you use Section Access because of Data Reduction. May be you logged as Admin in server where as you logged in as User in Access Point so that you are getting these Null Values.

Re: Report working fine on server but not on Access Point

Wed, 26 Aug 2015 06:41:24 GMT

NO, in both the access I am using my own ID...

Re: Report working fine on server but not on Access Point

Wed, 26 Aug 2015 06:41:32 GMT

NO, in both the access I am using my own ID... I am access server by using RDP access

Re: Report working fine on server but not on Access Point

marcus_sommer — Wed, 26 Aug 2015 06:50:16 GMT

Are you really sure? Put a textbox with osuser() and qvuser() in the application and look if they return on server and access point the same results.

- Marcus

Re: Report working fine on server but not on Access Point

Thu, 27 Aug 2015 07:11:41 GMT

The issue has been resolved.. issue was due to one of the filter, that filter was applied on section access.

Re: Report working fine on server but not on Access Point

Anonymous — Thu, 27 Aug 2015 07:21:33 GMT

Great!!

If you got the solution please mark either helpful or correct and close the discussion.

Thank You