Compare record in Visual Studio 2003.NET
-
In Visual Studio.Net2003 on Report Layout after execute my store procedure , we have data like this : Sample Data Chart Of Account (COA) Code and Description. '100000' -> Header | '100000' INCOME '110000' -> sub Header | '110000' OTHER INCOME '110001' ---> detail | '110001' Other Income Branch 15750 ----> there is Sub Total | Sub Total Other Income 15750 '120000' -> sub Header | '120000' INTEREST '120001' ---> detail | '120001' Interest from Bank 12500 '121001' ---> detail | '121001' Interest from Stock Market 07500 ----> there is Sub Total | Sub Total Interest 20000 '200000' -> Header | '200000' EXPENSE '210000' -> sub Header | '210000' Expense from Allowance 10550 '210001' ---> detail | '210001' Expense from Overtime 08450 ----> there is Sub Total | Sub Total Expense 19000 -finally there is Grand Total | Grand Total (15750+20000-19000) 16750 (INCOME - EXPENSE) in PowerBuilder if we want to compare data record we can use llike this : if name1 <> name1 (-1) then..... --> this mean we compare current recorod with previous record i tried this : =iif(Fields!COA.code.value.sbstring(0,1) <> Fields!COA.code.value.sbstring(0,1)(-1), '...', '' but it doesn't correct how do i compare between COA code 100000 with 1100000 in Visual Studio.Net 2003 with or without using Grouping Function ? (especially between first digit and the second digit) and what is the correct syntax ? email : sukasukabo@hotmail.com