Hi,
I try to complete the RecordSelectionFormula of my subreport ("{ALARM.JOB_ID} = {?Pm-?JOB_ID}) with:
" OR {ALARM.GROUP} = 10 AND {ALARM.COMES} > (select top 1 {AUFTRAG.[TIMESTAMP]} from where {AUFTRAG.JOB_ID} = {?Pm-?JOB_ID} and {AUFTRAG.STATUS} = 1 order by {AUFTRAG.TIMESTAMP} asc)"
I always get the error "A number, a currency amount, a boolean value, a date, a time, a date/current value or a character sequence are expected."
Is "top 1" the problem? I made both tables, ALARM and AUFTRAG, well known to the report by the database wizard...
Thanx!