Connection Driver={SQL Server};Server=localhost\MAINSTREET;Database=PEI;uid=sa;pwd=mainstreet Connection Invoice RefId,System.String TxnID,System.String TxnNumber,System.String RefNumber,System.String DateCreated,System.DateTime DateModified,System.DateTime DueDate,System.DateTime FK_Customer_ID,System.String CustomerName,System.String BA_Line1,System.String BA_Line2,System.String BA_Line3,System.String BA_Line4,System.String BA_Line5,System.String BA_City,System.String BA_State,System.String BA_ZIP,System.String BA_Country,System.String BA_Note,System.String SA_Line1,System.String SA_Line2,System.String SA_Line3,System.String SA_Line4,System.String SA_Line5,System.String SA_City,System.String SA_State,System.String SA_ZIP,System.String SA_Country,System.String SA_Note,System.String Subtotal,System.Decimal SalesTaxTotal,System.Decimal SalesTaxPercentage,System.Decimal AppliedAmount,System.Decimal BalanceRemaining,System.Decimal IsPaid,System.String IsToBePrinted,System.String Message,System.String PONUmber,System.String OrderedBy,System.String ShipVia,System.String InvNumber,System.Int32 TermsRefId,System.String TermsRefName,System.String 30 Invoice Connection select * from Invoice inner join Customer on Invoice.FK_Customer_ID = Customer.PK_Customer_ID where RefID in {RefID} InvoiceLine RefId,System.Int64 Seq,System.Int64 TxnID,System.String FK_ITEM_ID,System.String Item,System.String Description,System.String Quantity,System.Double Rate,System.Decimal Amount,System.Decimal DateCreate,System.DateTime Other1,System.String Other2,System.String Discount,System.String Payment,System.String SubTotal,System.String 30 InvoiceLine Connection p1,Invoice.RefId,13,50 True select * from InvoiceLine where RefID = ? Customer PK_Customer_ID,System.String sName,System.String sEmail,System.String sFax,System.String sPhone,System.String dFirstDtActive,System.DateTime dLastDtActive,System.DateTime sShipAddress,System.String sBillAddress,System.String sPayCode,System.String sContact,System.String bActive,System.String sCompany,System.String sAccountNumber,System.String fBalance,System.Double fCreditLimit,System.Double sAddress1,System.String sAddress2,System.String sAddress3,System.String sAddress4,System.String sAddress5,System.String sCity,System.String sState,System.String sZIP,System.String sCountry,System.String sLicense,System.String ParentID,System.String ParentName,System.String sRepName,System.String sTypeName,System.String 30 Customer Connection p1,Invoice.FK_Customer_ID,13,50 True select * from Customer where PK_Customer_ID = ? ,RefID,RefID,System.String,_x0028_614_x0029_,False,False ,amount,amount,System.Decimal,_x0030_.00,False,False ,DisplayCustomerName,Display_x0020_Customer_x0020_Name_x003F_,,System.Boolean,true,False,False,True EngineV2 None;[60:60:60];2;Solid;False;4;Black Transparent Transparent 0,0.2,7.5,0.25 Transparent 0,0,0.94,0.25 Frutiger LT 75 Black,10 07847ef41c95498f98f5e992486fd2b5 8,0,0,0 Text10 Quantity [0:64:0] Wysiwyg Expression Center Transparent 0.94,0,1.81,0.25 Frutiger LT 75 Black,10 b97ba93dde984bd19a3e9d1c3adffc41 8,0,0,0 Text11 Item [0:64:0] Wysiwyg Expression Center Transparent 6.42,0,1.07,0.25 Frutiger LT 75 Black,10 82cb4dff127d43f2837f233a856e82c7 8,0,0,0 Text12 Amount [0:64:0] Wysiwyg Expression Center Transparent 2.75,0,2.63,0.25 Frutiger LT 75 Black,10 8b594e69de2443729ce71e698f28e632 8,0,0,0 Text13 Description [0:64:0] Wysiwyg Expression Center Transparent 5.37,0,1.06,0.25 Frutiger LT 75 Black,10 0b33e2f9d08048ee89d5a24aab6778f6 8,0,0,0 Text14 Unit Price [0:64:0] Wysiwyg Expression Center 0,-0.01,0,0 StartPointPrimitive1 af20d3247ffb4252b5051dc49566ca67 7.5,-0.01,0,0 StartPointPrimitive2 cbf21bd3360345fbaf01c803d8a43425 6.43,-0.01,0,0 StartPointPrimitive3 8643d03de3c74bf6a9b230c2e54b2356 5.38,-0.01,0,0 StartPointPrimitive4 2f4f41eb11b141e69a320c69f7aecd46 2.75,-0.01,0,0 StartPointPrimitive5 7a55e519fac24039bc46e97ea11fb41c 0.94,-0.01,0,0 StartPointPrimitive6 3c87a622cee54c09bd1613b4f0c3ff9e HeaderBand1 True Transparent 0,0.85,7.5,0.1 Transparent True 0,0,0.94,0.1 Frutiger LT 55 Roman,9 28755cc23295471492cff7aa76360a65 Center 0,0,-2,0 Text15 {InvoiceLine.Quantity.ToString()} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Expression Transparent True 0.94,0,1.81,0.1 Frutiger LT 55 Roman,9 037d6372aeef4ea0b1d1cde98f905fac 5,0,-2,0 Text16 {InvoiceLine.Item} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Expression Transparent True 6.42,0,1.06,0.1 Frutiger LT 55 Roman,9 35bc8c8b9fc34dd6a005fe5a9b3fac7e Right 0,5,-2,0 Text17 {InvoiceLine.Amount.ToString()} Black , 1 False HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Expression Transparent True 2.75,0,2.63,0.1 Frutiger LT 55 Roman,9 886d651cd4234a60bcd76f8861d596ce 5,0,-2,0 Text18 {InvoiceLine.Description} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Expression Transparent True 5.37,0,1.06,0.1 Frutiger LT 55 Roman,9 01dfcd35292349b3bea43138044786de Right 0,5,-2,0 Text19 {InvoiceLine.Rate.ToString()} Black , 0 0 False HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Expression InvoiceLine DataBand2 Top;Black;1;Solid;False;4;Black Transparent 0,1.35,7.5,1.4 0,0,0,0 EndPointPrimitive1 af20d3247ffb4252b5051dc49566ca67 7.5,0,0,0 EndPointPrimitive2 cbf21bd3360345fbaf01c803d8a43425 6.43,0,0,0 EndPointPrimitive3 8643d03de3c74bf6a9b230c2e54b2356 5.38,0,0,0 EndPointPrimitive4 2f4f41eb11b141e69a320c69f7aecd46 2.75,0,0,0 EndPointPrimitive5 7a55e519fac24039bc46e97ea11fb41c 0.94,0,0,0 EndPointPrimitive6 3c87a622cee54c09bd1613b4f0c3ff9e FooterBand1 True True True 0,0.19,0.01,1.16 Black Black af20d3247ffb4252b5051dc49566ca67 VerticalLinePrimitive1 Black 7.5,0.19,0.01,1.16 Black Black cbf21bd3360345fbaf01c803d8a43425 VerticalLinePrimitive2 Black 6.43,0.19,0.01,1.16 Black Black 8643d03de3c74bf6a9b230c2e54b2356 VerticalLinePrimitive3 Black 5.38,0.19,0.01,1.16 Black Black 2f4f41eb11b141e69a320c69f7aecd46 VerticalLinePrimitive4 Black 2.75,0.19,0.01,1.16 Black Black 7a55e519fac24039bc46e97ea11fb41c VerticalLinePrimitive5 Black 0.94,0.19,0.01,1.16 Black Black 3c87a622cee54c09bd1613b4f0c3ff9e VerticalLinePrimitive6 Black 6f7544323a09490bab83f81b03c41359 0.5,0.5,0.5,0.5 Page1 11 8.5 Letter 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 11/15/2013 10:24:24 AM 9/24/2013 10:30:06 AM C:\Users\Steve\Desktop\rptInvoice.mrt 7a40de458f43488780512df2ed56e111 Report Inches 2011.3.1200 CSharp