object rptGeneric: TppReport AutoStop = False DataPipeline = daIBOQueryDataView1.Isbn_List_Detail 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 = 'C:\Bertrams\Bertline 401\Reports\ISBN List exportEanTitleAuthorP' + 'riceQyty.rtm' Template.Format = ftASCII Units = utMillimeters 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:\Users\cjones\Desktop\ISBN List Export.csv' TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = False Left = 124 Top = 208 Version = '10.06' mmColumnWidth = 0 DataPipelineName = 'Isbn_List_Detail' object ppHeaderBand1: TppHeaderBand mmBottomOffset = 0 mmHeight = 265 mmPrintPosition = 0 end object ppDetailBand1: TppDetailBand Save = True mmBottomOffset = 0 mmHeight = 5027 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'EAN' SaveOrder = 0 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'EAN' DataPipeline = daIBOQueryDataView1.Isbn_List_Detail Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 9 Font.Style = [] Transparent = True DataPipelineName = 'Isbn_List_Detail' mmHeight = 3704 mmLeft = 1058 mmTop = 529 mmWidth = 28310 BandType = 4 end object ppDBText2: TppDBText UserName = 'TITLE' SaveOrder = 1 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'STOCK_DESCRIPTION' DataPipeline = daIBOQueryDataView1.Isbn_List_Detail Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 9 Font.Style = [] Transparent = True DataPipelineName = 'Isbn_List_Detail' mmHeight = 3704 mmLeft = 33338 mmTop = 529 mmWidth = 68263 BandType = 4 end object ppDBText3: TppDBText UserName = 'RRP' SaveOrder = 2 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'RRP' DataPipeline = daIBOQueryDataView1.Isbn_List_Detail Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 9 Font.Style = [] Transparent = True DataPipelineName = 'Isbn_List_Detail' mmHeight = 3704 mmLeft = 154252 mmTop = 794 mmWidth = 17198 BandType = 4 end object ppDBText7: TppDBText UserName = 'COVER' SaveOrder = 3 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'COVER' DataPipeline = daIBOQueryDataView1.Isbn_List_Detail Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 9 Font.Style = [] Transparent = True DataPipelineName = 'Isbn_List_Detail' mmHeight = 3704 mmLeft = 130175 mmTop = 1058 mmWidth = 17198 BandType = 4 end object ppDBText4: TppDBText UserName = 'AUTHOR' SaveOrder = 4 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'AUTHOR_SURNAME' DataPipeline = daIBOQueryDataView1.Isbn_List_Detail Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 9 Font.Style = [] Transparent = True DataPipelineName = 'Isbn_List_Detail' mmHeight = 3704 mmLeft = 107950 mmTop = 794 mmWidth = 17198 BandType = 4 end object ppDBText5: TppDBText UserName = 'QTY' SaveOrder = 5 Save = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'LIST_QTY' DataPipeline = daIBOQueryDataView1.Isbn_List_Detail Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 9 Font.Style = [] Transparent = True DataPipelineName = 'Isbn_List_Detail' mmHeight = 3704 mmLeft = 176477 mmTop = 794 mmWidth = 17198 BandType = 4 end end object ppFooterBand1: TppFooterBand mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object daDataModule1: TdaDataModule object daIBOQueryDataView1: TdaIBOQueryDataView UserName = 'Query_Isbn_List_Detail' Height = 444 Left = 10 NameColumnWidth = 144 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 375 AutoSearchTabOrder = 0 object Isbn_List_Detail: TppChildDBPipeline AutoCreateFields = False UserName = 'Isbn_List_Detail' object ppField1: TppField FieldAlias = 'List Id' FieldName = 'LIST_ID' FieldLength = 0 IsDetail = True DataType = dtLargeInt DisplayWidth = 0 Position = 0 TableName = 'ISBN_LIST_HEADER_1' end object ppField2: TppField FieldAlias = 'Ean' FieldName = 'EAN' FieldLength = 15 IsDetail = True DisplayWidth = 15 Position = 1 TableName = 'STOCK_1' end object ppField3: TppField FieldAlias = 'Stock Description' FieldName = 'STOCK_DESCRIPTION' FieldLength = 80 IsDetail = True DisplayWidth = 80 Position = 2 TableName = 'STOCK_1' end object ppField4: TppField FieldAlias = 'Author Surname' FieldName = 'AUTHOR_SURNAME' FieldLength = 40 IsDetail = True DisplayWidth = 40 Position = 3 TableName = 'STOCK_1' end object ppField5: TppField FieldAlias = 'Author Forename' FieldName = 'AUTHOR_FORENAME' FieldLength = 15 IsDetail = True DisplayWidth = 15 Position = 4 TableName = 'STOCK_1' end object ppField6: TppField FieldAlias = 'List Line Ref' FieldName = 'LIST_LINE_REF' FieldLength = 12 DisplayWidth = 12 Position = 5 TableName = 'ISBN_LIST_DETAIL_1' end object ppField7: TppField FieldAlias = 'List Qty' FieldName = 'LIST_QTY' FieldLength = 0 DataType = dtInteger DisplayWidth = 0 Position = 6 TableName = 'ISBN_LIST_DETAIL_1' end object ppField8: TppField FieldAlias = 'Rrp' FieldName = 'RRP' FieldLength = 2 IsDetail = True DataType = dtDouble DisplayWidth = 2 Position = 7 TableName = 'STOCK_1' end object ppField9: TppField FieldAlias = 'Cover' FieldName = 'COVER' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 8 TableName = 'STOCK_1' end object ppField10: TppField FieldAlias = 'Category Desc' FieldName = 'CATEGORY_DESC' FieldLength = 30 IsDetail = True DisplayWidth = 30 Position = 9 TableName = 'SHOP_CATEGORY_1' end object ppField11: TppField FieldAlias = 'Stk Qty Onhand' FieldName = 'STK_QTY_ONHAND' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 0 Position = 10 TableName = 'STOCK_1' end object ppField12: TppField FieldAlias = 'List Description' FieldName = 'LIST_DESCRIPTION' FieldLength = 254 IsDetail = True DisplayWidth = 254 Position = 11 TableName = 'ISBN_LIST_HEADER_1' end object ppField13: TppField FieldAlias = 'Publisher Name' FieldName = 'PUBLISHER_NAME' FieldLength = 30 IsDetail = True DisplayWidth = 30 Position = 12 TableName = 'STOCK_1' end object ppField14: TppField FieldAlias = 'Publication Date' FieldName = 'PUBLICATION_DATE' FieldLength = 0 IsDetail = True DataType = dtDate DisplayWidth = 0 Position = 13 TableName = 'STOCK_1' end end object daSQL1: TdaSQL CollationType = ctASCII DatabaseName = 'ibcBertline' DatabaseType = dtInterBase DataPipelineName = 'Isbn_List_Detail' IsCaseSensitive = True LinkColor = clMaroon MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT ISBN_LIST_HEADER_1.LIST_ID, STOCK_1.EAN, ' ' STOCK_1.STOCK_DESCRIPTION, ' ' STOCK_1.AUTHOR_SURNAME, ' ' STOCK_1.AUTHOR_FORENAME, ' ' ISBN_LIST_DETAIL_1.LIST_LINE_REF, ' ' ISBN_LIST_DETAIL_1.LIST_QTY, STOCK_1.RRP, ' ' STOCK_1.COVER, ' ' SHOP_CATEGORY_1.CATEGORY_DESC, ' ' STOCK_1.STK_QTY_ONHAND, ' ' ISBN_LIST_HEADER_1.LIST_DESCRIPTION, ' ' STOCK_1.PUBLISHER_NAME, ' ' STOCK_1.PUBLICATION_DATE' 'FROM ISBN_LIST_DETAIL ISBN_LIST_DETAIL_1' ' INNER JOIN ISBN_LIST_HEADER ISBN_LIST_HEADER_1 ON ' ' (ISBN_LIST_HEADER_1.LIST_ID = ISBN_LIST_DETAIL_1.LIST_HDR_I' + 'D)' ' INNER JOIN STOCK STOCK_1 ON ' ' (STOCK_1.STOCK_NO = ISBN_LIST_DETAIL_1.LIST_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' )') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 object TdaField Alias = 'List Id' AutoSearch = True DataType = dtLargeInt DisplayWidth = 0 FieldAlias = 'List Id' FieldLength = 0 FieldName = 'LIST_ID' SQLFieldName = 'LIST_ID' TableAlias = 'Isbn List Header' TableName = 'ISBN_LIST_HEADER' TableSQLAlias = 'ISBN_LIST_HEADER_1' end end object daField1: TdaField Alias = 'List Id' DataType = dtLargeInt DisplayWidth = 0 FieldAlias = 'List Id' FieldLength = 0 FieldName = 'LIST_ID' IsDetail = True SQLFieldName = 'LIST_ID' TableAlias = 'Isbn List Header' TableName = 'ISBN_LIST_HEADER' TableSQLAlias = 'ISBN_LIST_HEADER_1' end object daField2: TdaField Alias = 'Ean' DisplayWidth = 15 FieldAlias = 'Ean' FieldLength = 15 FieldName = 'EAN' IsDetail = True SQLFieldName = 'EAN' TableAlias = 'Stock' TableName = 'STOCK' TableSQLAlias = 'STOCK_1' end object daField3: TdaField Alias = 'Stock Description' DisplayWidth = 80 FieldAlias = 'Stock Description' FieldLength = 80 FieldName = 'STOCK_DESCRIPTION' IsDetail = True SQLFieldName = 'STOCK_DESCRIPTION' TableAlias = 'Stock' TableName = 'STOCK' TableSQLAlias = 'STOCK_1' end object daField4: TdaField Alias = 'Author Surname' DisplayWidth = 40 FieldAlias = 'Author Surname' FieldLength = 40 FieldName = 'AUTHOR_SURNAME' IsDetail = True SQLFieldName = 'AUTHOR_SURNAME' TableAlias = 'Stock' TableName = 'STOCK' TableSQLAlias = 'STOCK_1' end object daField5: TdaField Alias = 'Author Forename' DisplayWidth = 15 FieldAlias = 'Author Forename' FieldLength = 15 FieldName = 'AUTHOR_FORENAME' IsDetail = True SQLFieldName = 'AUTHOR_FORENAME' TableAlias = 'Stock' TableName = 'STOCK' TableSQLAlias = 'STOCK_1' end object daField6: TdaField Alias = 'List Line Ref' DisplayWidth = 12 FieldAlias = 'List Line Ref' FieldLength = 12 FieldName = 'LIST_LINE_REF' SQLFieldName = 'LIST_LINE_REF' TableAlias = 'Isbn List Detail' TableName = 'ISBN_LIST_DETAIL' TableSQLAlias = 'ISBN_LIST_DETAIL_1' end object daField7: TdaField Alias = 'List Qty' DataType = dtInteger DisplayWidth = 0 FieldAlias = 'List Qty' FieldLength = 0 FieldName = 'LIST_QTY' SQLFieldName = 'LIST_QTY' TableAlias = 'Isbn List Detail' TableName = 'ISBN_LIST_DETAIL' TableSQLAlias = 'ISBN_LIST_DETAIL_1' end object daField8: TdaField Alias = 'Rrp' DataType = dtDouble DisplayWidth = 2 FieldAlias = 'Rrp' FieldLength = 2 FieldName = 'RRP' IsDetail = True SQLFieldName = 'RRP' TableAlias = 'Stock' TableName = 'STOCK' TableSQLAlias = 'STOCK_1' end object daField9: TdaField Alias = 'Cover' DisplayWidth = 1 FieldAlias = 'Cover' FieldLength = 1 FieldName = 'COVER' IsDetail = True SQLFieldName = 'COVER' TableAlias = 'Stock' TableName = 'STOCK' TableSQLAlias = 'STOCK_1' end object daField10: 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 daField11: TdaField Alias = 'Stk Qty Onhand' DataType = dtInteger DisplayWidth = 0 FieldAlias = 'Stk Qty Onhand' FieldLength = 0 FieldName = 'STK_QTY_ONHAND' IsDetail = True SQLFieldName = 'STK_QTY_ONHAND' TableAlias = 'Stock' TableName = 'STOCK' TableSQLAlias = 'STOCK_1' end object daField12: TdaField Alias = 'List Description' DisplayWidth = 254 FieldAlias = 'List Description' FieldLength = 254 FieldName = 'LIST_DESCRIPTION' IsDetail = True SQLFieldName = 'LIST_DESCRIPTION' TableAlias = 'Isbn List Header' TableName = 'ISBN_LIST_HEADER' TableSQLAlias = 'ISBN_LIST_HEADER_1' end object daField13: TdaField Alias = 'Publisher Name' DisplayWidth = 30 FieldAlias = 'Publisher Name' FieldLength = 30 FieldName = 'PUBLISHER_NAME' IsDetail = True SQLFieldName = 'PUBLISHER_NAME' TableAlias = 'Stock' TableName = 'STOCK' TableSQLAlias = 'STOCK_1' end object daField14: TdaField Alias = 'Publication Date' DataType = dtDate DisplayWidth = 0 FieldAlias = 'Publication Date' FieldLength = 0 FieldName = 'PUBLICATION_DATE' IsDetail = True SQLFieldName = 'PUBLICATION_DATE' TableAlias = 'Stock' TableName = 'STOCK' TableSQLAlias = 'STOCK_1' end object daField15: 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 = 'Isbn List Detail' JoinType = dajtNone SQLAlias = 'ISBN_LIST_DETAIL_1' TableAlias = 'Isbn List Detail' TableName = 'ISBN_LIST_DETAIL' end object daTable2: TdaTable ChildType = 5 Alias = 'Isbn List Header' SQLAlias = 'ISBN_LIST_HEADER_1' TableAlias = 'Isbn List Header' TableName = 'ISBN_LIST_HEADER' object daTableJoin1: TdaTableJoin ChildType = 6 object daField17: TdaField ChildType = 3 Alias = 'List Id' DataType = dtLargeInt DisplayWidth = 0 FieldAlias = 'List Id' FieldLength = 0 FieldName = 'LIST_ID' SQLFieldName = 'LIST_ID' TableAlias = 'Isbn List Header' TableName = 'ISBN_LIST_HEADER' TableSQLAlias = 'ISBN_LIST_HEADER_1' end object daField16: TdaField ChildType = 4 Alias = 'List Hdr Id' DataType = dtLargeInt DisplayWidth = 0 FieldAlias = 'List Hdr Id' FieldLength = 0 FieldName = 'LIST_HDR_ID' SQLFieldName = 'LIST_HDR_ID' TableAlias = 'Isbn List Detail' TableName = 'ISBN_LIST_DETAIL' TableSQLAlias = 'ISBN_LIST_DETAIL_1' end end end object daTable3: TdaTable ChildType = 5 Alias = 'Stock' SQLAlias = 'STOCK_1' TableAlias = 'Stock' TableName = 'STOCK' object daTableJoin2: TdaTableJoin ChildType = 6 object daField19: TdaField ChildType = 3 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 object daField18: TdaField ChildType = 4 Alias = 'List Stock No' DataType = dtLargeInt DisplayWidth = 0 FieldAlias = 'List Stock No' FieldLength = 0 FieldName = 'LIST_STOCK_NO' SQLFieldName = 'LIST_STOCK_NO' TableAlias = 'Isbn List Detail' TableName = 'ISBN_LIST_DETAIL' TableSQLAlias = 'ISBN_LIST_DETAIL_1' end end end object daTable4: TdaTable ChildType = 5 Alias = 'Shop Category' SQLAlias = 'SHOP_CATEGORY_1' TableAlias = 'Shop Category' TableName = 'SHOP_CATEGORY' object daTableJoin3: TdaTableJoin ChildType = 6 object daField21: 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 daField20: 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