LOOKING UP TRANACTIONS

Hi Daniel - paste the bottom verbiage on a notepad and save it as "Custom - Transactions with ShiftF9 Entries.qrp" or whatever verbiage you'd like; to get the "summary" view just collapse all the rows. Hope this helps.....

"Time's fun when you're having flies" - Kermit the Frog

//--- Report Summary --- //

Begin ReportSummary ReportType = reporttypeSales ReportTitle = "Transactions with Shift F9 Comment" PageOrientation = pageorientationPortrait WordWrap = True OutLineMode = True Groups = 2 GroupDescription = "" DisplayLogo = True LogoFileName = "MyLogo.bmp" ProcedureCall = "" TablesQueried = "FROM TenderEntry LEFT JOIN [Transaction] ON

TenderEntry.TransactionNumber = [Transaction].TransactionNumber LEFT JOIN

Batch ON [Transaction].BatchNumber = Batch.BatchNumber LEFT JOIN Register

ON Batch.RegisterID = Register.ID" SelCriteria = "" GroupBy = "" SortOrder = "TenderEntry.Amount, [Transaction].Time,

TenderEntry.Description, Register.Description" End ReportSummary

//--- Title Rows ---//

Begin TitleRow Text = "" Font = "Arial" FontBold = True FontSize = 16 Color = "Blue" End TitleRow

Begin TitleRow Text = "" Font = "Arial" FontBold = True FontSize = 12 Color = "Black" End TitleRow

Begin TitleRow Text = "Generated On " Font = "Arial" FontBold = True FontSize = 10 Color = "Black" End TitleRow

//--- Filters ---//

Begin Filter FieldName = "[Transaction].Time" FilterOp = reportfilteropbetween FilterLoLim = "" FilterHilim = "" End Filter

//--- Columns ---//

Begin Column FieldName = "[Transaction].TransactionNumber" DrillDownFieldName = "[Transaction].TransactionNumber" DrillDownReportName = "" Title = "Transaction" VBDataType = vbLong Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1700 GroupMethod = groupmethodNone ColFormat = "" End Column

Begin Column FieldName = "[Transaction].Comment" DrillDownFieldName = "" DrillDownReportName = "" Title = "Shift-F9 Comment" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2200 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftTop End Column

Begin Column FieldName = "[Transaction].ReferenceNumber" DrillDownFieldName = "" DrillDownReportName = "" Title = "Shift-F9 Reference" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1200 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftTop End Column

Begin Column FieldName = "TenderEntry.Description" DrillDownFieldName = "" DrillDownReportName = "" Title = "Tender" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2200 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftTop End Column

Begin Column FieldName = "Tenderentry.Amount" DrillDownFieldName = "" DrillDownReportName = "" Title = "Amount" VBDataType = vbCurrency Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1500 GroupMethod = groupmethodSum ColFormat = "" ColAlignment = flexAlignLeftTop End Column

Begin Column FieldName = "[Transaction].Time" DrillDownFieldName = "" DrillDownReportName = "" Title = "Date" VBDataType = vbdate Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1500 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftTop End Column

"daniel buntic" wrote:

Hello,

I have tried to run the report below, but it shows error on Line 16 TenderEntry.TransactionNumber = [Transaction].TransactionNumber LEFT JOIN

Thanks Gary

"c> Hi Daniel - paste the bottom verbiage on a notepad and save it as