I have a user that is using RA to create some reports. I had to restore the user's reports and now they open up in the Editor instead of RA.

I did find some other posts about this and to make sure the first 2 lines have the following lines in there (which it does), so I am not sure why it will not open in RA. Is there something else in here that maybe RA does not understand?

Thanks for the help.

-* HTML Tool
-* Created by Report Assistant
-* FF Line do not change this line! Field Name
-* FF Line do not change this line! Alias
-* FF Line do not change this line! Format
-* FF Line do not change this line! Segment
-* FF Line do not change this line! UseAlias
-* FF Line do not change this line! displayTree=0
-* J001 J001
-* J002 J002
-* J004 J004
-* J005 J005
JOIN
INNER
TBLEMP.TBLEMP.EMP_PK
IN TBLEMP
TO MULTIPLE TBL_TMX_ATTEMPT.TBL_TMX_ATTEMPT.EMPFK
IN TBL_TMX_ATTEMPT TAG J001
AS J001
END
JOIN
INNER
J001.TBL_TMX_ATTEMPT.ACTIVITYFK
IN TBLEMP
TO MULTIPLE TBL_TMX_ACTIVITY.TBL_TMX_ACTIVITY.ACTIVITY_PK
IN TBL_TMX_ACTIVITY TAG J002
AS J002
END
JOIN
INNER
J002.TBL_TMX_ACTIVITY.ACTIVITYLABELFK
IN TBLEMP
TO MULTIPLE ACTLABEL.ACTLABEL.ACTLABEL_PK
IN ACTLABEL TAG J004
AS J004
END
JOIN
INNER
TBLEMP.TBLEMP.EMP_PK AND J001.TBL_TMX_ATTEMPT.ACTIVITYFK
IN TBLEMP
TO MULTIPLE CFR_TRANSCRIPT_ESIGNATURE.CFR_TRANSCRIPT_ESIGNATURE.SIGNER_FK AND CFR_TRANSCRIPT_ESIGNATURE.CFR_TRANSCRIPT_ESIGNATURE.ATTEMPT_FK
IN CFR_TRANSCRIPT_ESIGNATURE TAG J005
AS J005
END
TABLE FILE TBLEMP
SUM COMPUTE
Total_Completes/D12.2 = J001.TBL_TMX_ATTEMPT.COMPLETIONSTATUS;
BY J002.TBL_TMX_ACTIVITY.ACTIVITYNAME AS 'Course Name'
BY J001.TBL_TMX_ATTEMPT.COMPLETIONSTATUS AS 'Completion Status' NOPRINT
WHERE (J004.ACTLABEL.ACTLABEL_NAME EQ 'Curriculum')AND (J001.TBL_TMX_ATTEMPT.COMPLETIONSTATUS EQ 1);
HEADING
"Cert Completes with E-Signer and Date"
ON TABLE SET STYLE *
-INCLUDE IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENDefaultTableStyle.sty
TYPE=REPORT,
   GRID=ON,
   TITLETEXT='Cert Completes with E-Signer and Date',
 $
TYPE= HEADING,$
TYPE=DATA, COLUMN=Total_Completes,
  FONT=Tahoma,
 $
TYPE=TITLE, COLUMN=Total_Completes,
   FONT=Tahoma,
 $
ENDSTYLE
ON TABLE SET HTMLCSS OFF
ON TABLE SET AUTODRILL ALL
ON TABLE SET OLAPPANE TOP
ON TABLE ROW-TOTAL
ON TABLE COLUMN-TOTAL
END
-* End Report Assistant 

Hi,

Remove the where clause from the file using the editor,save it and then open it again with RA and tell me if it opens .

Regards

Why would it not like the WHERE clause?

Does it open in RA?

No, but removing the WHERE clause allows the report to run now.

Hi,

In RA sometimes, the user is warnned about some errors and instead of dealing with them they just ignore them. In this case one the report is save it will not open any more in RA and it will require the administrator intervention.

Regards.