object rptGeneric: TppReport AutoStop = False DataPipeline = daIBOQueryDataView1.Stock PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Report' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.mmMarginBottom = 20000 PrinterSetup.mmMarginLeft = 10000 PrinterSetup.mmMarginRight = 10000 PrinterSetup.mmMarginTop = 10000 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.FileName = 'C:\Bertrams\Bertline 401\Reports\returnsByPub.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 TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = False Left = 124 Top = 208 Version = '10.06' mmColumnWidth = 0 DataPipelineName = 'Stock' object ppHeaderBand1: TppHeaderBand mmBottomOffset = 0 mmHeight = 20902 mmPrintPosition = 0 object ppLabel2: TppLabel UserName = 'Label2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'From Supplier:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 14 Font.Style = [fsBold] Transparent = True mmHeight = 5821 mmLeft = 35454 mmTop = 8996 mmWidth = 41804 BandType = 0 end object ppVariable2: TppVariable UserName = 'varSupplier' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False BlankWhenZero = False CalcOrder = 0 Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 14 Font.Style = [fsBold] Transparent = True mmHeight = 5842 mmLeft = 92604 mmTop = 8996 mmWidth = 27220 BandType = 0 end end object ppDetailBand1: TppDetailBand mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppFooterBand1: TppFooterBand mmBottomOffset = 0 mmHeight = 17727 mmPrintPosition = 0 end object ppGroup1: TppGroup BreakName = 'CATEGORY_DESC' DataPipeline = daIBOQueryDataView1.Stock KeepTogether = True OutlineSettings.CreateNode = True UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'Stock' object ppGroupHeaderBand1: TppGroupHeaderBand mmBottomOffset = 0 mmHeight = 5556 mmPrintPosition = 0 object ppDBText6: TppDBText UserName = 'DBText6' AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'CATEGORY_DESC' DataPipeline = daIBOQueryDataView1.Stock Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 11 Font.Style = [fsBold] Transparent = True DataPipelineName = 'Stock' mmHeight = 4741 mmLeft = 40746 mmTop = 265 mmWidth = 27263 BandType = 3 GroupNo = 0 end object ppLabel3: TppLabel UserName = 'Label3' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Category Name:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 11 Font.Style = [fsBold] Transparent = True mmHeight = 4657 mmLeft = 4498 mmTop = 265 mmWidth = 29760 BandType = 3 GroupNo = 0 end end object ppGroupFooterBand1: TppGroupFooterBand mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object ppGroup2: TppGroup BreakName = 'EAN' DataPipeline = daIBOQueryDataView1.Stock KeepTogether = True OutlineSettings.CreateNode = True UserName = 'Group2' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'Stock' object ppGroupHeaderBand2: TppGroupHeaderBand mmBottomOffset = 0 mmHeight = 12171 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'DBText1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'EAN' DataPipeline = daIBOQueryDataView1.Stock Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 9 Font.Style = [] Transparent = True DataPipelineName = 'Stock' mmHeight = 3704 mmLeft = 4498 mmTop = 529 mmWidth = 32015 BandType = 3 GroupNo = 1 end object ppDBText2: TppDBText UserName = 'DBText2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'STOCK_DESCRIPTION' DataPipeline = daIBOQueryDataView1.Stock Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 9 Font.Style = [] Transparent = True DataPipelineName = 'Stock' mmHeight = 3704 mmLeft = 46567 mmTop = 529 mmWidth = 67204 BandType = 3 GroupNo = 1 end object ppDBText3: TppDBText UserName = 'DBText3' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'RRP' DataPipeline = daIBOQueryDataView1.Stock DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Stock' mmHeight = 3598 mmLeft = 116946 mmTop = 529 mmWidth = 17198 BandType = 3 GroupNo = 1 end object ppDBText4: TppDBText UserName = 'DBText4' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'STK_QTY_ONHAND' DataPipeline = daIBOQueryDataView1.Stock Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Stock' mmHeight = 3704 mmLeft = 153194 mmTop = 529 mmWidth = 9260 BandType = 3 GroupNo = 1 end object ppDBText5: TppDBText UserName = 'DBText5' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'ORDERS_SUPPLIER' DataPipeline = daIBOQueryDataView1.Stock Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 9 Font.Style = [] Transparent = True DataPipelineName = 'Stock' mmHeight = 3704 mmLeft = 166159 mmTop = 529 mmWidth = 17198 BandType = 3 GroupNo = 1 end object ppDBText7: TppDBText UserName = 'DBText7' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'COVER' DataPipeline = daIBOQueryDataView1.Stock Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Stock' mmHeight = 3704 mmLeft = 138377 mmTop = 529 mmWidth = 10848 BandType = 3 GroupNo = 1 end object ppDBText8: TppDBText UserName = 'DBText8' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'LAST_DELIVERY_DATE' DataPipeline = daIBOQueryDataView1.Stock DisplayFormat = 'dd-mmm-yy' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 9 Font.Style = [] Transparent = True DataPipelineName = 'Stock' mmHeight = 3704 mmLeft = 6350 mmTop = 5292 mmWidth = 32015 BandType = 3 GroupNo = 1 end end object ppGroupFooterBand2: TppGroupFooterBand mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object raCodeModule1: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650611 766172537570706C6965724F6E43616C630B50726F6772616D54797065070B74 7450726F63656475726506536F75726365069670726F63656475726520766172 537570706C6965724F6E43616C63287661722056616C75653A2056617269616E 74293B0D0A626567696E0D0A0D0A202056616C7565203A3D205265706F72742E 4175746F536561726368437269746572696142794E616D65282753746F636B27 2C20274F72646572735F737570706C69657227292E76616C7565735B305D3B0D 0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D65060B76617253757070 6C696572094576656E744E616D6506064F6E43616C63074576656E7449440221 0000} end object daDataModule1: TdaDataModule object daIBOQueryDataView1: TdaIBOQueryDataView UserName = 'Query_Stock' Height = 486 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 200 AutoSearchTabOrder = 0 object Stock: TppChildDBPipeline AutoCreateFields = False UserName = 'Stock' object ppField1: TppField FieldAlias = 'Ean' FieldName = 'EAN' FieldLength = 15 DisplayWidth = 15 Position = 0 TableName = 'STOCK_1' end object ppField2: TppField FieldAlias = 'Stock Description' FieldName = 'STOCK_DESCRIPTION' FieldLength = 80 DisplayWidth = 80 Position = 1 TableName = 'STOCK_1' end object ppField3: TppField FieldAlias = 'Rrp' FieldName = 'RRP' FieldLength = 2 DataType = dtDouble DisplayWidth = 2 Position = 2 TableName = 'STOCK_1' end object ppField4: TppField FieldAlias = 'Stk Qty Onhand' FieldName = 'STK_QTY_ONHAND' FieldLength = 0 DataType = dtInteger DisplayWidth = 0 Position = 3 TableName = 'STOCK_1' end object ppField5: TppField FieldAlias = 'Orders Supplier' FieldName = 'ORDERS_SUPPLIER' FieldLength = 6 IsDetail = True DisplayWidth = 6 Position = 4 TableName = 'HISTORY_ORDERS_1' end object ppField6: TppField FieldAlias = 'Category Desc' FieldName = 'CATEGORY_DESC' FieldLength = 30 IsDetail = True DisplayWidth = 30 Position = 5 TableName = 'SHOP_CATEGORY_1' end object ppField7: TppField FieldAlias = 'Cover' FieldName = 'COVER' FieldLength = 1 DisplayWidth = 1 Position = 6 TableName = 'STOCK_1' end object ppField8: TppField FieldAlias = 'Last Delivery Date' FieldName = 'LAST_DELIVERY_DATE' FieldLength = 0 DataType = dtDate DisplayWidth = 0 Position = 7 TableName = 'STOCK_1' end end object daSQL1: TdaSQL CollationType = ctASCII DatabaseName = 'ibcBertline' DatabaseType = dtInterBase DataPipelineName = 'Stock' IsCaseSensitive = True LinkColor = clMaroon MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT STOCK_1.EAN, STOCK_1.STOCK_DESCRIPTION, ' ' STOCK_1.RRP, STOCK_1.STK_QTY_ONHAND, ' ' HISTORY_ORDERS_1.ORDERS_SUPPLIER, ' ' SHOP_CATEGORY_1.CATEGORY_DESC, ' ' STOCK_1.COVER, STOCK_1.LAST_DELIVERY_DATE' 'FROM STOCK STOCK_1' ' INNER JOIN HISTORY_ORDERS HISTORY_ORDERS_1 ON ' ' (HISTORY_ORDERS_1.ORDERS_STOCK_NO = STOCK_1.STOCK_NO)' ' INNER JOIN SHOP_CATEGORY SHOP_CATEGORY_1 ON ' ' (SHOP_CATEGORY_1.SHOP_CATEGORY = STOCK_1.SHOP_CATEGORY_1)' 'WHERE ('#39'c'#39' <> '#39'c'#39' ) AND (' ' ( STOCK_1.STK_QTY_ONHAND > 0 ))') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Operator = dacoGreaterThan Value = '0' object TdaField Alias = 'Stk Qty Onhand' DataType = dtInteger DisplayWidth = 0 FieldAlias = 'Stk Qty Onhand' FieldLength = 0 FieldName = 'STK_QTY_ONHAND' SQLFieldName = 'STK_QTY_ONHAND' TableAlias = 'Stock' TableName = 'STOCK' TableSQLAlias = 'STOCK_1' end object TdaNumericValue end end object daCriteria2: TdaCriteria ChildType = 7 Level = 0 object TdaField Alias = 'Orders Supplier' AutoSearch = True DisplayWidth = 6 FieldAlias = 'Orders Supplier' FieldLength = 6 FieldName = 'ORDERS_SUPPLIER' Mandatory = True SQLFieldName = 'ORDERS_SUPPLIER' TableAlias = 'History Orders' TableName = 'HISTORY_ORDERS' TableSQLAlias = 'HISTORY_ORDERS_1' end end object daCriteria3: TdaCriteria ChildType = 7 Level = 0 Operator = dacoLessThan object TdaField Alias = 'Last Delivery Date' AutoSearch = True DataType = dtDate DisplayWidth = 0 FieldAlias = 'Last Delivery Date' FieldLength = 0 FieldName = 'LAST_DELIVERY_DATE' Mandatory = True SQLFieldName = 'LAST_DELIVERY_DATE' TableAlias = 'Stock' TableName = 'STOCK' TableSQLAlias = 'STOCK_1' end end object daField1: TdaField Alias = 'Ean' DisplayWidth = 15 FieldAlias = 'Ean' FieldLength = 15 FieldName = 'EAN' SQLFieldName = 'EAN' TableAlias = 'Stock' TableName = 'STOCK' TableSQLAlias = 'STOCK_1' end object daField2: TdaField Alias = 'Stock Description' DisplayWidth = 80 FieldAlias = 'Stock Description' FieldLength = 80 FieldName = 'STOCK_DESCRIPTION' SQLFieldName = 'STOCK_DESCRIPTION' TableAlias = 'Stock' TableName = 'STOCK' TableSQLAlias = 'STOCK_1' end object daField3: TdaField Alias = 'Rrp' DataType = dtDouble DisplayWidth = 2 FieldAlias = 'Rrp' FieldLength = 2 FieldName = 'RRP' SQLFieldName = 'RRP' TableAlias = 'Stock' TableName = 'STOCK' TableSQLAlias = 'STOCK_1' end object daField4: TdaField Alias = 'Stk Qty Onhand' DataType = dtInteger DisplayWidth = 0 FieldAlias = 'Stk Qty Onhand' FieldLength = 0 FieldName = 'STK_QTY_ONHAND' SQLFieldName = 'STK_QTY_ONHAND' TableAlias = 'Stock' TableName = 'STOCK' TableSQLAlias = 'STOCK_1' end object daField5: TdaField Alias = 'Orders Supplier' DisplayWidth = 6 FieldAlias = 'Orders Supplier' FieldLength = 6 FieldName = 'ORDERS_SUPPLIER' IsDetail = True SQLFieldName = 'ORDERS_SUPPLIER' TableAlias = 'History Orders' TableName = 'HISTORY_ORDERS' TableSQLAlias = 'HISTORY_ORDERS_1' end object daField6: TdaField Alias = 'Category Desc' DisplayWidth = 30 FieldAlias = 'Category Desc' FieldLength = 30 FieldName = 'CATEGORY_DESC' IsDetail = True SQLFieldName = 'CATEGORY_DESC' TableAlias = 'Shop Category' TableName = 'SHOP_CATEGORY' TableSQLAlias = 'SHOP_CATEGORY_1' end object daField7: TdaField Alias = 'Cover' DisplayWidth = 1 FieldAlias = 'Cover' FieldLength = 1 FieldName = 'COVER' SQLFieldName = 'COVER' TableAlias = 'Stock' TableName = 'STOCK' TableSQLAlias = 'STOCK_1' end object daField8: TdaField Alias = 'Last Delivery Date' DataType = dtDate DisplayWidth = 0 FieldAlias = 'Last Delivery Date' FieldLength = 0 FieldName = 'LAST_DELIVERY_DATE' SQLFieldName = 'LAST_DELIVERY_DATE' TableAlias = 'Stock' TableName = 'STOCK' TableSQLAlias = 'STOCK_1' end object daField9: TdaField ChildType = 2 Alias = 'Category Desc' DisplayWidth = 30 FieldAlias = 'Category Desc' FieldLength = 30 FieldName = 'CATEGORY_DESC' SQLFieldName = 'CATEGORY_DESC' TableAlias = 'Shop Category' TableName = 'SHOP_CATEGORY' TableSQLAlias = 'SHOP_CATEGORY_1' end object daField10: TdaField ChildType = 2 Alias = 'Last Delivery Date' DataType = dtDate DisplayWidth = 0 FieldAlias = 'Last Delivery Date' FieldLength = 0 FieldName = 'LAST_DELIVERY_DATE' SQLFieldName = 'LAST_DELIVERY_DATE' TableAlias = 'Stock' TableName = 'STOCK' TableSQLAlias = 'STOCK_1' end object daField11: TdaField ChildType = 2 Alias = 'Stock Description' DisplayWidth = 80 FieldAlias = 'Stock Description' FieldLength = 80 FieldName = 'STOCK_DESCRIPTION' SQLFieldName = 'STOCK_DESCRIPTION' TableAlias = 'Stock' TableName = 'STOCK' TableSQLAlias = 'STOCK_1' end object daTable1: TdaTable ChildType = 5 Alias = 'Stock' JoinType = dajtNone SQLAlias = 'STOCK_1' TableAlias = 'Stock' TableName = 'STOCK' end object daTable2: TdaTable ChildType = 5 Alias = 'History Orders' SQLAlias = 'HISTORY_ORDERS_1' TableAlias = 'History Orders' TableName = 'HISTORY_ORDERS' object daTableJoin1: TdaTableJoin ChildType = 6 object daField13: TdaField ChildType = 3 Alias = 'Orders Stock No' DataType = dtLargeInt DisplayWidth = 0 FieldAlias = 'Orders Stock No' FieldLength = 0 FieldName = 'ORDERS_STOCK_NO' SQLFieldName = 'ORDERS_STOCK_NO' TableAlias = 'History Orders' TableName = 'HISTORY_ORDERS' TableSQLAlias = 'HISTORY_ORDERS_1' end object daField12: TdaField ChildType = 4 Alias = 'Stock No' DataType = dtLargeInt DisplayWidth = 0 FieldAlias = 'Stock No' FieldLength = 0 FieldName = 'STOCK_NO' SQLFieldName = 'STOCK_NO' TableAlias = 'Stock' TableName = 'STOCK' TableSQLAlias = 'STOCK_1' end end end object daTable3: TdaTable ChildType = 5 Alias = 'Shop Category' SQLAlias = 'SHOP_CATEGORY_1' TableAlias = 'Shop Category' TableName = 'SHOP_CATEGORY' object daTableJoin2: TdaTableJoin ChildType = 6 object daField15: TdaField ChildType = 3 Alias = 'Shop Category' DataType = dtLargeInt DisplayWidth = 0 FieldAlias = 'Shop Category' FieldLength = 0 FieldName = 'SHOP_CATEGORY' SQLFieldName = 'SHOP_CATEGORY' TableAlias = 'Shop Category' TableName = 'SHOP_CATEGORY' TableSQLAlias = 'SHOP_CATEGORY_1' end object daField14: TdaField ChildType = 4 Alias = 'Shop Category 1' DataType = dtLargeInt DisplayWidth = 0 FieldAlias = 'Shop Category 1' FieldLength = 0 FieldName = 'SHOP_CATEGORY_1' SQLFieldName = 'SHOP_CATEGORY_1' TableAlias = 'Stock' TableName = 'STOCK' TableSQLAlias = 'STOCK_1' end end end end end end object ppParameterList1: TppParameterList end end