When running a scheduled report and using the option to save it off as an excel file, is there a way to keep the excel filters? I know they can be added after the fact, but it'd be nice to send it out with it already in place.
Thanks
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello -
What type of filters are you referring to? In an Excel table?
Since the table is recreated when a report is run, those types of filters cannot be retained.
However, you can filter your Jet functions to only return the data you want. *Those* filters can definitely be retained between report runs. -
Jet Reports Historic Posts I was referring to the excel column filters not the Jet data Filters. It appeared to not save the excel filters and I was hoping there was a way to save them rather than to add in post report.
Please sign in to leave a comment.