If I could get some assistance please.
I have a request for a report showing all 48 fields in the table for one record(merchant ID). The request is to have the report show in a table format, so I am employing the use of OVER. I am also computing some blank lines in the fex. Additionally, with the OVER command, column headings are shown to the left of the field and not above the field. So I am trying to "compute" those column headings as seperate items. After adding the second set of column COMPUTES, I get the following error.

Unknown error occurred. Agent on reporting server EDASERVE may have crashed. Please investigate reporting server log.

If I comment out 2 of the seven COMPUTES (as you see in the code below), I have no issue. Commenting out the sixth column compute, and it crashes.

Here is the TABLE FILE part of the fex.
TABLE FILE DCC_ALL_ITEMS
PRINT
COMPUTE 1STCOLUMN1/A50='Card Number'; AS ''
COMPUTE 2NDCOLUMN1/A50='Transaction Date'; AS ''
COMPUTE 3RDCOLUMN1/A50='Assoc Auth Code'; AS ''
COMPUTE 4THCOLUMN1/A50='Transaction Amount'; AS ''
COMPUTE 5THCOLUMN1/A50='MAS Proc Date'; AS ''
COMPUTE 6THCOLUMN1/A50='Sequence Number'; AS ''
COMPUTE 7THCOLUMN1/A50='Acqu Merchant ID'; AS '' OVER
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_CARD_NUMBER' AS ''
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.NEW_TRANS_DATE' AS ''
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_ASSOC_AUTH_CODE' AS ''
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_TRANS_AMT' AS ''
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.NEW_MAS_PROC_DATE1' AS ''
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_SEQ_NUMBER' AS ''
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_ACQ_MERCH_ID' AS '' OVER
COMPUTE 1STBLANKLINE/A1=''; AS '' OVER
COMPUTE 1STCOLUMN2/A50='Chain MID'; AS ''
COMPUTE 2NDCOLUMN2/A50='MAS Bank ID'; AS ''
COMPUTE 3RDCOLUMN2/A50='File Trans Code Indicator'; AS ''
COMPUTE 4THCOLUMN2/A50='File Card Type Indicator'; AS ''
-* COMPUTE 5THCOLUMN2/A50='File Card Type Pneumonic'; AS ''
-* COMPUTE 6THCOLUMN2/A50='Extern Bank Batch Number'; AS ''
COMPUTE 7THCOLUMN2/A50='Sequence Number'; AS '' OVER
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_CHAIN_MID' AS ''
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MAS_BANK_ID' AS ''
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_FILE_TRANS_CODE_ID' AS ''
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_FILE_CARD_TYPE_ID' AS ''
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_CARD_TYPE' AS ''
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_EXT_BANK_BATCH_NUM' AS ''
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_REJECT_REASON' AS '' OVER
COMPUTE 2NDBLANKLINE/A1=''; AS '' OVER
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_INT_MAS_CH_TYPE_IND'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_CROSS_BORDER_TRANS_FLG'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_FUNDING_FLG'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_POS_ENTRY_MODE'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_TRANSACTION_TIME'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_INT_MAS_BATCH_NUM'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.NEW_DEP_DATE' OVER
COMPUTE 3RDBLANKLINE/A1=''; AS '' OVER
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_BATCH_AMT'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_EXT_BANK_BATCH_ID'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_ASSOC_ARN'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_ASSESSMENT_AMT'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_CARDHOLDER_TRANS_CURR_CODE'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_CARDHOLDER_CONV_RATE'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_TRANS_MARK_UP_PCT' OVER
COMPUTE 4THBLANKLINE/A1=''; AS '' OVER
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_CARDHOLDER_TRANS_AMT'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_INT_MAS_BANK_PROC_FLG'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_TERMINAL_ID'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_PLANNED_INT_FEE_STNG'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_ASSOC_FEE_PROG_IND'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_INTERCHANT_AMT_ASSESSED'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_TRANS_GROSS_REV' OVER
COMPUTE 5THBLANKLINE/A1=''; AS '' OVER
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_ACQ_REV_SHARE'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_PP_REV_SHARE'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_REV_SHARE'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_OHT_PTCP_REV_SHARE'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MCC'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_DBA_NAME'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_STREET_ADDR' OVER
COMPUTE 6THBLANKLINE/A1=''; AS '' OVER
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_CITY'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_STATE'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_ZIP'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_PHONE'
'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_CONTACT'
HEADING
""
FOOTING
""
WHERE RECORDLIMIT EQ 1
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$

Any help, or leads in the right direction would be much appreciated.

Thanks!

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

It would seem that HTMLCSS being ON is what caused the problem. I have turned that off and am having no problems. Other than now I have this default grid in there that I don't want. Any idea how to get rid of it? Or is this solution not the right one?

Add GRID=OFF to your StyleSheet statement.

That did it. Gotta love stylesheet quirkiness. All is well. Consider this item closed.

Thanks!