(Obviously I prefer this second possibility. You may consider to remove the fldRecipeID from the filter after the report is generated to restore the previous state.

My version of your query/report would therefore include all filtered rows, which is reduced to one row with an id as filter. So my version of the macro would add fldRecipeID to the current filter, to reduce the result of the filter to one row. The same button can store the current fldRecipeID to the temptable before opening the report.Īctually I never used above method, as I have usually already a filter-table. This new Report could be called by a macro, connected to your button. Then you can have a copy of your report and base this on a query with an appended WHERE fldRecipeID= (SELECT fldRecipeID FROM temptable LIMIT 1) for example. You could create a small table “temptable” for your fldRecipeID and store the current ID of the form there (reverse to using one-line filter-tables, but the same principle). The report you have “based on a Query” will use this query and nothing else.ĭepending on your query I see two possibilities. There is no easy way to call a report with a different datasource. To install LibreOffice on Manjaro 22, you can use the Pacman package manager.But I was hoping for an automatic way to pass the fldRecipeID to the Report. Installing LibreOffice on Manjaro 22.īy default, LibreOffice is not available on the Manjaro 22 base repository. Before running the tutorial below, make sure that our system is up to date: sudo pacman -Syu We recommend acting as a non-root sudo user, however, as you can harm your system if you’re not careful when acting as the root.

A non-root sudo useror access to the root user.

You’ll need an internet connection to download the necessary packages and dependencies for LibreOffice. LibreOffice Base permite la creación y manejo de bases de datos, elaboración de formularios e informes que proporcionan a los usuarios finales un acceso fácil a los datos.

SSH access to the server (or just open Terminal if you’re on a desktop). LibreOffice Base es la interfaz de base de datos de la suite LibreOffice similar a Microsoft Access.

It’s recommended that you use a fresh OS install to prevent any potential issues.

A server or desktop running one of the following operating systems: Manjaro or Arch Linux.

Base libre office