Integer DataItem Filtering

ida7

Hi,
I have a situation that I have an Integer DataItem, and when I run the report, I should have a filter on table 27:Items. The filter is needed on the DataItem, not in the Request Page of the Report. Any idea please?
Thanks in advance

RockWithNAV

If it's not in the data item then you won't get the filter over there, it can be on request page only.

RockWithNAV

If it's not in the data item then you won't get the filter over there, it can be on request page only.

ida7

Thanks RockWithNAV. On the request page it can be done with a record variable on Item table, and the code is needed on the PreDataItem, right?

RockWithNAV

Absolutely right Sir.

bbrown

With the newer NAV versions, a DataItem can be set as Temporary. Could you redesign the report to use a temporary version of the Item table? Then you would have filters available to you.