I am experiencing a strange error that is causing a crashed agent error on the Reporting Server. I have a drilldown report in HTML output format that is located in an iframe on an HTML page built in AppStudio, and within the heading I have a link to re-run the report in output format XLSX. When trying to open the report using the heading hyperlink the browser will hang and eventually a crashed agent error will appear. The funny thing is that when I change the output to AHTML, PDF OR EXL2K the report runs fine. Has anyone experienced this type of error?

Sample Code:

This is a simplified version of the problem report using the CAR file. I cannot replicate the error with the code below, but this at least demonstrates the the technique.

  
-DEFAULTH &WFFORMAT = 'HTML';

TABLE FILE CAR
BY  CAR.ORIGIN.COUNTRY
BY  CAR.COMP.CAR
BY  CAR.CARREC.MODEL
ON TABLE SUBHEAD
"Open in Excel"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT &WFFORMAT
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=TABHEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     FOCEXEC=IBFS:/WFC/Repository/ReportCarErrorTest20160516.fex( \
     WFFORMAT='XLSX' \
     ),
          TARGET='_blank',
$
ENDSTYLE
END

This message has been edited. Last edited by: barcher,

Have you check your redirection settings for XLSX ?
It may be a starting point.

I know that some issue occurs with XLSX format.

Do you have special action in your fex, such as COMPUTE or formatting that you haven't reproduced with the CAR sample ?

MartinY, Thank you for the advice. I am working with our Admin to review the redirection settings.

There is no styling on the Excel report, but there is a DEFINE field being used. The DEFINE field is assigning a value to Null values, and is leaving all other values as is.

For example:

 
DEFINE FILE FILE1
VALUE_CORRECTION/A20 = IF VALUE EQ MISSING THEN 'THIS IS NOT NULL' ELSE VALUE
END

I discovered the error, and it has nothing to do with Excel output. I discovered that a series of GOTO statements in the .fex created an infinite loop. I removed the problem GOTO statements and the report runs fine.