This query works in queries but using it in a report produces all kinds of errors, one of which is below.
Using table ‘tax’: There is a relationship WHERE tax.addno=address.id
. I want to GROUP BY address.name
but that hasn’t worked out yet either.
SELECT year AS Year, payno AS 'Payment No', type AS 'Type', datedue AS 'Due Date', amtdue AS 'Amt Due', datepaid AS 'Date Paid', amtpaid AS 'Amt Paid', checkno AS 'Check No', visano AS 'Visa No', address.name AS 'Agency'
FROM tax, address
WHERE addno=address.id && year=2017 && amtpaid>0
ORDER BY type;
TYPICAL ERROR:
An exception of type com.sun.star.lang.WrappedTargetException was caught.
EDIT:
The following are images of the report written in the wizard based on subject query