Skip to Content
0
Former Member
Feb 20, 2009 at 05:38 PM

What is wrong in the syntax of the following RecordSelectionFormula...???

19 Views

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!