SSDTRS 17.9.34728.123 SSDTRS 17.10.35004.147 2024-06-18T19:41:14.6170990Z 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 VOIDED_COMMENTS System.String DATE_FROM System.DateTime CHECK_PAYEE System.String DATE_TO System.DateTime SOURCE_INFO System.String GatcsDB =Parameters!BILLNO.Value =Parameters!BILLYR.Value SELECT ACCT_CODE , DESCRIP , DEBIT , CREDIT , BILL_NO , BILL_YEAR FROM GENERAL_LEDGER WHERE BILL_NO=@BILLNO AND BILL_YEAR=@BILLYR AND ISNULL(REFUND,0)=1 AND ISNULL(REVERSAL,0)=1 AND ISNULL(PAID_OUT,0)=0 AND ISNULL(COMMISSION,0)=0 AND ACCT_CODE IN (SELECT ACCT_CODE FROM DBO.CHART_ACCOUNTS WHERE DISBURSEMENT=1 AND ACCT_TYPE='L') true ACCT_CODE System.String DESCRIP System.String DEBIT System.Decimal CREDIT System.Decimal BILL_NO System.Int32 BILL_YEAR System.Int16 7.28125in 1.684in 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 =Fields!CHECK_PAYEE.Value HTML 2pt 2pt 2pt 2pt true DataSet1 1.684in 7.28125in true true =First(Fields!SOURCE_INFO.Value, "DataSet1") 2pt 2pt 2pt 2pt true true =First(Fields!MEMO.Value, "DataSet1") Black 1pt 2pt 2pt 2pt 2pt 3.59938in