After running a Jet Report based upon an NL("Rows" function, is there any way to apply AutoFIlters to the report? Doing it manually is very tedious, especially when there are a fairly large number of report options which force the report down and to the right.
Date
Votes
1 comment
-
CascadiaDataworks No, in fact Jet and Excel Filters often clash.
The best option is to build the report to only return the data you need, applying data filters at run-time before the data is put into Excel.
You can also hide any rows or columns in Jet so you don't have to see the Report Options that push the report down and to the right.
Please sign in to leave a comment.