greb's profile - activity

@JohnSUN, Thanks for the indications. I've indeed succeeded using Linux cp command from macro. It doesn't bring any inf

@JohnSUN, Thanks for your comment. I never used Shell(), but sounds interesting. With it, is it possible to launch a

Base - Export data of a stored query in a csv file within a macro Hello, I would like to export data of a stored query

Base - Export data of a stored query in a csv file within a macro Hello, I would like to export data of a stored query

Base - Export data of a stored query in a csv file within a macro Hello, I would like to export data of a stored query

@Ratslinger, Thanks again for feedback. Indeed, the ODB file registration checking was problematic and due to error. I

@Ratslinger, Have solved the LIST field issue, using a CAST function, see my question post. As well, have sorted out t

Base - Export data of a stored query in a csv file within a macro Hello, I would like to export data of a stored query

Hello @Ratslinger, Once again, thanks a lot for taking time to answer to my question. You're right, "brief" is not a v

Base - use of SDBC Firebird File Hello, I'm not really in a problem solving, but while testing LO Base possibilities, w

@Ratslinger, Ok, noted for auto registration. Alternative may so just be to add a small text to explain how to register

@Ratslinger, Another point, but which I think is very specific to my query: two columns of my query result in N/A value

@Ratslinger, Thank you very much for all this review and solution work! Both solution are working very well. On my si

@Ratslinger, Thank you very much for your time and this much documented solution! I'll have a deeper look and test it

Base - Export data of a stored query in a csv file within a macro Hello, I would like to export data of a stored query

Base - Export data of a stored query in a csv file within a macro Hello, I would like to export data of a stored query

@Ratslinger, It's ok, no problem. Anyway, thanks for the updated information. Eventually, I will opt for the "easy" gr

@Ratslinger, Thanks for offering. Indeed, I would have preferred a "direct" way, but still, this can be useful. I will

@gkick and @Ratslinger, Sorry for the delay of my answer, and thanks for your suggestion @gkick and for the Firebird pr

Base - Export data of a stored query in a csv file within a macro Hello, I would like to export data of a stored query

@Ratslinger, Thank you for the tips. Indeed, I restore the 'Where' clause when done. The parameter passing from one m

@Ratslinger, Thanks for all you feedbacks. - I moved to a 'Where' clause option better than a de/activation and filte

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)

As well, my filter is coming from another macro. I declare it just outside before this other macro like this: Global m

I just needed (but it is the right way?) to activate the ApplyFilter subvariable of stQuery: ' Get access to Queries oD