Hello,
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 filter
subsubvariable.
I think this one is linked to the Filter
control that we can find in the Report builder (when Analyse SQL command
is on Yes
).
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)