How do I Open a Report Only for the CURRENT Record on the Form?

[DMG]

Hello. I am trying to learn LibreOffice Base version 7.5 (64k), using HSQLDB embedded database, on a Windows 10 desktop.
.
I have created my Report based on a Query, and I have created a Form to view each record in my Table.
.
I would like to add a Push Button to my form that will open this Report ONLY for the record that is currently displayed in my Form (by fldRecipeID).

I do know how to create a parameter in my Query to manually ask for fldRecipeID, but I was hoping for an automatic way to pass the fldRecipeID to the Report.

Does anyone know how I may do this?

THANK YOU!

[Ratslinger]

Hello,
.
Edit 2023-03-17:
This first link contains just what you asked for. In the link see the second example in the link and look at the Invoice form
End Edit
.
Here are some methods:
.

Base: Print Button

Hello, There are different methods to accomplish what you ask for. Attached is the sample you have provided. It has a filter table included (one record) to hold the invoice # to be printed. The query was modified to use this field for report selection. There is a separate form, PrintInvoice for selection of what is to be printed. It contains a list box to select the wanted invoice and a push button. The push button is attached to a short macro: Option Explicit Sub OpenReport Dim oCo…

.

Create report based on inputs of current form - LO Base

Your question as presented leaves open quite a number of questions. You statement about using a macro is one. The question here is are you knowledgeable in writing macros? If not, it is a major task in itself to learn all the necessary workings. The majority of questions are really about procedure. You say to press a button to generate a report base upon screen content. Is this before or after the data is saved & how is it known it is saved? The Base form contains a form and subform. Doe…

[Wanderer]

@DMG

but I was hoping for an automatic way to pass the fldRecipeID to the Report.

There is no easy way to call a report with a different datasource. The report you have “based on a Query” will use this query and nothing else.
.
Depending on your query I see two possibilities. 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). 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. This new Report could be called by a macro, connected to your button. The same button can store the current fldRecipeID to the temptable before opening the report.
.
Actually I never used above method, as I have usually already a filter-table. So my version of the macro would add fldRecipeID to the current filter, to reduce the result of the filter to one row. My version of your query/report would therefore include all filtered rows, which is reduced to one row with an id as filter.
You may consider to remove the fldRecipeID from the filter after the report is generated to restore the previous state. (Obviously I prefer this second possibility.)