SymAppDatabase server=(local);database=symssr;uid=sa;password=annie02 SymAppDatabase False GrossTaxNet_Sum G1,System.Decimal G2,System.Decimal G3,System.Decimal G4,System.Decimal T1,System.Decimal T2,System.Decimal T3,System.Decimal T4,System.Decimal N1,System.Decimal N2,System.Decimal N3,System.Decimal N4,System.Decimal 30 GrossTaxNet_Sum SymAppDatabase SELECT SUM(Gross1) AS G1, SUM(Gross2) AS G2, SUM(Gross3) AS G3, SUM(Gross4) AS G4, SUM(Tax1) AS T1, SUM(Tax2) AS T2, SUM(Tax3) AS T3, SUM(Tax4) AS T4, SUM(Net1) AS N1, SUM(Net2) AS N2, SUM(Net3) AS N3, SUM(Net4) AS N4 FROM vw_shareholderdata where exercise_no = {Exercise} DataEntryBatches Citibank_No,System.Int32 Company,System.Int32 Completed_Date,System.DateTime DataEntryBatch_No,System.Int32 DE1_By,System.Int32 DE1_Complete,System.Int32 DE1_Lock_Date,System.DateTime DE1_Records,System.Int32 DE2_By,System.Int32 DE2_Complete,System.Int32 DE2_Lock_Date,System.DateTime DE2_Records,System.Int32 Deposit_Date,System.DateTime Employee_ID,System.Int32 Envelopes,System.Int32 Exercise_No,System.Int32 Exported_By,System.Int32 Exported_Date,System.DateTime Images,System.Int32 Mismatches,System.Int32 MMC_By,System.Int32 MMC_Lock_Date,System.DateTime Proxy_No,System.Int32 Receive_Batch_No,System.Int32 Shareholder_No,System.Int32 Status,System.String Status_Desc,System.String Transaction_Type,System.String Transaction_Type_Desc,System.String Updated_By,System.Int32 Updated_By_Name,System.String Updated_Date,System.DateTime Upload_By,System.Int32 Upload_Correction_By,System.Int32 Upload_Correction_Date,System.DateTime Upload_Date,System.DateTime Void_Count,System.Int32 Work_Unit_No,System.Int32 30 DataEntryBatches SymAppDatabase SELECT * FROM vw_DataEntrySummary ShareHolder Account_Qualifier,System.String Address,System.String Address2,System.String Allotment1,System.Int32 Allotment2,System.Int32 Allotment3,System.Int32 Allotment4,System.Int32 Allotment5,System.Int32 Allotment6,System.Int32 Allow_Duplicate,System.String Attend,System.Int16 Bank_Account,System.String Bank_Name,System.String Bank_Swift_Code,System.String Batch_No,System.Int32 Beneficiary_Code,System.String CDS_Account,System.String Company,System.Int32 Country_Code,System.String Created_By,System.Int32 Created_Date,System.DateTime Custom1,System.String Custom2,System.String Custom3,System.String Custom4,System.String Custom5,System.String Custom6,System.String DE_Status,System.String DE_Status_Desc,System.String DE_Unsealed,System.Boolean Delivery,System.String Email,System.String ExcessPayment_Received1,System.Decimal ExcessPayment_Received2,System.Decimal ExcessPayment_Received3,System.Decimal ExcessPayment_Received4,System.Decimal ExcessPayment_Received5,System.Decimal ExcessPayment_Received6,System.Decimal ExcessRef_No1,System.String ExcessRef_No2,System.String ExcessRef_No3,System.String ExcessRef_No4,System.String ExcessRef_No5,System.String ExcessRef_No6,System.String Exercise_No,System.Int32 Gift,System.String Gross_Total,System.Decimal Gross1,System.Decimal Gross2,System.Decimal Gross3,System.Decimal Gross4,System.Decimal Gross5,System.Decimal Gross6,System.Decimal Import_No,System.Int32 Investor_Id,System.String Investor_Type,System.String Joint_Account_indicator,System.String Meps_Routing_Code,System.String Mobile_Number,System.String Mother_Share_Holding,System.Int32 Name,System.String Nationality_Code,System.String Net_Total,System.Decimal Net1,System.Decimal Net2,System.Decimal Net3,System.Decimal Net4,System.Decimal Net5,System.Decimal Net6,System.Decimal NewIn2ndROD,System.Int32 Notes,System.String NotIn2ndROD,System.Int32 OldInvestor_Id,System.String Participant_Branch_Code,System.Int32 Participant_Code,System.Int32 Participant_Name,System.String Payment_Received1,System.Decimal Payment_Received2,System.Decimal Payment_Received3,System.Decimal Payment_Received4,System.Decimal Payment_Received5,System.Decimal Payment_Received6,System.Decimal Post_Code,System.String Prev_Allotment1,System.Int64 Prev_Allotment2,System.Int64 Prev_Allotment3,System.Int64 Prev_Allotment4,System.Int64 Prev_Allotment5,System.Int64 Prev_Allotment6,System.Int64 Prev_Net_Total,System.Decimal Prev_TakeUp_Allotment,System.Int32 Prev_TakeUp_Net_Total,System.Decimal Prev_TakeUp_Remainder,System.Decimal RaceOwnership_Code,System.String Ref_No1,System.String Ref_No2,System.String Ref_No3,System.String Ref_No4,System.String Ref_No5,System.String Ref_No6,System.String Registered_Date,System.DateTime Rejection_Codes,System.String Serial_No,System.String Serial_Number,System.String Share_Allocation,System.Int32 Share_Unit,System.Int64 ShareHolder_No,System.Int32 ShareholderExerciseData_No,System.Int32 Source_Batch,System.Int32 Source_Type,System.Byte State_Code,System.String Status_Code,System.String Stock_Code,System.String 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,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_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_Gross_Allotment,System.Decimal TakeUp_Gross_Excess,System.Decimal 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_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 TakeUp_Requested1,System.Int32 TakeUp_Requested2,System.Int32 TakeUp_Requested3,System.Int32 TakeUp_Requested4,System.Int32 TakeUp_Requested5,System.Int32 TakeUp_Requested6,System.Int32 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 Tax_Total,System.Decimal Tax1,System.Decimal Tax2,System.Decimal Tax3,System.Decimal Tax4,System.Decimal Tax5,System.Decimal Tax6,System.Decimal Telephone_Number,System.String Town,System.String Unregistered_Date,System.DateTime Update_Pending_No,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime Version_Status,System.String 30 ShareHolder SymAppDatabase SELECT * FROM vw_ShareholderData Share_Unit_Sum ShareUnitSum,System.Int32 30 Share_Unit_Sum SymAppDatabase SELECT SUM(Share_Unit) as ShareUnitSum FROM vw_Shareholderdata WHERE Exercise_No = {Exercise} Exercises Exercise_No,System.Int32 Exercise_Type,System.String Company,System.Int32 Status,System.String Created_Date,System.DateTime Created_By,System.Int32 Updated_Date,System.DateTime Updated_By,System.Int32 Submitted_Date,System.DateTime Submitted_By,System.Int32 Approved_Date,System.DateTime Approved_By,System.Int32 Client_Appr_Date,System.DateTime Client_Appr_By,System.Int32 Year_Ending_Date,System.DateTime Entitlement_Date,System.DateTime Payment_Date,System.DateTime Share_Value,System.Decimal Rounding_Rule,System.String Div_Reinvest,System.Boolean Div_Reinvest_Max,System.Decimal Div_Rate1,System.Decimal Div_Rate2,System.Decimal Div_Rate3,System.Decimal Div_Rate4,System.Decimal Div_Rate5,System.Decimal Div_Rate6,System.Decimal Tax_Rate1,System.Decimal Tax_Rate2,System.Decimal Tax_Rate3,System.Decimal Tax_Rate4,System.Decimal Tax_Rate5,System.Decimal Tax_Rate6,System.Decimal Variation_Limit,System.Decimal Perc_Calc_Type,System.Boolean Par_Value,System.Decimal Allot_Shares,System.Decimal Allot_Held,System.Decimal Allot_Perc,System.Decimal Excess_Calc1,System.String Excess_Calc2,System.String Excess_Calc3,System.String Shareholders_Total,System.Int32 Variance_Total,System.Decimal Variance_Avg_Perc,System.Decimal Stock_Code,System.String Allocation_Type1,System.String Allocation_Type2,System.String Allocation_Type3,System.String Allocation_Type4,System.String Allocation_Type5,System.String Allocation_Type6,System.String Allot_Shares1,System.Decimal Allot_Shares2,System.Decimal Allot_Shares3,System.Decimal Allot_Shares4,System.Decimal Allot_Shares5,System.Decimal Allot_Shares6,System.Decimal Allot_Held1,System.Decimal Allot_Held2,System.Decimal Allot_Held3,System.Decimal Allot_Held4,System.Decimal Allot_Held5,System.Decimal Allot_Held6,System.Decimal Share_Type1,System.String Share_Type2,System.String Share_Type3,System.String Share_Type4,System.String Share_Type5,System.String Share_Type6,System.String Share_Value1,System.Decimal Share_Value2,System.Decimal Share_Value3,System.Decimal Share_Value4,System.Decimal Share_Value5,System.Decimal Share_Value6,System.Decimal Req_Payment1,System.Boolean Req_Payment2,System.Boolean Req_Payment3,System.Boolean Req_Payment4,System.Boolean Req_Payment5,System.Boolean Req_Payment6,System.Boolean Rouding_Source1,System.String Rouding_Source2,System.String Rouding_Source3,System.String Rouding_Source4,System.String Rouding_Source5,System.String Rouding_Source6,System.String Rounding1,System.String Rounding2,System.String Rounding3,System.String Rounding4,System.String Rounding5,System.String Rounding6,System.String Sorting_A1,System.String Sorting_A2,System.String Sorting_A3,System.String Sorting_A4,System.String Sorting_A5,System.String Sorting_A6,System.String Sorting_B1,System.String Sorting_B2,System.String Sorting_B3,System.String Sorting_B4,System.String Sorting_B5,System.String Sorting_B6,System.String SortingOrder_A1,System.String SortingOrder_A2,System.String SortingOrder_A3,System.String SortingOrder_A4,System.String SortingOrder_A5,System.String SortingOrder_A6,System.String SortingOrder_B1,System.String SortingOrder_B2,System.String SortingOrder_B3,System.String SortingOrder_B4,System.String SortingOrder_B5,System.String SortingOrder_B6,System.String Calc_Rule1,System.String Calc_Rule2,System.String Calc_Rule3,System.String Calc_Rule4,System.String Calc_Rule5,System.String Calc_Rule6,System.String 30 Exercises SymAppDatabase select * from exercises ,Exercise,Exercise,Exercise,System.Int32,_x0035_,False,False,True EngineV2 Report_No,_x0032_6 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,0.8 Transparent 5.4,0.2,8.2,0.6 Arial,14,Bold 0,0,0,0 Text1 Dividend Computation Summary DodgerBlue PageHeaderBand1 Transparent 0,2,19,12.2 Transparent 0,0.2,2.4,0.6 Arial,10 0,0,0,0 Text3 Dividend # Black Transparent 2.4,0.2,5.2,0.6 Arial,10 0,0,0,0 Text2 {Exercises.Exercise_No} Black Transparent 2.4,0.8,5.2,0.6 Arial,10 0,0,0,0 Text4 {ctype(Exercises.Payment_Date,date).toshortdatestring()} Black Transparent 0,0.8,2.4,0.6 Arial,10 0,0,0,0 Text5 Payment_Date Black Transparent 11.4,0.8,2.6,0.6 Arial,10 0,0,0,0 Text6 {Exercises.Share_Value} Black Transparent 8.6,0.8,2.8,0.6 Arial,10 0,0,0,0 Text7 Share_Value Black Transparent 2.2,1.4,5.4,0.6 Arial,10 0,0,0,0 Text8 {Exercises.Entitlement_Date} Black Transparent 0,1.4,2.2,0.6 Arial,10 0,0,0,0 Text9 Entitlement_Date Black Transparent 4.8,2,2.8,0.6 Arial,10 0,0,0,0 Text12 {Exercises.Year_Ending_Date} Black Transparent 0,2,4.8,0.6 Arial,10 0,0,0,0 Text13 Year_Ending_Date Black Transparent 2.8,3,4.8,0.6 Arial,10 0,0,0,0 Text14 {(Exercises.Div_Rate1 / 100).ToString("#,##0.00")} Black Transparent 0,3,2.8,0.6 Arial,10 0,0,0,0 Text15 Div_Rate1 Black Transparent 2.8,3.6,1.6,0.6 Arial,10 0,0,0,0 Text16 {Exercises.Div_Rate2} Black Transparent 0,3.6,2.8,0.6 Arial,10 0,0,0,0 Text17 Div_Rate2 Black Transparent 2.8,4.2,1.6,0.6 Arial,10 0,0,0,0 Text18 {Exercises.Div_Rate3} Black Transparent 0,4.2,2.8,0.6 Arial,10 0,0,0,0 Text19 Div_Rate3 Black Transparent 2.8,4.8,1.6,0.6 Arial,10 0,0,0,0 Text20 {Exercises.Div_Rate4} Black Transparent 0,4.8,2.8,0.6 Arial,10 0,0,0,0 Text21 Div_Rate4 Black Transparent 11.4,3.2,1.6,0.6 Arial,10 0,0,0,0 Text10 {Exercises.Tax_Rate1} Black Transparent 8.6,3.2,2.8,0.6 Arial,10 0,0,0,0 Text11 Tax_Rate1 Black Transparent 11.4,3.8,1.6,0.6 Arial,10 0,0,0,0 Text24 {Exercises.Tax_Rate2} Black Transparent 8.6,3.8,2.8,0.6 Arial,10 0,0,0,0 Text25 Tax_Rate2 Black Transparent 11.4,4.4,1.6,0.6 Arial,10 0,0,0,0 Text26 {Exercises.Tax_Rate3} Black Transparent 8.6,4.4,2.8,0.6 Arial,10 0,0,0,0 Text27 Tax_Rate3 Black Transparent 11.4,5,1.6,0.6 Arial,10 0,0,0,0 Text28 {Exercises.Tax_Rate4} Black Transparent 8.6,5,2.8,0.6 Arial,10 0,0,0,0 Text29 Tax_Rate4 Black Transparent 11.4,1.4,2.6,0.6 Arial,10 0,0,0,0 Text22 {Share_Unit_Sum.ShareUnitSum} Black Transparent 8.6,1.4,2.8,0.6 Arial,10 0,0,0,0 Text46 ShareUnitSum Black Transparent 14.4,6,1.6,0.6 Arial,10 0,0,0,0 Text23 {GrossTaxNet_Sum.N1} Black Transparent 11.6,6,2.8,0.6 Arial,10 0,0,0,0 Text40 N1 Black Transparent 14.4,6.6,1.6,0.6 Arial,10 0,0,0,0 Text41 {GrossTaxNet_Sum.N2} Black Transparent 11.6,6.6,2.8,0.6 Arial,10 0,0,0,0 Text42 N2 Black Transparent 2.8,6,1.6,0.6 Arial,10 0,0,0,0 Text30 {GrossTaxNet_Sum.G1} Black Transparent 0,6,2.8,0.6 Arial,10 0,0,0,0 Text31 G1 Black Transparent 2.8,6.6,1.6,0.6 Arial,10 0,0,0,0 Text32 {GrossTaxNet_Sum.G2} Black Transparent 0,6.6,2.8,0.6 Arial,10 0,0,0,0 Text33 G2 Black Transparent 2.8,7.2,1.6,0.6 Arial,10 0,0,0,0 Text34 {GrossTaxNet_Sum.G3} Black Transparent 0,7.2,2.8,0.6 Arial,10 0,0,0,0 Text35 G3 Black Transparent 2.8,7.8,1.6,0.6 Arial,10 0,0,0,0 Text36 {GrossTaxNet_Sum.G4} Black Transparent 0,7.8,2.8,0.6 Arial,10 0,0,0,0 Text37 G4 Black Transparent 8.8,6,1.6,0.6 Arial,10 0,0,0,0 Text38 {GrossTaxNet_Sum.T1} Black Transparent 6,6,2.8,0.6 Arial,10 0,0,0,0 Text39 T1 Black Transparent 8.8,6.6,1.6,0.6 Arial,10 0,0,0,0 Text43 {GrossTaxNet_Sum.T2} Black Transparent 6,6.6,2.8,0.6 Arial,10 0,0,0,0 Text44 T2 Black Exercises SQLQuery Exercise_No,EqualTo,_x007B_Exercise_x007D_,,Numeric DataBand1 612840e1168e4f00a80ec3a34b9da7ab 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 C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files\root\01bfa7ff\b69f9841\App_Code.gfblreay.dll Div Summary2 09/19/2011 02:37:13 PM 09/16/2011 12:07:34 PM Report.mrt 1fa4610a1688ac11640e7ff93fa4a4fb Div Summary2 Centimeters 2011.2.1028 VB