eReceipt Provider=Microsoft.Jet.OLEDB.4.0;Mode=Share Deny None;Data Source=C:\Program Files\eReceipt\data\rmaker.mdb eReceipt DataSource1 receiptID,System.Int32 receiptNumber,System.String receiptDate,System.DateTime payeeID,System.Int32 amountDue,System.Decimal amountReceived,System.Decimal balanceRemaining,System.Decimal checkNumber,System.String paymentType,System.Int32 receivedBy,System.String status,System.Int32 receiptDesc,System.String otherPaymentDesc,System.String amountTax,System.Decimal amountOther,System.Decimal amountDiscount,System.Decimal receiptType,System.Int32 customField1,System.String customField2,System.String customField3,System.String customField4,System.String customField5,System.String customField6,System.String accountBalance,System.Decimal serviceID,System.Int32 voidReason,System.String payeeName,System.String methodName,System.String statusName,System.String R.receiptID,System.Int32 RP.receiptID,System.Int32 productID,System.Int32 quantity,System.Int32 overrideCost,System.Decimal overrideDesc,System.String unitTotal,System.Decimal extDesc,System.String productName,System.String productSKU,System.String 30 False DataSource1 eReceipt _x0040_startDate,,7,0 _x0040_endDate,,7,0 _x0040_startNumber,,200,50 _x0040_endNumber,,200,50 _x0040_status,,3,0 _x0040_payMethod,,3,0 _x0040_receivedBy,,200,50 SELECT R.*, P.payeeName, PM.methodName, S.statusName, RP.*, PD.productName, PD.productSKU FROM ((((tblReceipt AS R LEFT JOIN tblPayee AS P ON P.payeeID = R.payeeID) LEFT JOIN tblStatus AS S ON S.statusID=R.status) LEFT JOIN tblPayMethod AS PM ON PM.payMethodID = R.paymentType) LEFT JOIN tblReceipt_Product AS RP on RP.receiptID = R.receiptID) LEFT JOIN tblProduct AS PD ON PD.productID=RP.productID WHERE R.receiptDate >= @startDate AND R.receiptDate <= @endDate AND (@startNumber = "" OR R.receiptNumber >= @startNumber) AND (@endNumber = "" OR R.receiptNumber <= @endNumber) AND (@status = -1 OR R.status = @status) AND (@payMethod = -1 OR R.paymentType = @payMethod) AND (@receivedBy = "" OR R.receivedBy = @receivedBy) AND R.receiptType = 0 tblPayMethod methodName,System.String payMethodID,System.Int64 payMethodStatus,System.Int64 30 False tblPayMethod eReceipt select * from tblPayMethod order by methodName tblUser canDelete,System.Int64 canEdit,System.Int64 canRunReports,System.Int64 canVoid,System.Int64 isAdmin,System.Int64 password,System.String status,System.Int64 userID,System.Int64 username,System.String 30 False tblUser eReceipt select * from tblUser order by username tblSystem address1,System.String address2,System.String city,System.String companyName,System.String currencySymbol,System.Int64 customCurrency,System.String customField1,System.String customField2,System.String customField3,System.String customField4,System.String customField5,System.String customField6,System.String dbVersion,System.String defaultPaymentType,System.Int64 defaultReceiptType,System.Int64 hideAcctBalance,System.Int64 hideSalesTax,System.Int64 numberFormat,System.String phone,System.String requireAddress,System.Int64 resetNumberEOY,System.Int64 restrictAccess,System.Int64 state,System.String tagline,System.String taxRate,System.Decimal zip,System.String 30 tblSystem eReceipt select * from tblSystem ,test,test,System.Int32,,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.2,10.22,1.7 Transparent 0.1,0.4,10,0.3 Arial,12 Center 0,0,0,0 Text1 {tblSystem.companyName} Black Expression Center Transparent 0.1,0.1,10,0.3 Arial,14,Bold Center 0,0,0,0 Text2 Inventory Sold Ledger Black Expression Center Transparent 0.1,0.8,10,0.2 Arial,10 1212ed9d1a364f00afa87b57b457399a Center 0,0,0,0 Text3 Date From: {string.Format("{0:d}",DataSource1.Parameters["@startDate"].ParameterValue)} To: {string.Format("{0:d}",DataSource1.Parameters["@endDate"].ParameterValue)} Black Expression Transparent 0.1,1.1,10,0.2 Arial,10 d4406ede7b974f218fc0cc912bf05e2b Center 0,0,0,0 Text4 Receipt Number From: {IIF(DataSource1.Parameters["@startNumber"].ParameterValue.ToString() == "", "All",DataSource1.Parameters["@startNumber"].ParameterValue)} To: {IIF(DataSource1.Parameters["@startNumber"].ParameterValue.ToString() == "", "All",DataSource1.Parameters["@endNumber"].ParameterValue)} Black Expression PageHeaderBand1 Transparent 0,2.3,10.22,0.5 Transparent 0.1,0.2,0.9,0.2 Arial,10,Bold 0,0,0,0 Text5 Receipt No. Black Expression Transparent 1.1,0.2,0.9,0.2 Arial,10,Bold d45b148569d0413fa7065e6e085c4410 0,0,0,0 Text6 Date Black Expression Transparent 2.1,0.2,1.9,0.2 Arial,10,Bold 04c6a573b6c843fa960b1bdd6c0042a9 0,0,0,0 Text7 Customer Name Black Expression Transparent 9.2,0.2,0.9,0.2 Arial,10,Bold e9e79830632f46e2b3d420f088849c7c 0,0,0,0 Text12 Status Black Expression Transparent 4.1,0.2,1.2,0.2 Arial,10,Bold 84673bb7bc144f4f915633c81fb25f50 0,0,0,0 Text8 Item ID Black Expression Transparent 5.4,0.2,2.1,0.2 Arial,10,Bold 494c5986964045c59b5488b9c82658c7 0,0,0,0 Text9 Description Black Expression Transparent 7.6,0.2,0.5,0.2 Arial,10,Bold d05f48009a284ea591d6ce7e38ad485d Center 0,0,0,0 Text10 Qty Black Expression Transparent 8.2,0.2,0.9,0.2 Arial,10,Bold f85b4f315a1d4d37aaf9db276c52a068 Center 0,0,0,0 Text11 Cost Each Black Expression HeaderBand1 True Transparent 0,3.2,10.22,0 {DataSource1.paymentType} False GroupHeaderBand1 Transparent 0,3.6,10.22,0 {DataSource1.productID} GroupHeaderBand2 Transparent 0,4,10.22,0.4 Transparent 0.1,0.1,0.9,0.2 Arial,10 0,0,0,0 Text13 {DataSource1.receiptNumber} Black Transparent 1.1,0.1,0.9,0.2 Arial,10 0,0,0,0 Text14 {DataSource1.receiptDate} Black Transparent 2.1,0.1,1.9,0.2 Arial,10 0,0,0,0 Text15 {DataSource1.payeeName} Black Transparent 9.2,0.1,0.9,0.2 Arial,10 0,0,0,0 Text20 {DataSource1.statusName} Black Transparent 4.1,0.1,1.2,0.2 Arial,10 0,0,0,0 Text16 {DataSource1.productSKU} Black Transparent True 5.4,0.1,2.1,0.2 Arial,10 0,0,0,0 Text17 {DataSource1.overrideDesc} Black Transparent 7.6,0.1,0.5,0.2 Arial,10 Center 0,0,0,0 Text18 {DataSource1.quantity} Black Transparent 8.2,0.1,0.9,0.2 Arial,10 Right 0,0,0,0 Text19 {DataSource1.overrideCost} Black , 1 DataSource1 DataBand1 Transparent 0,4.8,10.22,0.6 Transparent 5.8,0.2,1.7,0.2 Arial,10,Bold 24f04d3851fb480790db2bbfb08bc29e Right 0,0,0,0 Text29 Total for {DataSource1.productSKU} Black Expression Transparent 7.6,0.2,0.5,0.2 Arial,10 9bde9f7ecbaf45539dde303b6b70d348 Center 0,0,0,0 Text31 {Sum(DataSource1.quantity)} Black Expression Transparent 8.2,0.2,0.9,0.2 Arial,10 bab18d8aad3d43ce96fd39db6ac2e3ca Right 0,0,0,0 Text32 {Sum(DataSource1.overrideCost)} Black , 1 Expression 8.2,0.1,1,0.01 Black Black 42423afd489b44508942932717f5fe37 HorizontalLinePrimitive3 Black 7.6,0.1,0.5,0.01 Black Black 57130af64f7841ab9d02073f2c72db7f HorizontalLinePrimitive4 Black GroupFooterBand2 Transparent 0,5.8,10.22,1 Transparent 0.3,0.2,1.7,0.2 Arial,10,Bold 107347d649f14bf8a5690ac130cdd0f1 Right 0,0,0,0 Text25 Total {IIF(DataSource1.paymentType == 0, "Other", DataSource1.methodName)}: Black Expression Transparent 2.1,0.2,0.9,0.2 Arial,10 048bdb5f88d944d18cf841d4f00cce98 Right 0,0,0,0 Text26 {Sum(DataSource1.amountReceived)} Black , 0 0 Expression Transparent 0.3,0.5,1.7,0.2 Arial,10,Bold d73367fe231742bcb7cebc9f8403e723 Right 0,0,0,0 Text27 Total Void: Black Expression Transparent 2.1,0.5,0.9,0.2 Arial,10 637f40f633124d8aaf1740d2c3e23d2d Right 0,0,0,0 Text28 {SumIf(DataBand1, DataSource1.amountReceived, DataSource1.status ==2) } Black , 0 0 Expression False GroupFooterBand1 Transparent 0,7.2,10.22,1 Transparent 0.3,0.1,1.7,0.2 Arial,10,Bold d150ff30d9a4445588b51bdd47c9f8c2 Right 0,0,0,0 Text21 Grand Total Received: Black Expression Transparent 2.1,0.1,0.9,0.2 Arial,10 Right 0,0,0,0 Text22 {Sum(DataSource1.amountReceived)} Black , 0 0 Expression Transparent 0.3,0.4,1.7,0.2 Arial,10,Bold cc836c557b544a19ac1ca7da4e453c58 Right 0,0,0,0 Text23 Grand Total Void: Black Expression Transparent 2.1,0.4,0.9,0.2 Arial,10 1736bb6eb4de46da8c8046bb63b2ee60 Right 0,0,0,0 Text24 {SumIf(DataBand1, DataSource1.amountReceived, DataSource1.status ==2) } Black , 0 0 Expression FooterBand1 4ca09597fc064fb8bd9746245938f5e7 0.39,0.39,0.39,0.39 Page1 Landscape 8.5 11 Letter Arial,100 [50:0:0:0] Control DataSource1.Parameters["@startDate"].ParameterValue = startDate.Value.ToString("MM/dd/yyyy"); DataSource1.Parameters["@endDate"].ParameterValue = endDate.Value.ToString("MM/dd/yyyy"); DataSource1.Parameters["@startNumber"].ParameterValue = startNumber.Text; DataSource1.Parameters["@endNumber"].ParameterValue = endNumber.Text; int status = -1; if (statusIssued.Checked) status = 1; if (statusVoid.Checked) status = 2; DataSource1.Parameters["@status"].ParameterValue = status; int payMethod = -1; if (paymentMethod.SelectedIndex > 0) { int index = paymentMethod.SelectedIndex; index--; int.TryParse(tblPayMethod.GetData("payMethodID", index).ToString(), out payMethod); } DataSource1.Parameters["@payMethod"].ParameterValue = payMethod; DataSource1.Parameters["@receivedBy"].ParameterValue = receivedBy.Text; if (groupByPayment.Checked) { GroupHeaderBand1.Enabled = true; GroupFooterBand1.Enabled = true; } else { GroupHeaderBand1.Enabled = false; GroupFooterBand1.Enabled = false; } DataSource1.Connect(); 328,256,96,24 OK Microsoft Sans Serif,8 Black 328, 256 ButtonControl1 96, 24 Run Control 8,16,240,80 Window 16,40,96,20 Microsoft Sans Serif,8 Black Short 16, 40 12/31/9998 12:00:00 AM 1/1/1753 12:00:00 AM startDate 96, 20 7/23/2011 7:50:58 AM Control 16,24,96,16 Microsoft Sans Serif,8 Black 16, 24 LabelControl1 96, 16 From: Window 120,40,96,20 Microsoft Sans Serif,8 Black Short 11648ca5f62c4721a22ed58c3a76acd6 120, 40 12/31/9998 12:00:00 AM 1/1/1753 12:00:00 AM endDate 96, 20 7/23/2011 7:50:58 AM Control 120,24,96,16 Microsoft Sans Serif,8 Black bd93808c31d34445b576faf1bfc55e28 120, 24 LabelControl2 96, 16 To: Microsoft Sans Serif,8 Black 8, 16 GroupBoxControl1 240, 80 Date Range: Control 264,16,160,80 Control True 24,24,96,16 Microsoft Sans Serif,8 Black 24, 24 statusAll 96, 16 All Control 24,40,96,16 Microsoft Sans Serif,8 Black 24, 40 statusIssued 96, 16 Issued Control 24,56,96,16 Microsoft Sans Serif,8 Black 24, 56 statusVoid 96, 16 Void Microsoft Sans Serif,8 Black 264, 16 GroupBoxControl2 160, 80 Receipt Status: Control 8,96,240,80 Control 16,24,96,16 Microsoft Sans Serif,8 Black 25d40644ccb048a6842fee7e8d74f634 16, 24 LabelControl3 96, 16 From: Control 120,24,96,16 Microsoft Sans Serif,8 Black 605395c4260441b0a37974222713f202 120, 24 LabelControl4 96, 16 To: Window 16,40,96,20 Microsoft Sans Serif,8 Black 16, 40 startNumber 96, 20 Window 120,40,96,20 Microsoft Sans Serif,8 Black 120, 40 endNumber 96, 20 Microsoft Sans Serif,8 Black 8, 96 GroupBoxControl3 240, 80 Receipt Number Range: Control 264,96,160,152 Window 16,32,128,20 DropDownList Microsoft Sans Serif,8 Black 16, 32 paymentMethod 128, 20 Combo Box Control 16,64,128,40 Microsoft Sans Serif,8 Black 16, 64 groupByPayment 128, 40 Group by payment method Microsoft Sans Serif,8 Black 264, 96 GroupBoxControl5 160, 152 Payment Method Control 8,184,240,64 Window 16,24,200,20 Microsoft Sans Serif,8 Black 16, 24 receivedBy 200, 20 Combo Box Microsoft Sans Serif,8 Black 8, 184 GroupBoxControl6 240, 64 Received By: Microsoft Sans Serif,8 623f8d8d9d2c47978d7c8c0f488d3084 if (!formLoaded) { InitForm(); } startDate.Value = DateTime.Now; endDate.Value = DateTime.Now; 0, 0 Form1 448, 320 Report Parameters System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Inventory SoldLedger Fuhr Software, Inc. 7/24/2011 10:46:59 AM 7/22/2011 1:53:47 PM C:\dev\eReceipt\reports\InventorySoldLedger.mrt bae5eaec94544caea58f9630bf03ea66 Inventory SoldLedger Inches 2011.1.1000 CSharp