quote:

Task error: THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: SQLOUT No report to distribute.

ENGINE SQLMSS SET DEFAULT_CONNECTION Fidessa
SQL SQLMSS PREPARE SQLOUT FOR
	SELECT DISTINCT T.ToBankview,B.*
	FROM 	dbo.BankviewRecords B, dbo.BO_Transactions T
	WHERE B.Fidessa_Transaction_Id = T.Trade_id and T.ToBankview='direct';
END
-RUN
SET ASNAMES = ON
TABLE FILE SQLOUT
SUM
     Quantity AS 'QUANT'
BY BO_Book_Id AS 'BOOK'
BY Instrument_Code AS 'INSTRU'
BY ISIN_code AS 'ISIN'
BY Security_name AS 'SECNAAM'
BY Buy_Sell AS 'BS'
WHERE ( Fidessa_Version EQ 1 );
ON TABLE HOLD AS H_FIDES
END
-RUN
DEFINE FILE H_FIDES
SUBGRP/A10=IF BOOK EQ '216' OR '716' THEN 'OG fondsen' ELSE 'Aandelen';
BOUGHT/D15=IF BS EQ 'B' THEN QUANT ELSE 0;
SOLD/D15=IF BS EQ 'S' THEN QUANT ELSE 0;
END
TABLE FILE H_FIDES
SUM
     BOUGHT AS 'KOOP'
     SOLD AS 'VERKOOP'
COMPUTE TOT_QTY=BOUGHT+SOLD; AS 'SALDO'
BY SUBGRP
BY INSTRU AS 'FCODE'
BY ISIN
BY SECNAAM AS 'FNAAM'
ON TABLE NOTOTAL
ON TABLE HOLD AS HOLDDATA
END
TABLE FILE HOLDDATA
SUM
     KOOP/D12S AS 'Bought'
     VERKOOP/D12S AS 'Sold'
     SALDO/D12S AS 'Total'
BY SUBGRP AS ''
BY HIGHEST SALDO NOPRINT
BY FCODE AS 'FidessaCode'
BY ISIN
BY FNAAM AS 'fundname'
HEADING
"Traderecap Fidessa <+0>&DATEtMDYY <+0> "
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
END