
(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. 5 Likes, 0 Comments - Mister.Powerpoint (mister.powerpoint) on Instagram: 'Libre office vs Powerpoint Quel est le meilleur logiciel de présentation Ces résultats sont. 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. LibreOffice and LanguageTool are similar in that both of them are open source. This new Report could be called by a macro, connected to your button. LanguageTool is now available on LibreOffice, a free office suite used by. Bidouille RespOOnsable forum Messages : 11577 Inscription : 08 nov. Libre Office 7.0.3.1 (64 bits) sous Windows 10. 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. Forum francophone de support pour Apache OpenOffice, LibreOffice et dérivés de. 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. But I was hoping for an automatic way to pass the fldRecipeID to the Report.
