Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Can't get Report to execute due to errors

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.

click to hide/show revision 2
None

Can't get Report to execute due to errors

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

image description

image description

image description

click to hide/show revision 3
None

Can't get Report to execute due to errors

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. tax.addno=address.id. I want to GROUP BY address.name 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' 'Agency'
FROM tax, address address
WHERE addno=address.id && year=2017 && amtpaid>0 amtpaid>0
ORDER BY type;

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

image description

image description

image description