Data reduction only works on some fields

[Brip51]

Hi,

I am building a small demonstration app for Section Access and data reduction.  It works fine except except I can only reduce the data on certain fields.

My Data has the fields -

Order Number, Product, Order Date, and Ship Date.

My syntax is - 

//Access with Reduction
Section Access;
LOAD *
Inline [ACCESS, USERID,REDUCTION, OMIT
ADMIN,FVV\ADBMM,.99
ADMIN,FVV\ADLXN

];
Section Application;

Cost as Reduction;

And that works fine.  The data is reduced.  ADBMM only sees $.99 values.

I want to reduce the data by "Product" so I change my syntax to-

//Access with Reduction
Section Access;
LOAD *
Inline [ACCESS, USERID,REDUCTION, OMIT
ADMIN,FLEXI-VAN\ADBMM,lime
ADMIN,FLEXI-VAN\ADLXN,

];
Section Application;

Product as Reduction;

That does not work.  I get the complete data.  

I can also reduce on the "Order Number" so I thought it might be because the value is a string and not a number... I tried quotes but that did not work. 

I am attaching the data (can provide the app if that helps.

Thank you for any help on this.

[Vegar · Accepted solution]

Two things to think about.

All section access field names and content should be in UPPER CASE.

The section access is first applied when opening an application. If your preform a reload you will need to re-open it to see the correct reduction.

[Brip51]

Thanks Vegar,

I changed the Field name and the content to upper and that worked.

Regards,

Brian