Section Access through QVD

[ksasidhars]

Hi -

Below is the code I'm using for section access implementation. But it always fails. Could you please let me know if we can code this way, from the QVD? if yes, kindly let me know if any mistake in my code. Thanks a lot

SECTION Access;

LOAD ACCESS,

     NTNAME,

     A_CD                //This is one Field on I need to do Section Access

FROM $(vQVD)/USER_ACCESS.QVD

(qvd);

SECTION Application;

Plz let me know if you need any kind of details. Thanks - Sasi

[#2 · Accepted solution]

Hi,

I think there is some bug in QV11 to load section access table from qvd.

to do this we need to use where clause. try this...

SECTION Access;

LOAD ACCESS,

     NTNAME,

     A_CD                //This is one Field on I need to do Section Access

FROM $(vQVD)/USER_ACCESS.QVD

(qvd) where 1=1;

SECTION Application;

Niranjan M.

[#3]

Hi Sasi,

The Field that you want to be reduce should be in the:  SECTION Application;

Somthing like

SECTION Access;

LOAD ACCESS,

     NTNAME,

FROM $(vQVD)/USER_ACCESS.QVD

(qvd);

SECTION Application;

LOAD

     NTNAME,

     A_CD                //This is one Field on I need to do Section Access

FROM $(vQVD)/USER_ACCESS.QVD

(qvd);

And also tou need to check :

Check the selected option  “Settings” -> “Document Properties” -> “Opening” ->Initial Data ReductionBased on Section Access:

Hope it helps,

Regards

Yigal

[ksasidhars]

Niranjan/Yigal,

Thanks all for your help guys.

I do agree with Yigal and Niranjan's trick is awesome though. Thank you once again

-Sasi

PS - Thanks a lot Yigal for your cool explanation with example/pictures.