[NAV 2013 R2] Apply page filters to report

Bilbo007

Hi,

Am writing a report based on items. I would like the filter applied to the items list to be applied on the report automatically. So if I apply certain filters on the list and click the report button, it opens up and has exactly the same filters applied to the report request page.

Please help.
Thanks

neilgf

Hi. For the primary key for the item table, you can use code to SETTABLEVIEW in the page action after CurrPage.SETSELECTIONFILTER before running the report. For any other data you will need to create a global in the report to receive filters sent and then assign in the report. Neil

neilgf

Hi. For the primary key for the item table, you can use code to SETTABLEVIEW in the page action after CurrPage.SETSELECTIONFILTER before running the report. For any other data you will need to create a global in the report to receive filters sent and then assign in the report. Neil

Bilbo007

Thanks. Problem is I don't have access to the page code section... licencing. Is there any way to do this from the report itself?

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]