[Solved] Creating invoice-report for a single patientID

[however]

Good day everyone,

I would like to add some bells&whistles to my clinic.odb project by being able to create an invoice report for any single patientID. Obviously one patient may have more that one payment.
I already have a form that shows me the single visit and total finances for each patient.
Do i need to create a query first to group all visits/payments from the same patient and then create a report based on that query? Or would I be able to do this directly from the report design?
Lastly, would I be able to create a button to open the invoice report for that particular patient? (by linking the PatientID)

I am using OOA4.1.0 and Oracle Report Builder1.2.1

Thanks in advance for any suggestions.

[however]

Apologies! I should have been more patient with my search.

I found this

Re: Generate invoice or auto fill invoice.

Postby Villeroy » Thu Apr 24, 2014 9:25 pm
[Example] Invoice Forms (without macros)

it's a great example of what I needed and I think I can work with it in the next few days changing bits&bobs to adapt it to my project.

Thanks again