0 SQL ="data source=" & Parameters!ReportSvr.Value & "; Initial Catalog=" & Parameters!ReportDB.Value true Integrated 64cb04ce-cf16-4401-aa46-0b3e477b862b GatcsDB =Parameters!CHECK_NO.Value SELECT C.*, D.CONAME , CASE WHEN C.AMOUNT < 1.00 THEN 'Zero Dollars' ELSE DBO.FNINTEGERTOWORDS( C.AMOUNT ) END + ' AND ' + CASE WHEN CONVERT(INT,C.AMOUNT) = C.AMOUNT THEN '00' ELSE LEFT(CONVERT(VARCHAR(5), ROUND((C.AMOUNT -CONVERT(BIGINT,C.AMOUNT))*100,2) ),2) END + '/100' AS BILL_AMNT_WORDS FROM CHECK_REGISTER C LEFT JOIN DEFAULTS D ON 1=1 WHERE CHECK_NO=@CHECK_NO true CONAME System.String RECID System.Int32 BILL_AMNT_WORDS System.String CHECK_NO System.Int64 PAYEE System.String MEMO System.String AMOUNT System.Decimal CHECK_DATE System.DateTime PRINT_DATE System.DateTime REPRINT_DATE System.DateTime LOGINID System.String COMP_NAME System.String REPRINT_LOGINID System.String REPRINT_COMP_NAME System.String VOIDED System.Boolean VOIDED_DATE System.DateTime VOIDED_LOGINID System.String VOIDED_COMP_NAME System.String DATE_FROM System.DateTime VOIDED_COMMENTS System.String CHECK_PAYEE System.String DATE_TO System.DateTime GatcsDB =Parameters!CHECKPAYEE.Value =Parameters!FROMDATE.Value =Parameters!TODATE.Value SELECT * FROM ( SELECT G.ACCT_CODE, G.DESCRIP,SUM(G.CREDIT-G.DEBIT) AS D_AMT FROM DBO.GENERAL_LEDGER G WHERE G.ACCT_CODE IN (SELECT ACCT_CODE FROM DBO.CHART_ACCOUNTS WHERE CHECK_PAYEE=replace(@CHECKPAYEE,'<br>',char(13)+char(10))) AND ISNULL(G.PAID_OUT,0)=0 AND G.REFUND=0 AND G.COMMISSION=0 AND CONVERT(DATE,G.TRANS_DATE) BETWEEN CONVERT(DATE,@FROMDATE) AND CONVERT(DATE,@TODATE) AND ISNULL(G.COMMENTS,'') NOT LIKE 'VOIDED%' GROUP BY G.ACCT_CODE, G.DESCRIP UNION all SELECT G.ACCT_CODE, G.DESCRIP+'-REFUND',SUM(G.CREDIT-G.DEBIT) AS D_AMT FROM DBO.GENERAL_LEDGER G WHERE G.ACCT_CODE IN (SELECT ACCT_CODE FROM DBO.CHART_ACCOUNTS WHERE CHECK_PAYEE=replace(@CHECKPAYEE,'<br>',char(13)+char(10))) AND G.REVERSAL=1 AND G.REFUND=1 AND G.COMMISSION=0 AND CONVERT(DATE,G.TRANS_DATE) BETWEEN CONVERT(DATE,@FROMDATE) AND CONVERT(DATE,@TODATE) AND ISNULL(G.COMMENTS,'') NOT LIKE 'VOIDED%' GROUP BY G.ACCT_CODE, G.DESCRIP UNION all SELECT G.ACCT_CODE, G.DESCRIP+'-COMMISSIONS',SUM(G.CREDIT-G.DEBIT) AS D_AMT FROM DBO.GENERAL_LEDGER G WHERE G.ACCT_CODE IN (SELECT ACCT_CODE FROM DBO.CHART_ACCOUNTS WHERE CHECK_PAYEE=replace(@CHECKPAYEE,'<br>',char(13)+char(10))) AND G.COMMISSION=1 AND CONVERT(DATE,G.TRANS_DATE) BETWEEN CONVERT(DATE,@FROMDATE) AND CONVERT(DATE,@TODATE) AND ISNULL(G.COMMENTS,'') NOT LIKE 'VOIDED%' GROUP BY G.ACCT_CODE, G.DESCRIP ) X ORDER BY ACCT_CODE true ACCT_CODE System.String DESCRIP System.String D_AMT System.Decimal 7.28125in 1.555in true true =Fields!CHECK_PAYEE.Value HTML 2pt 2pt 2pt 2pt true true =Fields!BILL_AMNT_WORDS.Value 2pt 2pt 2pt 2pt true true =Fields!AMOUNT.Value 2pt 2pt 2pt 2pt en-US true true =First(Fields!CHECK_DATE.Value, "DataSet1") 2pt 2pt 2pt 2pt true DataSet1 1.555in 7.28125in 1in 4.75916in 1.50001in 0.25in true true ACCT CODE 2pt 2pt 2pt 2pt true true DESCRIP 2pt 2pt 2pt 2pt true true D AMT 2pt 2pt 2pt 2pt 0.25in true true =Fields!ACCT_CODE.Value 2pt 2pt 2pt 2pt true true =Fields!DESCRIP.Value 2pt 2pt 2pt 2pt true true =Fields!D_AMT.Value 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true =Sum(Fields!D_AMT.Value) 2pt 2pt 2pt 2pt After Before DataSet2 3.3425in 0.75in 7.25917in 1 true true =First(Fields!MEMO.Value, "DataSet1") 2pt 2pt 2pt 2pt 5.25917in 2pt 2pt 2pt 2pt 0.5in 0.5in 1in 1in