ReportName = Demo Cross Tab ReportGroup = Maintenance object ppReport1: TppReport NoDataBehaviors = [ndBlankReport] PassSetting = psTwoPass PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Demo Cross Tab' PrinterSetup.PaperName = 'Letter' PrinterSetup.PrinterName = 'Default' PrinterSetup.mmMarginBottom = 6350 PrinterSetup.mmMarginLeft = 6350 PrinterSetup.mmMarginRight = 6350 PrinterSetup.mmMarginTop = 6350 PrinterSetup.mmPaperHeight = 279401 PrinterSetup.mmPaperWidth = 215900 PrinterSetup.PaperSize = 1 SaveAsTemplate = True Template.DatabaseSettings.DataPipeline = dpReports Template.DatabaseSettings.Name = 'Demo Cross Tab' Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.FileName = 'Demo Cross Tab.rtm' Template.SaveTo = stDatabase Template.Format = ftASCII AllowPrintToFile = True DeviceType = 'Screen' EmailSettings.ReportFormat = 'PDF' EmailSettings.Enabled = True EmailSettings.PreviewInEmailClient = False EmailSettings.ShowEmailDialog = True OutlineSettings.CreateNode = True OutlineSettings.CreatePageNodes = True OutlineSettings.Enabled = False OutlineSettings.Visible = True PreviewFormSettings.ZoomSetting = zs100Percent SavePrinterSetup = True ShowAutoSearchDialog = True TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = True Left = 218 Top = 155 Version = '10.04' mmColumnWidth = 0 object ppHeaderBand1: TppHeaderBand PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 14817 mmPrintPosition = 0 object ppLabel1: TppLabel UserName = 'Label1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'System Codes' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'ARIAL' Font.Size = 16 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 6562 mmLeft = 1323 mmTop = 1323 mmWidth = 38777 BandType = 0 end object ppRichText1: TppRichText UserName = 'RichText1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'RichText1' RichText = '{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcha' + 'rset0 MS Sans Serif;}{\f1\fnil MS Sans Serif;}}'#13#10'\viewkind4\uc1\' + 'pard\f0\fs16 This report demonstrate the use of a Cross Tab comp' + 'onenet in a report. Right click on the CrossTab1 component and ' + 'then click on Configure to see setup.\f1\par'#13#10'}'#13#10 mmHeight = 8731 mmLeft = 46567 mmTop = 2117 mmWidth = 152665 BandType = 0 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 end end object ppDetailBand1: TppDetailBand PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 5292 mmPrintPosition = 0 object ppCrossTab1: TppCrossTab UserName = 'CrossTab1' DataPipeline = daADOQueryDataView1.Codes ParentDataPipeline = False Stretch = True Style = 'Standard' DataPipelineName = 'Codes' mmHeight = 5027 mmLeft = 0 mmTop = 0 mmWidth = 203200 BandType = 4 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 object TppGrandTotal ChildType = 6 object TppTotalCaptionDef ChildType = 4 Alignment = taRightJustify Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [] end object TppTotalDef ChildType = 3 Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [] end end object TppGrandTotal ChildType = 7 object TppTotalCaptionDef ChildType = 4 Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [] end object TppTotalDef ChildType = 3 Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [] end end object TppRowDef ChildType = 1 FieldAlias = 'CodeType' FieldName = 'CodeType' Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [] object TppSubTotal ChildType = 5 object TppTotalCaptionDef ChildType = 4 Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [] end object TppTotalDef ChildType = 3 Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [] end end end object TppRowDef ChildType = 1 FieldAlias = 'Code' FieldName = 'Code' Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [] object TppSubTotal ChildType = 5 object TppTotalCaptionDef ChildType = 4 Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [] end object TppTotalDef ChildType = 3 Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [] end end end object TppValueDef ChildType = 2 FieldAlias = 'Code' FieldName = 'Code' Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [] object TppValueCaptionDef ChildType = 8 CalcType = dcCount Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [] end end end end object ppFooterBand1: TppFooterBand mmBottomOffset = 0 mmHeight = 5556 mmPrintPosition = 0 object ppSystemVariable2: TppSystemVariable UserName = 'SystemVariable2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False VarType = vtPageSetDesc Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 4149 mmLeft = 186002 mmTop = 1323 mmWidth = 16002 BandType = 8 end end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_Codes' Height = 126 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 200 AutoSearchTabOrder = 0 object Codes: TppChildDBPipeline AutoCreateFields = False UserName = 'Codes' object ppField1: TppField FieldAlias = 'CodeType' FieldName = 'CodeType' FieldLength = 25 DisplayWidth = 25 Position = 0 TableName = 'Codes' end object ppField2: TppField FieldAlias = 'Code' FieldName = 'Code' FieldLength = 25 DisplayWidth = 25 Position = 1 TableName = 'Codes' end end object daSQL1: TdaSQL GuidCollationType = gcMSSQLServer DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'Codes' LinkColor = clMaroon MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Codes.CodeType, Codes.Code' 'FROM Codes Codes' 'ORDER BY Codes.CodeType, Codes.Code') SQLType = sqSQL2 object daField1: TdaField Alias = 'CodeType' DisplayWidth = 25 FieldAlias = 'CodeType' FieldLength = 25 FieldName = 'CodeType' SQLFieldName = 'CodeType' TableAlias = 'Codes' TableName = 'Codes' TableSQLAlias = 'Codes' end object daField2: TdaField Alias = 'Code' DisplayWidth = 25 FieldAlias = 'Code' FieldLength = 25 FieldName = 'Code' SQLFieldName = 'Code' TableAlias = 'Codes' TableName = 'Codes' TableSQLAlias = 'Codes' end object daField3: TdaField ChildType = 2 Alias = 'CodeType' DisplayWidth = 25 FieldAlias = 'CodeType' FieldLength = 25 FieldName = 'CodeType' SQLFieldName = 'CodeType' TableAlias = 'Codes' TableName = 'Codes' TableSQLAlias = 'Codes' end object daField4: TdaField ChildType = 2 Alias = 'Code' DisplayWidth = 25 FieldAlias = 'Code' FieldLength = 25 FieldName = 'Code' SQLFieldName = 'Code' TableAlias = 'Codes' TableName = 'Codes' TableSQLAlias = 'Codes' end object daTable1: TdaTable ChildType = 5 Alias = 'Codes' JoinType = dajtNone SQLAlias = 'Codes' TableAlias = 'Codes' TableName = 'Codes' end end end end object ppParameterList1: TppParameterList end end