Is there anyone out there that can tell me how to write an SQL Expression within a report that is connected to a Fluke Met/Track Database?
I took this SQL from a subreport and pasted it into an SQL Expression
SELECT "Calibration"."MTAG", "Calibration"."C2323", "Calibration"."C2301"
FROM "mt"."Calibration" "Calibration"
WHERE "Calibration"."MTAG"='221287:1240867615' AND "Calibration"."C2323"='n' AND "Calibration"."C2301"<={d '2011-08-04'}
and received this error:
Error in compiling SQL Expression: Query Engine Error: '42000:[Sybase][ODBC Driver][Adaptive Server Anywhere]Syntax error or access violation: near 'SELECT' in ... [SELECT] "Calibration"."...'.
Any ideas?