I have a report in a Base file, that I would like to filter from a macro.
As many other objects in macros, I thought that the report properties could be modified…
And indeed, I don’t know why, in the structure of the report object in the macro, the before last subvariable,
Component, was not
Null, but contained a set of subsubvariables, in which a
I think this one is linked to the
Filter control that we can find in the Report builder (when
Analyse SQL command is on
But, this is my issue, I cannot get back this
filter subsubvariable, as the
Component subvariable has
Null as value…
What to do to be able to manipulate the
Component subvariable and
filter subvariable from the macro.
(the filter control in the report builder GUI works fine, but I need to handle the filter through a macro).
Thanks in advance for any help!
(LibreOffice 7 on a Debian laptop)