ReportName = Requests List By Requestor ReportGroup = Maintenance object ppReport1: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.Requests NoDataBehaviors = [ndBlankReport] PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Requests List By Requester' PrinterSetup.PaperName = 'Letter' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False 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 = 'Requests List By Requester' Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.FileName = 'Requests List By Requester.rtm' Template.SaveTo = stDatabase Template.Format = ftASCII AllowPrintToArchive = True AllowPrintToFile = True DeviceType = 'Screen' DefaultFileDeviceType = 'PDF' EmailSettings.ReportFormat = 'PDF' EmailSettings.Enabled = True LanguageID = 'Default' OutlineSettings.CreateNode = True OutlineSettings.CreatePageNodes = True OutlineSettings.Enabled = False OutlineSettings.Visible = False PDFSettings.EmbedFontOptions = [efUseSubset] PDFSettings.EncryptSettings.AllowCopy = True PDFSettings.EncryptSettings.AllowInteract = True PDFSettings.EncryptSettings.AllowModify = True PDFSettings.EncryptSettings.AllowPrint = True PDFSettings.EncryptSettings.Enabled = False PDFSettings.FontEncoding = feAnsi PreviewFormSettings.ZoomSetting = zs100Percent RTFSettings.DefaultFont.Charset = DEFAULT_CHARSET RTFSettings.DefaultFont.Color = clWindowText RTFSettings.DefaultFont.Height = -13 RTFSettings.DefaultFont.Name = 'Arial' RTFSettings.DefaultFont.Style = [] SavePrinterSetup = True TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = True TextSearchSettings.Visible = True Left = 218 Top = 155 Version = '12.0' mmColumnWidth = 0 DataPipelineName = 'Requests' object ppTitleBand1: TppTitleBand mmBottomOffset = 0 mmHeight = 12435 mmPrintPosition = 0 object ppLabel1: TppLabel UserName = 'Label1' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Maintenance Request List By Requester' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 16 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 6562 mmLeft = 1323 mmTop = 794 mmWidth = 93007 BandType = 1 end object ppDBText8: TppDBText UserName = 'DBText8' HyperlinkColor = clBlue AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'CompanyName' DataPipeline = dpCompanyInfo Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 16 Font.Style = [fsBold, fsItalic] ParentDataPipeline = False TextAlignment = taRightJustified Transparent = True DataPipelineName = 'dpCompanyInfo' mmHeight = 6562 mmLeft = 171419 mmTop = 794 mmWidth = 30988 BandType = 1 end object ppLabel7: TppLabel UserName = 'Params' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'CompletedDate: 1/4/2011, 1/4/2011' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 4149 mmLeft = 1323 mmTop = 7938 mmWidth = 50927 BandType = 1 end end object ppDetailBand1: TppDetailBand Background1.Brush.Style = bsClear Background1.Gradient.EndColor = clWhite Background1.Gradient.StartColor = clWhite Background1.Gradient.Style = gsNone Background2.Brush.Style = bsClear Background2.Gradient.EndColor = clWhite Background2.Gradient.StartColor = clWhite Background2.Gradient.Style = gsNone mmBottomOffset = 0 mmHeight = 5292 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'DBText1' HyperlinkColor = clBlue AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'DateRequested' DataPipeline = daADOQueryDataView1.Requests Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Requests' mmHeight = 3260 mmLeft = 20902 mmTop = 1323 mmWidth = 30988 BandType = 4 end object ppDBText2: TppDBText UserName = 'DBText2' HyperlinkColor = clBlue AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'DateDesired' DataPipeline = daADOQueryDataView1.Requests Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Requests' mmHeight = 3260 mmLeft = 48154 mmTop = 1323 mmWidth = 14139 BandType = 4 end object ppDBText4: TppDBText UserName = 'DBText4' HyperlinkColor = clBlue AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'RecordNumber' DataPipeline = daADOQueryDataView1.Requests Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Requests' mmHeight = 3260 mmLeft = 80740 mmTop = 1323 mmWidth = 3133 BandType = 4 end object ppDBText5: TppDBText UserName = 'DBText5' HyperlinkColor = clBlue AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'UnitName' DataPipeline = daADOQueryDataView1.Requests Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Requests' mmHeight = 3260 mmLeft = 85725 mmTop = 1323 mmWidth = 17865 BandType = 4 end object ppDBText6: TppDBText UserName = 'DBText6' HyperlinkColor = clBlue AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Status' DataPipeline = daADOQueryDataView1.Requests Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Requests' mmHeight = 3260 mmLeft = 4498 mmTop = 1323 mmWidth = 12827 BandType = 4 end object ppDBText3: TppDBText UserName = 'DBText3' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'CompletedDate' DataPipeline = daADOQueryDataView1.Requests DisplayFormat = 'm/d/yy h:nn:ss AM/PM' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Requests' mmHeight = 3260 mmLeft = 141817 mmTop = 1323 mmWidth = 55298 BandType = 4 end end object ppFooterBand1: TppFooterBand mmBottomOffset = 0 mmHeight = 7144 mmPrintPosition = 0 object ppLine2: TppLine UserName = 'Line2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Pen.Color = clGray Pen.Width = 2 Weight = 1.500000000000000000 mmHeight = 3969 mmLeft = 1323 mmTop = 5821 mmWidth = 200555 BandType = 8 end object ppSystemVariable1: TppSystemVariable UserName = 'SystemVariable1' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False VarType = vtPrintDateTime Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 4487 mmLeft = 1323 mmTop = 1323 mmWidth = 17187 BandType = 8 end object ppSystemVariable2: TppSystemVariable UserName = 'SystemVariable2' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False VarType = vtPageNoDesc Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 4487 mmLeft = 184680 mmTop = 1323 mmWidth = 17187 BandType = 8 end end object ppSummaryBand1: TppSummaryBand AlignToBottom = False mmBottomOffset = 0 mmHeight = 6879 mmPrintPosition = 0 object ppDBCalc2: TppDBCalc UserName = 'DBCalc2' HyperlinkColor = clBlue AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'RecordNumber' DataPipeline = daADOQueryDataView1.Requests DisplayFormat = 'Total Number of Records: ######0' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clBlue Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [] Transparent = True DBCalcType = dcCount DataPipelineName = 'Requests' mmHeight = 4149 mmLeft = 1852 mmTop = 2117 mmWidth = 32597 BandType = 7 end end object ppGroup1: TppGroup BreakName = 'Requester' DataPipeline = daADOQueryDataView1.Requests GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False OutlineSettings.CreateNode = True StartOnOddPage = False UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'Requests' NewFile = False object ppGroupHeaderBand1: TppGroupHeaderBand mmBottomOffset = 0 mmHeight = 14817 mmPrintPosition = 0 object ppDBText7: TppDBText UserName = 'DBText7' HyperlinkColor = clBlue AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Requester' DataPipeline = daADOQueryDataView1.Requests Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clBlue Font.Name = 'ARIAL' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True DataPipelineName = 'Requests' mmHeight = 4572 mmLeft = 794 mmTop = 2117 mmWidth = 21378 BandType = 3 GroupNo = 0 end object ppLabel2: TppLabel UserName = 'Label2' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Date Requested' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4498 mmLeft = 20902 mmTop = 8731 mmWidth = 25135 BandType = 3 GroupNo = 0 end object ppLine1: TppLine UserName = 'Line1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Pen.Color = clNavy Pen.Width = 2 Weight = 1.500000000000000000 mmHeight = 794 mmLeft = 1588 mmTop = 13758 mmWidth = 200555 BandType = 3 GroupNo = 0 end object ppLabel5: TppLabel UserName = 'Label5' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Number' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 4498 mmLeft = 70644 mmTop = 8731 mmWidth = 13229 BandType = 3 GroupNo = 0 end object ppLabel4: TppLabel UserName = 'Label4' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Status' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4498 mmLeft = 4498 mmTop = 8731 mmWidth = 10054 BandType = 3 GroupNo = 0 end object ppLabel3: TppLabel UserName = 'Label3' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Date Desired' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4498 mmLeft = 48154 mmTop = 8731 mmWidth = 20902 BandType = 3 GroupNo = 0 end object ppLabel6: TppLabel UserName = 'Label6' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Unit Name' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4498 mmLeft = 85725 mmTop = 8731 mmWidth = 17727 BandType = 3 GroupNo = 0 end object ppLabel8: TppLabel UserName = 'Label7' HyperlinkColor = clBlue Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Completed Date' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4530 mmLeft = 141817 mmTop = 8731 mmWidth = 25739 BandType = 3 GroupNo = 0 end end object ppGroupFooterBand1: TppGroupFooterBand HideWhenOneDetail = False mmBottomOffset = 0 mmHeight = 5821 mmPrintPosition = 0 object ppDBCalc1: TppDBCalc UserName = 'DBCalc1' HyperlinkColor = clBlue AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'RecordNumber' DataPipeline = daADOQueryDataView1.Requests DisplayFormat = 'Records This Status: ######0' Ellipsis = False Font.Charset = DEFAULT_CHARSET Font.Color = clBlue Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [] ResetGroup = ppGroup1 Transparent = True DBCalcType = dcCount DataPipelineName = 'Requests' mmHeight = 4149 mmLeft = 3175 mmTop = 794 mmWidth = 32597 BandType = 5 GroupNo = 0 end end end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_Requests' Height = 211 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 200 AutoSearchTabOrder = 0 object Requests: TppChildDBPipeline AutoCreateFields = False UserName = 'Requests' object ppField1: TppField FieldAlias = 'DateRequested' FieldName = 'DateRequested' FieldLength = 0 DataType = dtDateTime DisplayWidth = 0 Position = 0 TableName = 'Requests' end object ppField2: TppField FieldAlias = 'DateDesired' FieldName = 'DateDesired' FieldLength = 0 DataType = dtDateTime DisplayWidth = 0 Position = 1 TableName = 'Requests' end object ppField3: TppField FieldAlias = 'Requester' FieldName = 'Requester' FieldLength = 35 DisplayWidth = 35 Position = 2 TableName = 'Requests' end object ppField4: TppField FieldAlias = 'RecordNumber' FieldName = 'RecordNumber' FieldLength = 0 DataType = dtDouble DisplayWidth = 0 Position = 3 TableName = 'Requests' end object ppField5: TppField FieldAlias = 'UnitName' FieldName = 'UnitName' FieldLength = 80 DisplayWidth = 80 Position = 4 TableName = 'Requests' end object ppField6: TppField FieldAlias = 'Service' FieldName = 'Service' FieldLength = 50 DisplayWidth = 50 Position = 5 TableName = 'Requests' end object ppField7: TppField FieldAlias = 'Status' FieldName = 'Status' FieldLength = 15 DisplayWidth = 15 Position = 6 TableName = 'Requests' end object ppField8: TppField FieldAlias = 'CompletedDate' FieldName = 'CompletedDate' FieldLength = 0 DataType = dtDateTime DisplayWidth = 10 Position = 7 TableName = 'Requests' end end object daSQL1: TdaSQL GuidCollationType = gcMSSQLServer DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'Requests' LinkColor = clMaroon LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Requests.DateRequested, ' ' Requests.DateDesired, Requests.Requester, ' ' Requests.RecordNumber, Requests.UnitName, ' ' Requests.Service, Requests.Status, ' ' Requests.CompletedDate' 'FROM Requests Requests' 'WHERE ('#39'c'#39' <> '#39'c'#39' ) AND (' ' ( Requests.DateRequested BETWEEN CONVERT(DATETIME,'#39'2009-10' + '-30 00:01:01'#39',120) AND CONVERT(DATETIME,'#39'2009-10-30 23:59:59'#39',12' + '0) )' ' )') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Operator = dacoBetween Value = '10/30/2009 12:01:01 AM,10/30/2009 11:59:59 PM' object TdaField Alias = 'DateRequested' DataType = dtDateTime DisplayWidth = 10 FieldAlias = 'DateRequested' FieldLength = 10 FieldName = 'DateRequested' SQLFieldName = 'DateRequested' TableAlias = 'Requests' TableName = 'Requests' TableSQLAlias = 'Requests' end object TdaNumericValue Value = 40116.000706018520000000 end object TdaNumericValue Value = 40116.999988425920000000 end end object daField1: TdaField Alias = 'DateRequested' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'DateRequested' FieldLength = 0 FieldName = 'DateRequested' SQLFieldName = 'DateRequested' TableAlias = 'Requests' TableName = 'Requests' TableSQLAlias = 'Requests' end object daField2: TdaField Alias = 'DateDesired' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'DateDesired' FieldLength = 0 FieldName = 'DateDesired' SQLFieldName = 'DateDesired' TableAlias = 'Requests' TableName = 'Requests' TableSQLAlias = 'Requests' end object daField3: TdaField Alias = 'Requester' DisplayWidth = 35 FieldAlias = 'Requester' FieldLength = 35 FieldName = 'Requester' SQLFieldName = 'Requester' TableAlias = 'Requests' TableName = 'Requests' TableSQLAlias = 'Requests' end object daField4: TdaField Alias = 'RecordNumber' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'RecordNumber' FieldLength = 0 FieldName = 'RecordNumber' SQLFieldName = 'RecordNumber' TableAlias = 'Requests' TableName = 'Requests' TableSQLAlias = 'Requests' end object daField5: TdaField Alias = 'UnitName' DisplayWidth = 80 FieldAlias = 'UnitName' FieldLength = 80 FieldName = 'UnitName' SQLFieldName = 'UnitName' TableAlias = 'Requests' TableName = 'Requests' TableSQLAlias = 'Requests' end object daField6: TdaField Alias = 'Service' DisplayWidth = 50 FieldAlias = 'Service' FieldLength = 50 FieldName = 'Service' SQLFieldName = 'Service' TableAlias = 'Requests' TableName = 'Requests' TableSQLAlias = 'Requests' end object daField7: TdaField Alias = 'Status' DisplayWidth = 15 FieldAlias = 'Status' FieldLength = 15 FieldName = 'Status' SQLFieldName = 'Status' TableAlias = 'Requests' TableName = 'Requests' TableSQLAlias = 'Requests' end object daField8: TdaField Alias = 'CompletedDate' DataType = dtDateTime DisplayWidth = 10 FieldAlias = 'CompletedDate' FieldLength = 0 FieldName = 'CompletedDate' SQLFieldName = 'CompletedDate' TableAlias = 'Requests' TableName = 'Requests' TableSQLAlias = 'Requests' end object daField9: TdaField ChildType = 2 Alias = 'Requester' DisplayWidth = 35 FieldAlias = 'Requester' FieldLength = 35 FieldName = 'Requester' SQLFieldName = 'Requester' TableAlias = 'Requests' TableName = 'Requests' TableSQLAlias = 'Requests' end object daField10: TdaField ChildType = 2 Alias = 'Status' Ascending = False DisplayWidth = 15 FieldAlias = 'Status' FieldLength = 15 FieldName = 'Status' SQLFieldName = 'Status' TableAlias = 'Requests' TableName = 'Requests' TableSQLAlias = 'Requests' end object daField11: TdaField ChildType = 2 Alias = 'DateRequested' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'DateRequested' FieldLength = 0 FieldName = 'DateRequested' SQLFieldName = 'DateRequested' TableAlias = 'Requests' TableName = 'Requests' TableSQLAlias = 'Requests' end object daField12: TdaField ChildType = 2 Alias = 'RecordNumber' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'RecordNumber' FieldLength = 0 FieldName = 'RecordNumber' SQLFieldName = 'RecordNumber' TableAlias = 'Requests' TableName = 'Requests' TableSQLAlias = 'Requests' end object daTable1: TdaTable ChildType = 5 Alias = 'Requests' JoinType = dajtNone SQLAlias = 'Requests' TableAlias = 'Requests' TableName = 'Requests' end end end end object ppParameterList1: TppParameterList end end