Hi
Backend is MariaDB
I am trying to print a basic "Invoice Receipt" document. It is an invoice-receipt document from the invoice-receipt tables (primary key InvoiceReceiptID), which has, for each one, a list of products sold, saved in InvoiceReceiptProducts, and a list of payments for each invoice-receipt, saved in InvoiceReceiptPayments.
The only way i found in Alpha to print the document with the list of products is by basing the SQL Datasource on InvoiceReceiptProducts, then grouping the report by InvoiceReceiptID. The report is filtered by whatInvoiceReceiptID to output just one document.
I also have an InvoiceReceiptPayments report (also filtered by InvoiceReceiptID) that i would like to embed in the group footer of the main report, alas, linked reports have to be layout reports ( the InvoiceReceiptPayments report is freeform and has many conditional areas ), and the sub-report option does not seem suitable ( the documentation for sub-reports is ambiguous to say the least) particularly since, contrarily to the documentation, i didn't find a way to create a one-to-many relationship between the tables.
Has any of you an idea on how to achieve the above? I am surprised it's so difficult to implement such a basic reporting feature.
Many thanks
Jaime
Backend is MariaDB
I am trying to print a basic "Invoice Receipt" document. It is an invoice-receipt document from the invoice-receipt tables (primary key InvoiceReceiptID), which has, for each one, a list of products sold, saved in InvoiceReceiptProducts, and a list of payments for each invoice-receipt, saved in InvoiceReceiptPayments.
The only way i found in Alpha to print the document with the list of products is by basing the SQL Datasource on InvoiceReceiptProducts, then grouping the report by InvoiceReceiptID. The report is filtered by whatInvoiceReceiptID to output just one document.
I also have an InvoiceReceiptPayments report (also filtered by InvoiceReceiptID) that i would like to embed in the group footer of the main report, alas, linked reports have to be layout reports ( the InvoiceReceiptPayments report is freeform and has many conditional areas ), and the sub-report option does not seem suitable ( the documentation for sub-reports is ambiguous to say the least) particularly since, contrarily to the documentation, i didn't find a way to create a one-to-many relationship between the tables.
Has any of you an idea on how to achieve the above? I am surprised it's so difficult to implement such a basic reporting feature.
Many thanks
Jaime
Comment