True QueryPlusDataSet QueryPlusDataSet E:\DOWNLOAD\LMA-11-18-2013 7-21-45 AM.xml QueryResults Customer_x0020_Number,System.Int32 Customer_x0020_Firm_x0020_Name,System.String Customer_x0020_DBA,System.String Customer_x0020_Address_x0020_Line_x0020_1,System.String Customer_x0020_Address_x0020_Line_x0020_2,System.String Customer_x0020_City,System.String Customer_x0020_State,System.String Customer_x0020_Zip,System.String Policy_x0020_Number,System.String Policy_x0020_Account_x0020_Rep_x0020_Employee_x0020_First_x0020_Name,System.String Invoice_x0020_Number,System.Int32 Invoice_x0020_Effective_x0020_Date,System.DateTime Invoice_x0020_Policy_x0020_Number,System.String Invoice_x0020_Transaction_x0020_Description,System.String Invoice_x0020_Transaction_x0020_Gross_x0020_Amount,System.Decimal Invoice_x0020_Total_x0020_Amount,System.Decimal Customer_x0020_Total_x0020_A_x002F_R_x0020_Balance,System.Decimal Invoice_x0020_Transaction_x0020_Billing_x0020_Transaction_x0020_ID,System.Guid Invoice_x0020_General_x0020_Ledger_x0020_Transaction_x0020_Credit_x0020_Amount,System.Decimal Invoice_x0020_General_x0020_Ledger_x0020_Transaction_x0020_Source_x0020_Journal,System.Int16 Invoice_x0020_General_x0020_Ledger_x0020_Transaction_x0020_Source_x0020_Transaction,System.Int16 Customer_x0020_Cross_x0020_Reference_x0020_Value,System.String Invoice_x0020_Activity_x0020_Balance_x0020_Owed_x0020_to_x0020_Company,System.Decimal Invoice_x0020_For_x0020_A_x002F_R_x0020_Balance_x0020_Due,System.Decimal Policy_x0020_Total_x0020_Invoice_x0020_Past-Due_x0020_Amount_x0020_-_x0020_30_x0020_days,System.Int32 Policy_x0020_Total_x0020_Invoice_x0020_Past-Due_x0020_Amount_x0020_-_x0020_31-60_x0020_days,System.Int32 Policy_x0020_Total_x0020_Invoice_x0020_Past-Due_x0020_Amount_x0020_-_x0020_61-90_x0020_days,System.Int32 Customer_x0020_Invoice_x0020_Number,System.Int32 Policy_x0020_Parent_x0020_Company_x0020_Name,System.String QueryResults QueryPlusDataSet.QueryResults Table AgencyName,System.String addr1,System.String addr2,System.String city,System.String state,System.String zipcode,System.String divdeptname,System.String email,System.String webaddr,System.String Table QueryPlusMetaDataSet.Table Invoice Invoice_Number,System.Object Customer_Number,System.Int32 Invoice_Number Customer_Number Invoice QueryResults Name Customer_Number Name Relation Customer Number EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.2,8.1,3.7 All;Black;1;Solid;False;4;Black [191:191:191] 0,3.5,1.1,0.2 Tahoma,10,Bold 0,0,0,0 Text21 Invoice Black Expression All;Black;1;Solid;False;4;Black [191:191:191] 1.1,3.5,1.3,0.2 Tahoma,10,Bold 0,0,0,0 Text27 Transaction Date Black Expression All;Black;1;Solid;False;4;Black [191:191:191] 3.8,3.5,3.3,0.2 Tahoma,10,Bold Center 0,0,0,0 Text28 Description Black Expression All;Black;1;Solid;False;4;Black [191:191:191] 7.1,3.5,1,0.2 Tahoma,10,Bold Center 0,0,0,0 Text29 Amount Black Expression All;Black;1;Solid;False;4;Black [191:191:191] 2.4,3.5,1.4,0.2 Tahoma,10,Bold 0,0,0,0 Text35 Policy Number Black Expression All;Black;1;None;False;4;Black White 0.1,1.9,3.5,0.2 Tahoma,10 0,0,0,0 Text5 {QueryResults.Customer_Firm_Name} Black All;Black;1;None;False;4;Black White 0.1,2.1,3.5,0.2 Tahoma,10 0,0,0,0 Text9 {QueryResults.Customer_Address_Line_1} Black Top, Left;Transparent;1;None;False;4;Black White 0.1,2.3,1.3,0.2 Tahoma,10 0,0,0,0 Text11 {QueryResults.Customer_City} Black All;Black;1;None;False;4;Black White 1.4,2.3,0.5,0.2 Tahoma,10 0,0,0,0 Text13 {QueryResults.Customer_State} Black All;Black;1;None;False;4;Black White 1.9,2.3,0.8,0.2 Tahoma,10 0,0,0,0 Text15 {QueryResults.Customer_Zip} Black All;Black;1;Solid;True;4;Black [216:216:216] 4.3,0.5,1.3,0.2 Tahoma,10 0,0,0,0 Text4 Statement Date Black Expression All;Black;1;Solid;False;4;Black White 5.6,0.9,2.4,0.2 Tahoma,10 0,0,0,0 Text6 {QueryResults.Policy_Account_Rep_Employee_First_Name} Black Expression All;Black;1;Solid;False;4;Black [216:216:216] 4.3,0.9,1.3,0.2 Tahoma,10 0,0,0,0 Text7 Customer Service Black Expression All;Black;1;Solid;False;4;Black [216:216:216] 4.3,0.7,1.3,0.2 Tahoma,10 0,0,0,0 Text12 Customer Number Black Expression All;Black;1;Solid;False;4;Black White 5.6,0.7,1.2,0.2 Tahoma,10 0,0,0,0 Text14 {QueryResults.Customer_Number} Black Expression All;Black;1;Solid;False;4;Black [216:216:216] 4.3,1.4,3.7,0.2 Tahoma,10,Bold Center 0,0,0,0 Text16 Payment Information Black Expression All;Black;1;Solid;True;4;Black [216:216:216] 4.3,1.6,1.4,0.2 Tahoma,10,Bold 0,0,0,0 Text17 Statement Total Black Expression All;Black;1;Solid;False;4;Black White 5.7,1.6,2.3,0.2 Tahoma,10 0,0,0,0 Text18 Black , 0 0 DataColumn All;Black;1;Solid;True;4;Black [216:216:216] 4.3,1.8,1.4,0.2 Tahoma,10,Bold 0,0,0,0 Text19 Payment Amount Black Expression All;Black;1;Solid;False;4;Black White 5.7,1.8,2.3,0.2 Tahoma,11,Bold 0,0,0,0 Text20 Black Expression All;Black;1;Solid;False;4;Black [216:216:216] 4.3,2,1.4,0.4 Tahoma,10,Bold 0,0,0,0 Text22 Invoice # Black Expression All;Black;1;Solid;False;4;Black [216:216:216] 0,2.9,8.1,0.2 Tahoma,11,Bold 0,0,0,0 Text25 ------------------------------------------------------------------------------------------------------------------------------------- Black Expression Top, Left, Right;Black;1;Solid;False;4;Black White 5.6,0.5,2.4,0.2 Tahoma,10 0,0,0,0 Text26 {Today} Black Expression All;Black;1;Solid;False;4;Black White 6.8,0.7,1.2,0.2 Tahoma,10 0,0,0,0 Text3 {QueryResults.Customer_Cross_Reference_Value} Black Expression All;Black;1;Solid;False;4;Black [216:216:216] 4.3,2.4,3.7,0.2 Tahoma,10,Bold Center 0,0,0,0 Text8 PAYMENT IS DUE UPON RECEIPT Black Expression All;Black;1;None;False;4;Black Transparent 2.8,2.7,2.3,0.2 Tahoma,8,Bold Center 0,0,0,0 Text10 Please detach and return with payment Black Expression White 0.1,0,3.5,0.8 Tahoma,11 Center 0,0,0,0 Text2 Black Expression All;Black;1;Solid;True;4;Black [216:216:216] 6.2,0,1.8,0.4 Tahoma,20,Bold Right 0,0,0,0 Text1 STATEMENT Black Expression All;Black;1;None;False;4;Black Transparent 1.1,3.1,5.4,0.4 Tahoma,10,Bold 0,0,0,0 Text24 {QueryResults.Customer_Firm_Name} Black Expression Center Transparent 0.8,1.2,1.5,0.2 Tahoma,10,Bold 0,0,0,0 Text38 {QueryResults.Customer_Total_A_R_Balance} Black , 1 0 False Transparent 0.1,1.2,0.7,0.2 Tahoma,10,Bold 0,0,0,0 Text39 Balance Black Transparent 5.7,1.6,1,0.2 Tahoma,10,Bold 6fb176ce12344bf4b2334670ff51be2f 0,0,0,0 Text41 {Sum(QueryResults.Invoice_Transaction_Gross_Amount)} Black , 0 0 Expression All;Black;1;Solid;False;4;Black Transparent 7,1.8,1,0.2 Tahoma,10,Bold 593d5f0aba5b4bec93965971c1aa6265 Right 0,0,0,0 Text23 {Sum(QueryResults.Invoice_Transaction_Gross_Amount)} Black , 0 0 Expression Transparent 5.7,2,2.3,0.4 Top, Left, Right;Black;1;Solid;False;4;Black White True 0,0,2.3,0.4 Arial,8,Bold True 0,0,0,0 Text40 {Func.EngineHelper.JoinColumnContent(Invoice, "Invoice_Number", ", ")} [186:20:25] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Transparent 0,0.2,2.3,0 Relation Invoice DataBand2 Panel1 7.1,3.7,0,0 StartPointPrimitive2 72469002d3e449e6bd387a32afebc537 3.8,3.7,0,0 StartPointPrimitive3 6f59ef1345e24e1395332dc8a272c8ca 2.4,3.7,0,0 StartPointPrimitive4 23e5483d620242dd8d4eaa299da99bb2 1.1,3.7,0,0 StartPointPrimitive5 78346901fa9647f291d1c6d1f69fb420 0,3.7,0,0 StartPointPrimitive6 435513ead9bf48faa906f4d5655bfde2 8.1,3.7,0,0 StartPointPrimitive7 31c167b82b7745998d0139a45d860ea4 HeaderBand1 Transparent True 0,4.3,8.1,0 {QueryResults.Customer_Number} False True GroupHeaderBand1 True Transparent True 0,4.7,8.1,0.4 Left, Right;Black;1;Solid;False;4;Black Transparent 0,0,1.1,0.2 Tahoma,10,Bold Center 0,0,0,0 Text30 {QueryResults.Invoice_Number} Black DataColumn Left, Right;Black;1;Solid;False;4;Black Transparent 1.1,0,1.3,0.2 Tahoma,10,Bold Center 0,0,0,0 Text31 {QueryResults.Invoice_Effective_Date} Black DataColumn Left, Right;Black;1;Solid;False;4;Black Transparent True 3.8,0,3.3,0.4 Tahoma,10,Bold 0,0,0,0 Text32 {QueryResults.Invoice_Transaction_Description} Black Expression Left, Right;Black;1;Solid;False;4;Black Transparent 7.1,0,1,0.2 Tahoma,10,Bold Right 0,0,0,0 Text33 {QueryResults.Invoice_Transaction_Gross_Amount} Black , 0 0 Expression Left, Right;Black;1;Solid;False;4;Black Transparent 2.4,0,1.4,0.2 Tahoma,10,Bold 0,0,0,0 Text36 {QueryResults.Invoice_Policy_Number} Black Expression 0,0.4,0,0 StartPointPrimitive1 c8c3edb47b89472990b9d13a8ed61e16 QueryResults DataBand1 True ASC Invoice_Number Transparent 0,5.5,8.1,1.2 All;Black;1;Solid;False;4;Black Transparent 7.1,0.4,1,0.2 Tahoma,10,Bold a6719399119f46779562eea5b5ea93b4 Right 0,0,0,0 Text34 {Sum(QueryResults.Invoice_Transaction_Gross_Amount)} Black , 0 0 Expression All;Black;1;Solid;False;4;Black [216:216:216] 7.1,0,1,0.4 Tahoma,10,Bold Center 0,0,0,0 Text37 Statement Total Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, 8.1,0.6,0,0 EndPointPrimitive1 c8c3edb47b89472990b9d13a8ed61e16 7.1,0.6,0,0 EndPointPrimitive2 72469002d3e449e6bd387a32afebc537 3.8,0.6,0,0 EndPointPrimitive3 6f59ef1345e24e1395332dc8a272c8ca 2.4,0.6,0,0 EndPointPrimitive4 23e5483d620242dd8d4eaa299da99bb2 1.1,0.6,0,0 EndPointPrimitive5 78346901fa9647f291d1c6d1f69fb420 0,0.6,0,0 EndPointPrimitive6 435513ead9bf48faa906f4d5655bfde2 8.1,0.6,0,0 EndPointPrimitive7 31c167b82b7745998d0139a45d860ea4 GroupFooterBand1 True 0,5.1,8.1,1 Black c8c3edb47b89472990b9d13a8ed61e16 RectanglePrimitive1 7.1,3.9,0.01,2.2 Black Black 72469002d3e449e6bd387a32afebc537 VerticalLinePrimitive1 Black 3.8,3.9,0.01,2.2 Black Black 6f59ef1345e24e1395332dc8a272c8ca VerticalLinePrimitive2 Black 2.4,3.9,0.01,2.2 Black Black 23e5483d620242dd8d4eaa299da99bb2 VerticalLinePrimitive3 Black 1.1,3.9,0.01,2.2 Black Black 78346901fa9647f291d1c6d1f69fb420 VerticalLinePrimitive4 Black 0,3.9,0.01,2.2 Black Black 435513ead9bf48faa906f4d5655bfde2 VerticalLinePrimitive5 Black 8.1,3.9,0.01,2.2 Black Black 31c167b82b7745998d0139a45d860ea4 VerticalLinePrimitive6 Black ef49ceff3e8a49e7ac373695f1d7d969 0.2,0.2,0.2,0.2 Page1 11 8.5 Letter Arial,100 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 11/19/2013 2:32:50 PM 10/24/2013 9:49:52 AM E:\DOWNLOAD\StimulsoftExport2.mrt cee8ea22ae6e4196a408085601b083dd Report Inches 2013.3.1701 VB