SymAppDatabase server=(local);database=symssr;uid=sa;password=annie02 SymAppDatabase False ShareHolder ShareHolder_No,System.Int32 Name,System.String Investor_Id,System.String Share_Unit,System.Int32 Address,System.String Created_Date,System.DateTime Created_By,System.Int32 Updated_Date,System.DateTime Updated_By,System.Int32 Gift,System.String Attend,System.Int32 Share_Allocation,System.Int32 OldInvestor_Id,System.String Address2,System.String Town,System.String Post_Code,System.String State_Code,System.String Country_Code,System.String CDS_Account,System.String Registered_Date,System.DateTime Unregistered_Date,System.DateTime Company,System.Int32 Source_Batch,System.Int32 NotIn2ndROD,System.Int32 NewIn2ndROD,System.Int32 Exercise_No,System.Int32 Import_No,System.Int32 Source_Type,System.Int32 Participant_Code,System.Int32 Participant_Branch_Code,System.Int32 Participant_Name,System.String Nationality_Code,System.String RaceOwnership_Code,System.String Investor_Type,System.String Telephone_Number,System.String Stock_Code,System.String Serial_Number,System.String Status_Code,System.String Beneficiary_Code,System.String Account_Qualifier,System.String Allow_Duplicate,System.String Rejection_Codes,System.String Mobile_Number,System.String Bank_Account,System.String Joint_Account_indicator,System.String Meps_Routing_Code,System.String Bank_Swift_Code,System.String Bank_Name,System.String Email,System.String Version_Status,System.String Update_Pending_No,System.Int32 ShareholderExerciseData_No,System.Int32 Batch_No,System.Int32 Allotment1,System.Int32 Allotment2,System.Int32 Allotment3,System.Int32 Allotment4,System.Int32 Allotment5,System.Int32 Allotment6,System.Int32 Prev_Allotment1,System.Int32 Prev_Allotment2,System.Int32 Prev_Allotment3,System.Int32 Prev_Allotment4,System.Int32 Prev_Allotment5,System.Int32 Prev_Allotment6,System.Int32 TakeUp_Allotment1,System.Int32 TakeUp_Allotment2,System.Int32 TakeUp_Allotment3,System.Int32 TakeUp_Allotment4,System.Int32 TakeUp_Allotment5,System.Int32 TakeUp_Allotment6,System.Int32 TakeUp_Excess_Req1,System.Int32 TakeUp_Excess_Req2,System.Int32 TakeUp_Excess_Req3,System.Int32 TakeUp_Excess_Req4,System.Int32 TakeUp_Excess_Req5,System.Int32 TakeUp_Excess_Req6,System.Int32 TakeUp_Excess_Alloc1,System.Int32 TakeUp_Excess_Alloc2,System.Int32 TakeUp_Excess_Alloc3,System.Int32 TakeUp_Excess_Alloc4,System.Int32 TakeUp_Excess_Alloc5,System.Int32 TakeUp_Excess_Alloc6,System.Int32 TakeUp_Gross_Total1,System.Decimal TakeUp_Gross_Total2,System.Decimal TakeUp_Gross_Total3,System.Decimal TakeUp_Gross_Total4,System.Decimal TakeUp_Gross_Total5,System.Decimal TakeUp_Gross_Total6,System.Decimal TakeUp_Tax_Total1,System.Decimal TakeUp_Tax_Total2,System.Decimal TakeUp_Tax_Total3,System.Decimal TakeUp_Tax_Total4,System.Decimal TakeUp_Tax_Total5,System.Decimal TakeUp_Tax_Total6,System.Decimal TakeUp_Net_Total1,System.Decimal TakeUp_Net_Total2,System.Decimal TakeUp_Net_Total3,System.Decimal TakeUp_Net_Total4,System.Decimal TakeUp_Net_Total5,System.Decimal TakeUp_Net_Total6,System.Decimal TakeUp_Remainder1,System.Decimal TakeUp_Remainder2,System.Decimal TakeUp_Remainder3,System.Decimal TakeUp_Remainder4,System.Decimal TakeUp_Remainder5,System.Decimal TakeUp_Remainder6,System.Decimal Payment_Received1,System.Decimal Payment_Received2,System.Decimal Payment_Received3,System.Decimal Payment_Received4,System.Decimal Payment_Received5,System.Decimal Payment_Received6,System.Decimal ExcessPayment_Received1,System.Decimal ExcessPayment_Received2,System.Decimal ExcessPayment_Received3,System.Decimal ExcessPayment_Received4,System.Decimal ExcessPayment_Received5,System.Decimal ExcessPayment_Received6,System.Decimal TakeUp_Requested1,System.Int32 TakeUp_Requested2,System.Int32 TakeUp_Requested3,System.Int32 TakeUp_Requested4,System.Int32 TakeUp_Requested5,System.Int32 TakeUp_Requested6,System.Int32 Gross1,System.Decimal Gross2,System.Decimal Gross3,System.Decimal Gross4,System.Decimal Gross5,System.Decimal Gross6,System.Decimal Gross_Total,System.Decimal Net1,System.Decimal Net2,System.Decimal Net3,System.Decimal Net4,System.Decimal Net5,System.Decimal Net6,System.Decimal Net_Total,System.Decimal Tax1,System.Decimal Tax2,System.Decimal Tax3,System.Decimal Tax4,System.Decimal Tax5,System.Decimal Tax6,System.Decimal Tax_Total,System.Decimal Delivery,System.String Serial_No,System.String DE_Unsealed,System.Boolean DE_Status,System.String Notes,System.String Prev_TakeUp_Allotment,System.Int32 Prev_TakeUp_Net_Total,System.Decimal Prev_TakeUp_Remainder,System.Decimal Prev_Net_Total,System.Decimal Mother_Share_Holding,System.Int32 TakeUp_Excess,System.Int32 TakeUp_Gross_Allotment,System.Decimal TakeUp_Gross_Excess,System.Decimal Ref_No1,System.String Ref_No2,System.String Ref_No3,System.String Ref_No4,System.String Ref_No5,System.String Ref_No6,System.String ExcessRef_No1,System.String ExcessRef_No2,System.String ExcessRef_No3,System.String ExcessRef_No4,System.String ExcessRef_No5,System.String ExcessRef_No6,System.String Custom1,System.String Custom2,System.String Custom3,System.String Custom4,System.String Custom5,System.String Custom6,System.String DE_Status_Desc,System.String 30 ShareHolder SymAppDatabase SELECT * from vw_shareholderdata EngineV2 Report_No,_x0031_9 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,0.8 Transparent 3.2,0.2,1.6,0.6 Arial,10 0,0,0,0 Text1 {ShareHolder.CDS_Account} Black Transparent 0.4,0.2,2.8,0.6 Arial,10 0,0,0,0 Text2 CDS_Account Black ShareHolder SQLQuery _x007B_ShareHolder_x002E_Exercise_No_x0020__x003D__x0020_5_x007D_ DataBand1 408955e846e64b84a62e69de2d25ff86 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 14/09/2011 11:55:59 AM 09/19/2011 03:21:10 PM 09/14/2011 11:52:17 AM ShareholdExpresion.mrt 048e10ed82baef2442a980217b283faf Report 14/09/2011 11:55:59 AM Centimeters 2011.2.1028 VB