Custom Report

Hi there guys,

Can anyone tell me a how can i achieve a custom report with the following columns:

Sales Invoice Number | Date Issued | Customer Issued | Net Amount | Tax Amount | Total Amount

And at the end of the lines adds the amounts for totals.

Can this report be achievable through “custom reports”? Can i add more columns with custom fields of the customers?

I’ve tried almost everything (I think) but no custom fields. Only this works for now:

SELECT reference, issuedate, customername FROM SalesInvoices


SELECT reference AS Invoice, issuedate AS Date, customername AS Customer, balancedue AS Balance_Due FROM SalesInvoices ORDER BY issuedate, reference

no luck with “subtotal” or “total”.