I have an
ExecuteReport macro to create any report using filters (I am not sure where I got this). The macro changes the query to use the filter and then opens the report.
composer = aConnection.createQueryComposer,
composer.setQuery( aConnection.Queries.getByName( aQueryName ).Command ),
composer.setFilter( aFilter )
That action renders odb as unsaved but also changes permanently the report. I find a way to revert to report using
beforefilter = composer.ComposedQuery and finally
aConnection.Queries.getByName( aQueryName ).Command = beforefilter. But this marks odb as changed, making user uncertain what to do (is something changed? was an error? etc).
Is there any way to “undo” the filter condition (only, not any other changes) in order to make odb happy?