![campo de parametros en crystal reports vb net 2010 campo de parametros en crystal reports vb net 2010](https://doku.pub/img/crop/300x300/8lyz7m55e8qd.jpg)
For example:ĪND "FLOWSHEET"."IP_ID" = "HOSPITAL_VISIT"."IP_ID" If you are using a SQL Expression as a subquery and wish to link it to the detail row of your main report, do not include the table you wish to link to in the FROM clause of the subquery. SELECT MAX(HOSPITAL_VISIT.DISCHARGE_TIME) When using aggregate functions in the SQL Expression, you can include the ‘main’ query’s table’s alias: SELECT MAX(HOSPITAL_VISIT2.DISCHARGE_TIME) When using aggregate functions in the SQL Expression, do not include the ‘local’ table’s alias: WHERE HOSPITAL_VISIT2.PATIENT_ID=HOSPITAL_VISIT_alias.PATIENT_IDĪND HOSPITAL_VISIT2.ENCOUNTER_ID < HOSPITAL_VISIT_alias.ENCOUNTER_ID WHERE HOSPITAL_VISIT2.PATIENT_ID="HOSPITAL_VISIT_alias".PATIENT_IDĪND HOSPITAL_VISIT2.ENCOUNTER_ID < "HOSPITAL_VISIT_alias".ENCOUNTER_ID
![campo de parametros en crystal reports vb net 2010 campo de parametros en crystal reports vb net 2010](https://i.stack.imgur.com/y4EqJ.gif)
WHERE “HOSPITAL_VISIT2″.”PATIENT_ID”=”HOSPITAL_VISIT”.”PATIENT_ID”ĪND “HOSPITAL_VISIT2″.”ENCOUNTER_ID” < “HOSPITAL_VISIT”.”ENCOUNTER_ID”ĭouble-quotation marks are required if tables in the main query are aliased: The SQL statement needs to be enclosed in parenthesis:ĪND HOSPITAL_VISIT2.ENCOUNTER_ID < HOSPITAL_VISIT.ENCOUNTER_IDĭouble-quotation marks aren’t required if tables in the main query aren’t aliased: WHERE HOSPITAL_VISIT2.PATIENT_ID=HOSPITAL_VISIT.PATIENT_IDĪND HOSPITAL_VISIT2.ENCOUNTER_ID = HOSPITAL_VISIT.ADMISSION_TIME-7 THEN 'T' SELECT PAT_NAME,ADMISSION_TIME,DISCHARGE_TIME, The resulting SQL is added to the report’s SELECT clause. The contents of a SQL Expression field is any valid SQL statement that returns a scalar value. This document discusses the syntax requirements for SQL Expression fields.