WHERE clause not handled properly in iR 3.7.4

[rlesmoore]

The following SQL code results in error "ENROLL_STUDENT_KEY: Invalid Identifier". Moving the WHERE statements around indicates that the WHERE clause is not allowed at all. This makes iReports rather unusable for most reporting.

Any help is appreciated.

 

Les

Code:

SELECT     DTBL_STUDENT."DISTRICT_CODE" AS STU_DISTRICT_CODE,     DTBL_STUDENT."STUDENT_KEY" AS STU_STUDENT_KEY,     FTBL_ENROLLMENTS."STUDENT_KEY" AS ENROLL_STUDENT_KEYFROM     "K12INTEL_DW"."DTBL_STUDENTS" DTBL_STUDENT,     "K12INTEL_DW"."FTBL_ENROLLMENTS" FTBL_ENROLLMENTSWHERE    STU_DISTRICT_CODE='2082'    AND STU_STUDENT_KEY=ENROLL_STUDENT_KEY

[ckampshoff]

Hi,

try this:

SELECT     DTBL_STUDENT."DISTRICT_CODE" AS STU_DISTRICT_CODE,     DTBL_STUDENT."STUDENT_KEY" AS STU_STUDENT_KEY,     FTBL_ENROLLMENTS."STUDENT_KEY" AS ENROLL_STUDENT_KEYFROM     "K12INTEL_DW"."DTBL_STUDENTS" DTBL_STUDENT,     "K12INTEL_DW"."FTBL_ENROLLMENTS" FTBL_ENROLLMENTSWHERE    DTBL_STUDENT."DISTRICT_CODE"='2082'    AND DTBL_STUDENT."STUDENT_KEY" = FTBL_ENROLLMENTS."STUDENT_KEY"

HTH

Christina

[rlesmoore]

Excellent - apparently it doesn't understand an sql alias.

 

Thanks so much.

 

Les