object rptGeneric: TppReport AutoStop = False DataPipeline = daIBOQueryDataView1.Receipts PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Report' PrinterSetup.Orientation = poLandscape PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.mmMarginBottom = 20000 PrinterSetup.mmMarginLeft = 10000 PrinterSetup.mmMarginRight = 10000 PrinterSetup.mmMarginTop = 10000 PrinterSetup.mmPaperHeight = 210000 PrinterSetup.mmPaperWidth = 297000 PrinterSetup.PaperSize = 9 Template.FileName = 'G:\Bertline\Custom Reports\Bertline 10\OpenBravo Receiptsv3 with' + ' Sell Price.rtm' Template.Format = ftASCII Units = utMillimeters AllowPrintToArchive = True AllowPrintToFile = True DeviceType = 'Screen' EmailSettings.ReportFormat = 'PDF' OnPreviewFormCreate = rptGenericPreviewFormCreate OutlineSettings.CreateNode = True OutlineSettings.CreatePageNodes = True OutlineSettings.Enabled = False OutlineSettings.Visible = False PreviewFormSettings.WindowState = wsMaximized ShowAutoSearchDialog = True TextFileName = 'C:\A\EPOS.csv' TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = False Left = 124 Top = 208 Version = '10.06' mmColumnWidth = 0 DataPipelineName = 'Receipts' object ppHeaderBand1: TppHeaderBand mmBottomOffset = 0 mmHeight = 24606 mmPrintPosition = 0 object ppLabel14: TppLabel UserName = 'Label14' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Ticket Breakdown Report' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5027 mmLeft = 109802 mmTop = 1588 mmWidth = 51329 BandType = 0 end object ppVariable1: TppVariable UserName = 'Variable1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False BlankWhenZero = False CalcOrder = 0 Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True mmHeight = 5027 mmLeft = 104775 mmTop = 18256 mmWidth = 19050 BandType = 0 end object ppVariable2: TppVariable UserName = 'Variable2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False BlankWhenZero = False CalcOrder = 1 Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True mmHeight = 5027 mmLeft = 153194 mmTop = 18256 mmWidth = 19050 BandType = 0 end object ppLabel15: TppLabel UserName = 'Label15' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'and' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5027 mmLeft = 131498 mmTop = 17727 mmWidth = 7408 BandType = 0 end object ppLabel16: TppLabel UserName = 'Label16' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'between' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5027 mmLeft = 127000 mmTop = 9525 mmWidth = 16933 BandType = 0 end end object ppDetailBand1: TppDetailBand Save = True mmBottomOffset = 0 mmHeight = 14817 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'Line' SaveOrder = 1 Save = True AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'LINE' DataPipeline = daIBOQueryDataView1.Receipts Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] Transparent = True DataPipelineName = 'Receipts' mmHeight = 4868 mmLeft = 2117 mmTop = 424 mmWidth = 8043 BandType = 4 end object ppDBText4: TppDBText UserName = 'CODE' SaveOrder = 2 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'CODE' DataPipeline = daIBOQueryDataView1.Receipts Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 12700 mmTop = 1000 mmWidth = 37306 BandType = 4 end object ppDBText7: TppDBText UserName = 'PRICE' SaveOrder = 6 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'PRICE' DataPipeline = daIBOQueryDataView1.Receipts DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 138000 mmTop = 1000 mmWidth = 20000 BandType = 4 end object ppDBText8: TppDBText UserName = 'UNITS' SaveOrder = 5 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'UNITS' DataPipeline = daIBOQueryDataView1.Receipts Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 160338 mmTop = 1000 mmWidth = 10054 BandType = 4 end object ppDBText9: TppDBText UserName = 'Value' SaveOrder = 10 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'rate_price_units_price_u' DataPipeline = daIBOQueryDataView1.Receipts DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 175155 mmTop = 1000 mmWidth = 20000 BandType = 4 end object ppDBText10: TppDBText UserName = 'Tax' SaveOrder = 9 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'rate_price_units' DataPipeline = daIBOQueryDataView1.Receipts DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Receipts' mmHeight = 4868 mmLeft = 234000 mmTop = 1000 mmWidth = 20000 BandType = 4 end object ppDBText11: TppDBText UserName = 'RATE' SaveOrder = 8 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'RATE' DataPipeline = daIBOQueryDataView1.Receipts Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 223309 mmTop = 1000 mmWidth = 9260 BandType = 4 end object ppDBText14: TppDBText UserName = 'PRICESELL' SaveOrder = 7 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'PRICESELL' DataPipeline = daIBOQueryDataView1.Receipts DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 12 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 138000 mmTop = 7000 mmWidth = 20000 BandType = 4 end object ppDBText13: TppDBText UserName = 'Date' SaveOrder = 4 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'DATENEW' DataPipeline = daIBOQueryDataView1.Receipts Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 12 Font.Style = [] Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 1852 mmTop = 7000 mmWidth = 48154 BandType = 4 end object ppDBText15: TppDBText UserName = 'Difference' SaveOrder = 11 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'iif_products_1_Name_0_pri' DataPipeline = daIBOQueryDataView1.Receipts DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 12 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 198967 mmTop = 1000 mmWidth = 20000 BandType = 4 end object ppDBText12: TppDBText UserName = 'Desc1' SaveOrder = 3 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'iif_price_0_products_1_na' DataPipeline = daIBOQueryDataView1.Receipts Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 52123 mmTop = 1000 mmWidth = 82021 BandType = 4 end object ppDBText16: TppDBText UserName = 'TicketID' SaveOrder = 0 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'TICKETID' DataPipeline = daIBOQueryDataView1.Receipts Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Arial' Font.Size = 12 Font.Style = [] Transparent = True DataPipelineName = 'Receipts' mmHeight = 4868 mmLeft = 54240 mmTop = 6879 mmWidth = 12435 BandType = 4 end end object ppFooterBand1: TppFooterBand mmBottomOffset = 0 mmHeight = 529 mmPrintPosition = 0 end object ppSummaryBand1: TppSummaryBand mmBottomOffset = 0 mmHeight = 15875 mmPrintPosition = 0 object ppLine19: TppLine UserName = 'Line101' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Weight = 0.750000000000000000 mmHeight = 6350 mmLeft = 234000 mmTop = 2000 mmWidth = 20108 BandType = 7 end object ppLine15: TppLine UserName = 'Line15' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Weight = 0.750000000000000000 mmHeight = 6350 mmLeft = 257000 mmTop = 2000 mmWidth = 20108 BandType = 7 end object ppLabel17: TppLabel UserName = 'Label17' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Report Totals:' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True mmHeight = 5027 mmLeft = 136525 mmTop = 4000 mmWidth = 28840 BandType = 7 end object ppLine16: TppLine UserName = 'Line16' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Weight = 0.750000000000000000 mmHeight = 2117 mmLeft = 175000 mmTop = 2000 mmWidth = 20108 BandType = 7 end object ppDBCalc6: TppDBCalc UserName = 'DBCalc6' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'rate_price_units_price_u' DataPipeline = daIBOQueryDataView1.Receipts DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 175000 mmTop = 4000 mmWidth = 20108 BandType = 7 end object ppDBCalc7: TppDBCalc UserName = 'DBCalc7' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'rate_price_units' DataPipeline = daIBOQueryDataView1.Receipts DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 234000 mmTop = 3175 mmWidth = 20000 BandType = 7 end object ppLine17: TppLine UserName = 'Line17' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Style = lsDouble Weight = 0.750000000000000000 mmHeight = 3969 mmLeft = 175000 mmTop = 10000 mmWidth = 20108 BandType = 7 end object ppLine18: TppLine UserName = 'Line18' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Style = lsDouble Weight = 0.750000000000000000 mmHeight = 3969 mmLeft = 234000 mmTop = 10000 mmWidth = 20108 BandType = 7 end object ppLine20: TppLine UserName = 'Line20' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Style = lsDouble Weight = 0.750000000000000000 mmHeight = 3969 mmLeft = 257000 mmTop = 10000 mmWidth = 20108 BandType = 7 end object ppDBCalc8: TppDBCalc UserName = 'DBCalc8' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'iif_price_0_price_0' DataPipeline = daIBOQueryDataView1.Receipts DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 257000 mmTop = 3175 mmWidth = 20108 BandType = 7 end object ppDBCalc13: TppDBCalc UserName = 'DBCalc13' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'iif_products_1_Name_0_pri' DataPipeline = daIBOQueryDataView1.Receipts DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 199000 mmTop = 4000 mmWidth = 20000 BandType = 7 end object ppLine26: TppLine UserName = 'Line25' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Style = lsDouble Weight = 0.750000000000000000 mmHeight = 3969 mmLeft = 199000 mmTop = 10000 mmWidth = 20108 BandType = 7 end object ppLine25: TppLine UserName = 'Line24' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Weight = 0.750000000000000000 mmHeight = 3969 mmLeft = 199000 mmTop = 2000 mmWidth = 20108 BandType = 7 end end object ppGroup2: TppGroup BreakName = 'cast_Datenew_as_DATE' DataPipeline = daIBOQueryDataView1.Receipts OutlineSettings.CreateNode = True NewPage = True UserName = 'Group2' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'Receipts' object ppGroupHeaderBand2: TppGroupHeaderBand Save = True mmBottomOffset = 0 mmHeight = 16404 mmPrintPosition = 0 object ppLabel2: TppLabel UserName = 'Line26' SaveOrder = 1 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Line' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5027 mmLeft = 529 mmTop = 8467 mmWidth = 8731 BandType = 3 GroupNo = 0 end object ppLabel3: TppLabel UserName = 'Ref' SaveOrder = 2 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Reference' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5027 mmLeft = 11906 mmTop = 8467 mmWidth = 20638 BandType = 3 GroupNo = 0 end object ppLabel4: TppLabel UserName = 'Desc' SaveOrder = 3 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Title / Description' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5027 mmLeft = 51858 mmTop = 8202 mmWidth = 35719 BandType = 3 GroupNo = 0 end object ppLabel6: TppLabel UserName = 'RRP' SaveOrder = 6 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'RRP' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5027 mmLeft = 144992 mmTop = 2910 mmWidth = 8996 BandType = 3 GroupNo = 0 end object ppLabel7: TppLabel UserName = 'QTY' SaveOrder = 5 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'QTY' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5027 mmLeft = 163513 mmTop = 8467 mmWidth = 8731 BandType = 3 GroupNo = 0 end object ppLabel8: TppLabel UserName = 'Value1' SaveOrder = 10 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Value' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5027 mmLeft = 182034 mmTop = 7673 mmWidth = 11377 BandType = 3 GroupNo = 0 end object ppLabel9: TppLabel UserName = 'Taxrate' SaveOrder = 8 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Tax Rate' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True WordWrap = True mmHeight = 9991 mmLeft = 227315 mmTop = 3175 mmWidth = 9186 BandType = 3 GroupNo = 0 end object ppLabel10: TppLabel UserName = 'Tax1' SaveOrder = 9 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Tax' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5027 mmLeft = 244211 mmTop = 7673 mmWidth = 7408 BandType = 3 GroupNo = 0 end object ppLabel11: TppLabel UserName = 'Date1' SaveOrder = 4 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Date' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5027 mmLeft = 529 mmTop = 794 mmWidth = 9260 BandType = 3 GroupNo = 0 end object ppLabel12: TppLabel UserName = 'TotDisc' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Total Discount' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True WordWrap = True mmHeight = 10054 mmLeft = 258498 mmTop = 2910 mmWidth = 17992 BandType = 3 GroupNo = 0 end object ppLine13: TppLine UserName = 'Line13' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Style = lsDouble Weight = 0.750000000000000000 mmHeight = 3969 mmLeft = 0 mmTop = 13758 mmWidth = 272257 BandType = 3 GroupNo = 0 end object ppDBText5: TppDBText UserName = 'DBText5' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'cast_Datenew_as_DATE' DataPipeline = daIBOQueryDataView1.Receipts Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 12435 mmTop = 1323 mmWidth = 32808 BandType = 3 GroupNo = 0 end object ppLabel18: TppLabel UserName = 'Soldprice' SaveOrder = 7 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Sold Price' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True mmHeight = 5027 mmLeft = 138642 mmTop = 8202 mmWidth = 20902 BandType = 3 GroupNo = 0 end object ppLabel19: TppLabel UserName = 'Diff' SaveOrder = 11 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Difference' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5027 mmLeft = 199761 mmTop = 7673 mmWidth = 20638 BandType = 3 GroupNo = 0 end object ppLabel20: TppLabel UserName = 'TicketID1' SaveOrder = 0 Save = True AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Ticket ID' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Arial' Font.Size = 12 Font.Style = [] Transparent = True mmHeight = 4868 mmLeft = 196321 mmTop = 1588 mmWidth = 17198 BandType = 3 GroupNo = 0 end end object ppGroupFooterBand2: TppGroupFooterBand mmBottomOffset = 0 mmHeight = 12965 mmPrintPosition = 0 object ppLine10: TppLine UserName = 'Line10' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Weight = 0.750000000000000000 mmHeight = 6350 mmLeft = 234000 mmTop = 2000 mmWidth = 20000 BandType = 5 GroupNo = 0 end object ppLine12: TppLine UserName = 'Line12' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Weight = 0.750000000000000000 mmHeight = 6350 mmLeft = 257000 mmTop = 2000 mmWidth = 20108 BandType = 5 GroupNo = 0 end object ppLabel13: TppLabel UserName = 'Label12' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Daily Totals:' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True mmHeight = 5027 mmLeft = 139965 mmTop = 4000 mmWidth = 25135 BandType = 5 GroupNo = 0 end object ppLine7: TppLine UserName = 'Line7' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Weight = 0.750000000000000000 mmHeight = 2117 mmLeft = 175000 mmTop = 2000 mmWidth = 20000 BandType = 5 GroupNo = 0 end object ppDBCalc1: TppDBCalc UserName = 'DBCalc1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'rate_price_units_price_u' DataPipeline = daIBOQueryDataView1.Receipts DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] ResetGroup = ppGroup2 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 175000 mmTop = 4000 mmWidth = 20108 BandType = 5 GroupNo = 0 end object ppDBCalc4: TppDBCalc UserName = 'DBCalc4' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'rate_price_units' DataPipeline = daIBOQueryDataView1.Receipts DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] ResetGroup = ppGroup2 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 234000 mmTop = 4000 mmWidth = 20000 BandType = 5 GroupNo = 0 end object ppLine8: TppLine UserName = 'Line8' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Style = lsDouble Weight = 0.750000000000000000 mmHeight = 3969 mmLeft = 175000 mmTop = 10000 mmWidth = 20108 BandType = 5 GroupNo = 0 end object ppLine9: TppLine UserName = 'Line9' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Style = lsDouble Weight = 0.750000000000000000 mmHeight = 3969 mmLeft = 234000 mmTop = 10000 mmWidth = 20000 BandType = 5 GroupNo = 0 end object ppLine11: TppLine UserName = 'Line11' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Style = lsDouble Weight = 0.750000000000000000 mmHeight = 3969 mmLeft = 257000 mmTop = 10000 mmWidth = 20000 BandType = 5 GroupNo = 0 end object ppDBCalc5: TppDBCalc UserName = 'DBCalc5' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'iif_price_0_price_0' DataPipeline = daIBOQueryDataView1.Receipts DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] ResetGroup = ppGroup2 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Receipts' mmHeight = 4868 mmLeft = 257000 mmTop = 4000 mmWidth = 20000 BandType = 5 GroupNo = 0 end object ppDBText3: TppDBText UserName = 'DBText3' AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'cast_Datenew_as_DATE' DataPipeline = daIBOQueryDataView1.Receipts Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Receipts' mmHeight = 4868 mmLeft = 82021 mmTop = 4000 mmWidth = 45508 BandType = 5 GroupNo = 0 end object ppDBCalc12: TppDBCalc UserName = 'DBCalc12' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'iif_products_1_Name_0_pri' DataPipeline = daIBOQueryDataView1.Receipts DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] ResetGroup = ppGroup2 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 199000 mmTop = 4000 mmWidth = 20000 BandType = 5 GroupNo = 0 end object ppLine24: TppLine UserName = 'Line23' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Style = lsDouble Weight = 0.750000000000000000 mmHeight = 3969 mmLeft = 199000 mmTop = 10000 mmWidth = 20108 BandType = 5 GroupNo = 0 end object ppLine23: TppLine UserName = 'Line22' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Weight = 0.750000000000000000 mmHeight = 3969 mmLeft = 199000 mmTop = 2000 mmWidth = 20108 BandType = 5 GroupNo = 0 end end end object ppGroup1: TppGroup BreakName = 'TICKETID' DataPipeline = daIBOQueryDataView1.Receipts KeepTogether = True OutlineSettings.CreateNode = True UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'Receipts' object ppGroupHeaderBand1: TppGroupHeaderBand mmBottomOffset = 0 mmHeight = 8731 mmPrintPosition = 0 object ppLabel1: TppLabel UserName = 'Label1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Ticket No' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5027 mmLeft = 1588 mmTop = 2646 mmWidth = 19050 BandType = 3 GroupNo = 1 end object ppDBText2: TppDBText UserName = 'DBText2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'TICKETID' DataPipeline = daIBOQueryDataView1.Receipts Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 25665 mmTop = 2646 mmWidth = 13758 BandType = 3 GroupNo = 1 end object ppLabel5: TppLabel UserName = 'Label5' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Time' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5027 mmLeft = 52388 mmTop = 2646 mmWidth = 9790 BandType = 3 GroupNo = 1 end object ppDBText6: TppDBText UserName = 'DBText6' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'cast_Datenew_as_TIME' DataPipeline = daIBOQueryDataView1.Receipts Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 67469 mmTop = 2910 mmWidth = 18785 BandType = 3 GroupNo = 1 end end object ppGroupFooterBand1: TppGroupFooterBand mmBottomOffset = 0 mmHeight = 17198 mmPrintPosition = 0 object ppLine1: TppLine UserName = 'Line1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Weight = 0.750000000000000000 mmHeight = 2117 mmLeft = 175000 mmTop = 2000 mmWidth = 20000 BandType = 5 GroupNo = 1 end object ppDBCalc3: TppDBCalc UserName = 'DBCalc3' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'rate_price_units' DataPipeline = daIBOQueryDataView1.Receipts DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 234000 mmTop = 4000 mmWidth = 20108 BandType = 5 GroupNo = 1 end object ppLine3: TppLine UserName = 'Line3' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Style = lsDouble Weight = 0.750000000000000000 mmHeight = 3969 mmLeft = 175000 mmTop = 10000 mmWidth = 20108 BandType = 5 GroupNo = 1 end object ppLine4: TppLine UserName = 'Line4' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Style = lsDouble Weight = 0.750000000000000000 mmHeight = 3969 mmLeft = 234000 mmTop = 10000 mmWidth = 20108 BandType = 5 GroupNo = 1 end object ppLine5: TppLine UserName = 'Line5' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Style = lsDouble Weight = 0.750000000000000000 mmHeight = 3969 mmLeft = 257000 mmTop = 10000 mmWidth = 20108 BandType = 5 GroupNo = 1 end object ppLine6: TppLine UserName = 'Line6' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Weight = 0.750000000000000000 mmHeight = 6350 mmLeft = 257000 mmTop = 2000 mmWidth = 20000 BandType = 5 GroupNo = 1 end object ppLine14: TppLine UserName = 'Line14' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Style = lsDouble Weight = 0.750000000000000000 mmHeight = 3969 mmLeft = 1323 mmTop = 13229 mmWidth = 275696 BandType = 5 GroupNo = 1 end object ppLine2: TppLine UserName = 'Line2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Weight = 0.750000000000000000 mmHeight = 6350 mmLeft = 234000 mmTop = 2000 mmWidth = 20108 BandType = 5 GroupNo = 1 end object ppDBCalc2: TppDBCalc UserName = 'DBCalc2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'rate_price_units_price_u' DataPipeline = daIBOQueryDataView1.Receipts DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 175000 mmTop = 3969 mmWidth = 20000 BandType = 5 GroupNo = 1 end object ppDBCalc9: TppDBCalc UserName = 'DBCalc9' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'iif_products_1_Name_0_pri' DataPipeline = daIBOQueryDataView1.Receipts DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 12 Font.Style = [] ParentDataPipeline = False ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Receipts' mmHeight = 4763 mmLeft = 199000 mmTop = 4000 mmWidth = 20000 BandType = 5 GroupNo = 1 end object ppLine21: TppLine UserName = 'Line19' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Weight = 0.750000000000000000 mmHeight = 3969 mmLeft = 199000 mmTop = 2000 mmWidth = 20000 BandType = 5 GroupNo = 1 end object ppLine22: TppLine UserName = 'Line21' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Style = lsDouble Weight = 0.750000000000000000 mmHeight = 3969 mmLeft = 199000 mmTop = 10000 mmWidth = 20000 BandType = 5 GroupNo = 1 end object ppDBCalc14: TppDBCalc UserName = 'DBCalc14' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'iif_price_0_price_0' DataPipeline = daIBOQueryDataView1.Receipts DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = -2147483640 Font.Name = 'Arial' Font.Size = 12 Font.Style = [] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Receipts' mmHeight = 4868 mmLeft = 257000 mmTop = 4000 mmWidth = 20000 BandType = 5 GroupNo = 1 end end end object daDataModule1: TdaDataModule object daIBOQueryDataView1: TdaIBOQueryDataView UserName = 'Query_Receipts' Height = 245 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 495 AutoSearchTabOrder = 0 object Receipts: TppChildDBPipeline AutoCreateFields = False UserName = 'Receipts' object ppField1: TppField FieldAlias = 'Date new' FieldName = 'DATENEW' FieldLength = 0 DataType = dtDateTime DisplayWidth = 0 Position = 0 TableName = 'RECEIPTS_1' end object ppField2: TppField FieldAlias = 'Ticket ID' FieldName = 'TICKETID' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 0 Position = 1 TableName = 'TICKETS_1' end object ppField3: TppField FieldAlias = 'Name' FieldName = 'NAME' FieldLength = 1024 IsDetail = True DisplayWidth = 1024 Position = 2 TableName = 'PRODUCTS_1' end object ppField4: TppField FieldAlias = 'Line' FieldName = 'LINE' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 0 Position = 3 TableName = 'TICKETLINES_1' end object ppField5: TppField FieldAlias = 'Code' FieldName = 'CODE' FieldLength = 1024 IsDetail = True DisplayWidth = 1024 Position = 4 TableName = 'PRODUCTS_1' end object ppField6: TppField FieldAlias = 'Price' FieldName = 'PRICE' FieldLength = 0 IsDetail = True DataType = dtDouble DisplayWidth = 0 Position = 5 TableName = 'TICKETLINES_1' end object ppField7: TppField FieldAlias = 'Rate' FieldName = 'RATE' FieldLength = 0 IsDetail = True DataType = dtDouble DisplayWidth = 0 Position = 6 TableName = 'TAXES_1' end object ppField8: TppField FieldAlias = 'Units' FieldName = 'UNITS' FieldLength = 0 IsDetail = True DataType = dtDouble DisplayWidth = 0 Position = 7 TableName = 'TICKETLINES_1' end object ppField9: TppField FieldAlias = 'Price sell' FieldName = 'PRICESELL' FieldLength = 0 IsDetail = True DataType = dtDouble DisplayWidth = 0 Position = 8 TableName = 'PRODUCTS_1' end object ppField10: TppField FieldAlias = 'cast(Datenew as DATE)' FieldName = 'cast_Datenew_as_DATE' FieldLength = 0 Linkable = False DataType = dtDate DisplayWidth = 0 Position = 9 TableName = 'RECEIPTS_1' end object ppField11: TppField FieldAlias = 'cast(Datenew as TIME)' FieldName = 'cast_Datenew_as_TIME' FieldLength = 0 Linkable = False DataType = dtTime DisplayWidth = 0 Position = 10 TableName = 'RECEIPTS_1' end object ppField12: TppField FieldAlias = '(rate * price) * units' FieldName = 'rate_price_units' FieldLength = 0 Linkable = False DataType = dtDouble DisplayWidth = 0 Position = 11 TableName = 'TICKETLINES_1' end object ppField13: TppField FieldAlias = '(price * units)' FieldName = 'price_units' FieldLength = 0 Linkable = False DataType = dtDouble DisplayWidth = 0 Position = 12 TableName = 'TICKETLINES_1' end object ppField14: TppField FieldAlias = 'iif(price < 0, price, 0)' FieldName = 'iif_price_0_price_0' FieldLength = 256 Linkable = False DataType = dtDouble DisplayWidth = 256 Position = 13 TableName = 'RECEIPTS_1' end object ppField15: TppField FieldAlias = 'iif(price < 0, '#39'Discount'#39', products_1.name)' FieldName = 'iif_price_0_products_1_na' FieldLength = 256 Linkable = False DataType = dtMemo DisplayWidth = 256 Position = 14 TableName = 'TICKETLINES_1' end object ppField16: TppField FieldAlias = '(rate * price) * units + (price * units)' FieldName = 'rate_price_units_price_u' FieldLength = 0 Linkable = False DataType = dtDouble DisplayWidth = 0 Position = 15 TableName = 'TICKETLINES_1' end object ppField17: TppField FieldAlias = 'iif(products_1.Name = '#39'Discount'#39',0,price*units-pricesell*units)' FieldName = 'iif_products_1_Name_0_pri' FieldLength = 256 Linkable = False DataType = dtDouble DisplayWidth = 256 Position = 16 TableName = 'TAXES_1' end end object daSQL1: TdaSQL CollationType = ctASCII DatabaseName = 'ibcBertline' DatabaseType = dtInterBase DataPipelineName = 'Receipts' IsCaseSensitive = True LinkColor = clMaroon MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT RECEIPTS_1.DATENEW, TICKETS_1.TICKETID, ' ' PRODUCTS_1.NAME, TICKETLINES_1.LINE, ' ' PRODUCTS_1.CODE, TICKETLINES_1.PRICE, ' ' TAXES_1.RATE, TICKETLINES_1.UNITS, ' ' PRODUCTS_1.PRICESELL, ' ' cast(Datenew as DATE) cast_Datenew_as_DATE, ' ' cast(Datenew as TIME) cast_Datenew_as_TIME, ' ' (rate * price) * units rate_price_units, ' ' (price * units) price_units, ' ' iif(price < 0, price, 0) iif_price_0_price_0, ' ' iif(price < 0, '#39'Discount'#39', products_1.name) iif_price_0_p' + 'roducts_1_na, ' ' (rate * price) * units + (price * units) rate_price_units' + '_price_u, ' ' iif(products_1.Name = '#39'Discount'#39',0,price*units-pricesell*' + 'units) iif_products_1_Name_0_pri' 'FROM RECEIPTS RECEIPTS_1' ' INNER JOIN TICKETS TICKETS_1 ON ' ' (TICKETS_1.ID = RECEIPTS_1.ID)' ' INNER JOIN TICKETLINES TICKETLINES_1 ON ' ' (TICKETLINES_1.TICKET = TICKETS_1.ID)' ' INNER JOIN TAXES TAXES_1 ON ' ' (TAXES_1.ID = TICKETLINES_1.TAXID)' ' LEFT OUTER JOIN PRODUCTS PRODUCTS_1 ON ' ' (PRODUCTS_1.ID = TICKETLINES_1.PRODUCT)' 'WHERE ('#39'c'#39' <> '#39'c'#39' )') SQLType = sqSQL2 object daCalculation1: TdaCalculation ChildType = 8 Alias = 'cast(Datenew as DATE)' DataType = dtDate DisplayWidth = 0 FieldAlias = 'Date new' FieldLength = 0 FieldName = 'DATENEW' Linkable = False SQLFieldName = 'cast_Datenew_as_DATE' TableAlias = 'Receipts' TableName = 'RECEIPTS' TableSQLAlias = 'RECEIPTS_1' CalcType = dacaExpression Expression = 'cast(Datenew as DATE)' end object daCalculation2: TdaCalculation ChildType = 8 Alias = 'cast(Datenew as TIME)' DataType = dtTime DisplayWidth = 0 FieldAlias = 'Date new' FieldLength = 0 FieldName = 'DATENEW' Linkable = False SQLFieldName = 'cast_Datenew_as_TIME' TableAlias = 'Receipts' TableName = 'RECEIPTS' TableSQLAlias = 'RECEIPTS_1' CalcType = dacaExpression Expression = 'cast(Datenew as TIME)' end object daCalculation3: TdaCalculation ChildType = 8 Alias = '(rate * price) * units' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Price' FieldLength = 0 FieldName = 'PRICE' Linkable = False SQLFieldName = 'rate_price_units' TableAlias = 'Ticket Lines' TableName = 'TICKETLINES' TableSQLAlias = 'TICKETLINES_1' CalcType = dacaExpression Expression = '(rate * price) * units' end object daCalculation4: TdaCalculation ChildType = 8 Alias = '(price * units)' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Price' FieldLength = 0 FieldName = 'PRICE' Linkable = False SQLFieldName = 'price_units' TableAlias = 'Ticket Lines' TableName = 'TICKETLINES' TableSQLAlias = 'TICKETLINES_1' CalcType = dacaExpression Expression = '(price * units)' end object daCalculation5: TdaCalculation ChildType = 8 Alias = 'iif(price < 0, price, 0)' DataType = dtDouble DisplayWidth = 256 FieldAlias = 'Money' FieldLength = 256 FieldName = 'MONEY' Linkable = False SQLFieldName = 'iif_price_0_price_0' TableAlias = 'Receipts' TableName = 'RECEIPTS' TableSQLAlias = 'RECEIPTS_1' CalcType = dacaExpression Expression = 'iif(price < 0, price, 0)' end object daCalculation6: TdaCalculation ChildType = 8 Alias = 'iif(price < 0, '#39'Discount'#39', products_1.name)' DataType = dtMemo DisplayWidth = 256 FieldAlias = 'Tax id' FieldLength = 256 FieldName = 'TAXID' Linkable = False SQLFieldName = 'iif_price_0_products_1_na' TableAlias = 'Ticket Lines' TableName = 'TICKETLINES' TableSQLAlias = 'TICKETLINES_1' CalcType = dacaExpression Expression = 'iif(price < 0, '#39'Discount'#39', products_1.name)' end object daCalculation7: TdaCalculation ChildType = 8 Alias = '(rate * price) * units + (price * units)' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Price' FieldLength = 0 FieldName = 'PRICE' Linkable = False SQLFieldName = 'rate_price_units_price_u' TableAlias = 'Ticket Lines' TableName = 'TICKETLINES' TableSQLAlias = 'TICKETLINES_1' CalcType = dacaExpression Expression = '(rate * price) * units + (price * units)' end object daCalculation8: TdaCalculation ChildType = 8 Alias = 'iif(products_1.Name = '#39'Discount'#39',0,price*units-pricesell*units)' DataType = dtDouble DisplayWidth = 256 FieldAlias = 'Taxes ID' FieldLength = 256 FieldName = 'ID' Linkable = False SQLFieldName = 'iif_products_1_Name_0_pri' TableAlias = 'Taxes' TableName = 'TAXES' TableSQLAlias = 'TAXES_1' CalcType = dacaExpression Expression = 'iif(products_1.Name = '#39'Discount'#39',0,price*units-pricesell*units)' end object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Operator = dacoBetween object TdaField Alias = 'Date new' AutoSearch = True DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'Date new' FieldLength = 0 FieldName = 'DATENEW' Mandatory = True SQLFieldName = 'DATENEW' TableAlias = 'Receipts' TableName = 'RECEIPTS' TableSQLAlias = 'RECEIPTS_1' end end object daCriteria2: TdaCriteria ChildType = 7 Level = 0 object TdaField Alias = 'Code' AutoSearch = True DisplayWidth = 1024 FieldAlias = 'Code' FieldLength = 1024 FieldName = 'CODE' ShowAllValues = True SQLFieldName = 'CODE' TableAlias = 'Products' TableName = 'PRODUCTS' TableSQLAlias = 'PRODUCTS_1' end end object daCriteria3: TdaCriteria ChildType = 7 Level = 0 Operator = dacoLessThan object TdaField Alias = 'Price sell' AutoSearch = True DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Price sell' FieldLength = 0 FieldName = 'PRICESELL' ShowAllValues = True SQLFieldName = 'PRICESELL' TableAlias = 'Products' TableName = 'PRODUCTS' TableSQLAlias = 'PRODUCTS_1' end end object daField1: TdaField Alias = 'Date new' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'Date new' FieldLength = 0 FieldName = 'DATENEW' SQLFieldName = 'DATENEW' TableAlias = 'Receipts' TableName = 'RECEIPTS' TableSQLAlias = 'RECEIPTS_1' end object daField2: TdaField Alias = 'Ticket ID' DataType = dtInteger DisplayWidth = 0 FieldAlias = 'Ticket ID' FieldLength = 0 FieldName = 'TICKETID' IsDetail = True SQLFieldName = 'TICKETID' TableAlias = 'Tickets' TableName = 'TICKETS' TableSQLAlias = 'TICKETS_1' end object daField3: TdaField Alias = 'Name' DisplayWidth = 1024 FieldAlias = 'Name' FieldLength = 1024 FieldName = 'NAME' IsDetail = True SQLFieldName = 'NAME' TableAlias = 'Products' TableName = 'PRODUCTS' TableSQLAlias = 'PRODUCTS_1' end object daField4: TdaField Alias = 'Line' DataType = dtInteger DisplayWidth = 0 FieldAlias = 'Line' FieldLength = 0 FieldName = 'LINE' IsDetail = True SQLFieldName = 'LINE' TableAlias = 'Ticket Lines' TableName = 'TICKETLINES' TableSQLAlias = 'TICKETLINES_1' end object daField5: TdaField Alias = 'Code' DisplayWidth = 1024 FieldAlias = 'Code' FieldLength = 1024 FieldName = 'CODE' IsDetail = True SQLFieldName = 'CODE' TableAlias = 'Products' TableName = 'PRODUCTS' TableSQLAlias = 'PRODUCTS_1' end object daField6: TdaField Alias = 'Price' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Price' FieldLength = 0 FieldName = 'PRICE' IsDetail = True SQLFieldName = 'PRICE' TableAlias = 'Ticket Lines' TableName = 'TICKETLINES' TableSQLAlias = 'TICKETLINES_1' end object daField7: TdaField Alias = 'Rate' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Rate' FieldLength = 0 FieldName = 'RATE' IsDetail = True SQLFieldName = 'RATE' TableAlias = 'Taxes' TableName = 'TAXES' TableSQLAlias = 'TAXES_1' end object daField8: TdaField Alias = 'Units' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Units' FieldLength = 0 FieldName = 'UNITS' IsDetail = True SQLFieldName = 'UNITS' TableAlias = 'Ticket Lines' TableName = 'TICKETLINES' TableSQLAlias = 'TICKETLINES_1' end object daField9: TdaField Alias = 'Price sell' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Price sell' FieldLength = 0 FieldName = 'PRICESELL' IsDetail = True SQLFieldName = 'PRICESELL' TableAlias = 'Products' TableName = 'PRODUCTS' TableSQLAlias = 'PRODUCTS_1' end object daCalculation9: TdaCalculation ChildType = 2 Alias = 'cast(Datenew as DATE)' DataType = dtDate DisplayWidth = 0 FieldAlias = 'Date new' FieldLength = 0 FieldName = 'DATENEW' Linkable = False SQLFieldName = 'cast_Datenew_as_DATE' TableAlias = 'Receipts' TableName = 'RECEIPTS' TableSQLAlias = 'RECEIPTS_1' CalcType = dacaExpression Expression = 'cast(Datenew as DATE)' end object daField10: TdaField ChildType = 2 Alias = 'Ticket ID' DataType = dtInteger DisplayWidth = 0 FieldAlias = 'Ticket ID' FieldLength = 0 FieldName = 'TICKETID' SQLFieldName = 'TICKETID' TableAlias = 'Tickets' TableName = 'TICKETS' TableSQLAlias = 'TICKETS_1' end object daField11: TdaField ChildType = 2 Alias = 'Line' DataType = dtInteger DisplayWidth = 0 FieldAlias = 'Line' FieldLength = 0 FieldName = 'LINE' SQLFieldName = 'LINE' TableAlias = 'Ticket Lines' TableName = 'TICKETLINES' TableSQLAlias = 'TICKETLINES_1' end object daTable1: TdaTable ChildType = 5 Alias = 'Receipts' JoinType = dajtNone SQLAlias = 'RECEIPTS_1' TableAlias = 'Receipts' TableName = 'RECEIPTS' end object daTable2: TdaTable ChildType = 5 Alias = 'Tickets' SQLAlias = 'TICKETS_1' TableAlias = 'Tickets' TableName = 'TICKETS' object daTableJoin1: TdaTableJoin ChildType = 6 object daField13: TdaField ChildType = 3 Alias = 'Ticket ID' DisplayWidth = 256 FieldAlias = 'Ticket ID' FieldLength = 256 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Tickets' TableName = 'TICKETS' TableSQLAlias = 'TICKETS_1' end object daField12: TdaField ChildType = 4 Alias = 'Receipt ID' DisplayWidth = 256 FieldAlias = 'Receipt ID' FieldLength = 256 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Receipts' TableName = 'RECEIPTS' TableSQLAlias = 'RECEIPTS_1' end end end object daTable3: TdaTable ChildType = 5 Alias = 'Ticket Lines' SQLAlias = 'TICKETLINES_1' TableAlias = 'Ticket Lines' TableName = 'TICKETLINES' object daTableJoin2: TdaTableJoin ChildType = 6 object daField15: TdaField ChildType = 3 Alias = 'Ticket' DisplayWidth = 256 FieldAlias = 'Ticket' FieldLength = 256 FieldName = 'TICKET' SQLFieldName = 'TICKET' TableAlias = 'Ticket Lines' TableName = 'TICKETLINES' TableSQLAlias = 'TICKETLINES_1' end object daField14: TdaField ChildType = 4 Alias = 'Ticket ID' DisplayWidth = 256 FieldAlias = 'Ticket ID' FieldLength = 256 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Tickets' TableName = 'TICKETS' TableSQLAlias = 'TICKETS_1' end end end object daTable4: TdaTable ChildType = 5 Alias = 'Taxes' SQLAlias = 'TAXES_1' TableAlias = 'Taxes' TableName = 'TAXES' object daTableJoin3: TdaTableJoin ChildType = 6 object daField17: TdaField ChildType = 3 Alias = 'Taxes ID' DisplayWidth = 256 FieldAlias = 'Taxes ID' FieldLength = 256 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Taxes' TableName = 'TAXES' TableSQLAlias = 'TAXES_1' end object daField16: TdaField ChildType = 4 Alias = 'Tax id' DisplayWidth = 256 FieldAlias = 'Tax id' FieldLength = 256 FieldName = 'TAXID' SQLFieldName = 'TAXID' TableAlias = 'Ticket Lines' TableName = 'TICKETLINES' TableSQLAlias = 'TICKETLINES_1' end end end object daTable5: TdaTable ChildType = 5 Alias = 'Products' JoinType = dajtLeftOuter SQLAlias = 'PRODUCTS_1' TableAlias = 'Products' TableName = 'PRODUCTS' object daTableJoin4: TdaTableJoin ChildType = 6 object daField19: TdaField ChildType = 3 Alias = 'Products ID' DisplayWidth = 256 FieldAlias = 'Products ID' FieldLength = 256 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Products' TableName = 'PRODUCTS' TableSQLAlias = 'PRODUCTS_1' end object daField18: TdaField ChildType = 4 Alias = 'Product' DisplayWidth = 256 FieldAlias = 'Product' FieldLength = 256 FieldName = 'PRODUCT' SQLFieldName = 'PRODUCT' TableAlias = 'Ticket Lines' TableName = 'TICKETLINES' TableSQLAlias = 'TICKETLINES_1' end end end end end end object raCodeModule1: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D65060F 5661726961626C65314F6E43616C630B50726F6772616D54797065070B747450 726F63656475726506536F75726365068970726F636564757265205661726961 626C65314F6E43616C63287661722056616C75653A2056617269616E74293B0D 0A626567696E0D0A56616C75653A3D5265706F72742E4175746F536561726368 437269746572696142794E616D6528275265636569707473272C202744617465 4E657727292E76616C7565735B305D3B0D0A0D0A656E643B0D0A0D436F6D706F 6E656E744E616D6506095661726961626C6531094576656E744E616D6506064F 6E43616C63074576656E74494402210001060F5472614576656E7448616E646C 65720B50726F6772616D4E616D65060F5661726961626C65324F6E43616C630B 50726F6772616D54797065070B747450726F63656475726506536F7572636506 8970726F636564757265205661726961626C65324F6E43616C63287661722056 616C75653A2056617269616E74293B0D0A626567696E0D0A56616C75653A3D52 65706F72742E4175746F536561726368437269746572696142794E616D652827 5265636569707473272C2027446174654E657727292E76616C7565735B315D3B 0D0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D650609566172696162 6C6532094576656E744E616D6506064F6E43616C63074576656E744944022100 00} end object ppParameterList1: TppParameterList end end