Report File: Employee Profile.rpt Report File DateTime: 03-Feb-2001 at 15:06:42 Report Miner, Version 1.4 - Copyright 1999-2000, The Retsel Group Report Summary Information Title = Employee Profile (Alphabetical with Employee Picture) Author = © 2000 Seagate Software, Inc. Keywords = Comments = Employee Profile with employee picture, listed alphabetically by employee last name. Subject = Human Resources Reports Template = Crystal Reports Version = 7.0/8.0 Report Statistics Last Saved By = © 2000 Seagate Software, Inc. Revision Number = 42 Total Edit Time = 6:41:52 Last Printed = 06-Aug-1997 17:44:27 Created = 13-Aug-1996 02:50:47 Last Saved = 04-Dec-2000 19:11:28 Report Options Convert date-time to = Date Preview pages start with = Full Size Convert null field value to default = False Translate DOS strings = True Translate DOS memos = True Save data with report = True Save summaries with report = True Suppress printing if no records = False Show all headers on drill down = False Use indexes on server for speed = False Save data with report = True More report engine error messages = False Case-insensitive SQL data = False Select distinct data for browsing = True Perform query asynchronously = False Create group tree = True Can Perform Grouping on Server = Field Mapping Type = Auto Field Mapping Formula Syntax = Crystal Page Setup Top Margin = 1 Bottom Margin = 0.5 Left Margin = 0.5 Right Margin = 0.5 Field Mapping Type = Auto Field Mapping Formula Syntax = Crystal Printer Details Printer Name = Printer Driver = Printer Port = Printer Duplex Option = Default Paper Orientation = DefaultOrientation Paper Size = DefaultPaperSize Paper Source = Auto Total Number of Pages = Export Details Export Destination Type = No Destination Primary Report Report Layout User Formulas Name, Formula @reports to, if IsNull({Reports to.Employee ID}) then "" else {Reports to.First Name} + " " + {Reports to.Last Name} @name, {Employee.Last Name} + ", " + {Employee.First Name} @first letter, {Employee.Last Name}[1] @home address city/region, if IsNull({Employee Addresses.Region}) then {Employee Addresses.City} else {Employee Addresses.City} + ", " + {Employee Addresses.Region} @home phone, if length({Employee.Home Phone})=10 then "(" + {Employee.Home Phone}[1 to 3] + ") " + {Employee.Home Phone}[4 to 6] + "-" + {Employee.Home Phone}[7 to 10] else {Employee.Home Phone}[1 to 3] + "-" + {Employee.Home Phone}[4 to 7] Groups Group, Field Group #1, {@first letter}, Any Value,Ascending Group #2, {@name}, Any Value,Ascending SQL Query SELECT Employee.`Last Name`, Employee.`First Name`, Employee.`Position`, Employee.`Birth Date`, Employee.`Home Phone`, Employee.`Extension`, Employee.`Photo`, Employee.`Notes`, Employee_Addresses.`Address1`, Employee_Addresses.`Address2`, Employee_Addresses.`City`, Employee_Addresses.`Region`, Employee_Addresses.`Country`, Employee_Addresses.`Postal Code` FROM `Employee` Employee INNER JOIN `Employee Addresses` Employee_Addresses ON Employee.`Employee ID` = Employee_Addresses.`Employee ID` Tables Table, Alias, Location, Driver Employee, Employee, C:\Program Files\Seagate Software\Crystal Reports\Samples\Databases\xtreme, pdsodbc.dll Employee Addresses, Employee Addresses, C:\Program Files\Seagate Software\Crystal Reports\Samples\Databases\xtreme, pdsodbc.dll Sections Report Header Height = 1, Keep Together Name, Location(LxT), Size (WxH), Type, Contents, Suppress 1, Ole Object: Position=(4.42, 0.05), Size=(2.85 x 0.77) , X Scaling = 75%, Y Scaling = 75%, Orig Size = 3.8 x 1.03, ToolTipText=Formula, Hyperlink=http://www.seagatesoftware.com Formulas for this object: Tool Tip Text = "New Hyperlinking feature allows you to link to web sites, other reports, subreports and more!" 2, Text: ("Employee Profiles"), Position=(0.02, 0), Size=(3.56 x 0.34) , Alignment=Left, Font=Arial, 20, Bold, Italics, Custom: R(191), G(165), B(125), Close border on break, Keep Together, Data type=String, Line Spacing Type = Multiple Spacing 3, Line: Position=(0.02, 0.5), Size=(4.33 x 0) , Color = Black, Thickness = 30, Extend to Bottom of Section = False 4, Spec Var: (PrintDate), Position=(0, 0.58), Size=(0.75 x 0.15) , Alignment=Default, Font=Arial, 10, Black, Close border on break, Keep Together, Data type=Date, Date format = Windows Short date format, Line Spacing Type = Multiple Spacing 5, Spec Var: (PrintTime), Position=(0.75, 0.58), Size=(0.75 x 0.15) , Alignment=Default, Font=Arial, 10, Black, Close border on break, Keep Together, Data type=Time, Clock=12 Hour, AM Symbol="AM", PM Symbol="PM", AM-PM Position=After, Hour format=Show leading zero, Minute format=Suppress leading zero, Second format=Suppress leading zero, Line Spacing Type = Multiple Spacing Page Header Suppressed based on formula, Height = 0.3, Keep Together No objects in this section. Group Header 1 Suppressed, Height = 0.4, Keep Together No objects in this section. Group Header 2 Height = 0.3, Keep Together, Background Color=Custom: R(0), G(102), B(102) Name, Location(LxT), Size (WxH), Type, Contents, Suppress 6, Group Name: (GroupName ({@name})), Position=(0.24, 0.06), Size=(2.89 x 0.2) , Alignment=Default, Border=None, (BGColor=Custom: R(0), G(102), B(102)), Style=None, Font=Arial, 12, Bold, White Can Grow, Max lines=0, Close border on break, Keep Together, Data type=String, Line Spacing Type = Multiple Spacing Detaila Height = 2.6, Keep Together, Background Color=Formula Name, Location(LxT), Size (WxH), Type, Contents, Suppress 7, Text: ("[Employee.First Name] [Employee.Last Name] "), Position=(3.5, 0.25), Size=(2.02 x 0.17) , Alignment=Left, Border=None, (BGColor=White), Style=None, Font=Arial, 10, Black Can Grow, Max lines=0, Close border on break, Keep Together, Data type=String, Line Spacing Type = Multiple Spacing 7.1 Embedded Field: Text = 'Employee.First Name', Font = Arial, Size = 10, Style = Regular, Color = Black, Spacing = 0, Underline = False, Strikeout = False 7.2 Embedded Field: Text = ' ', Font = Arial, Size = 10, Style = Regular, Color = Black, Spacing = 0, Underline = False, Strikeout = False 7.3 Embedded Field: Text = 'Employee.Last Name', Font = Arial, Size = 10, Style = Regular, Color = Black, Spacing = 0, Underline = False, Strikeout = False 7.4 Embedded Field: Text = ' ', Font = Arial, Size = 10, Style = Regular, Color = Black, Spacing = 0, Underline = False, Strikeout = False 8, Text: ("Position:"), Position=(2.5, 0.55), Size=(0.91 x 0.2) , Alignment=Left, Border=None, (BGColor=White), Style=None, Font=Arial, 12, Bold, Custom: R(0), G(102), B(102), Close border on break, Keep Together, Data type=String, Line Spacing Type = Multiple Spacing 9, Field: ({Employee.Position}), Position=(3.5, 0.61), Size=(2.02 x 0.17) , Alignment=Left, Border=None, (BGColor=White), Style=None, Font=Arial, 10, Black Can Grow, Max lines=0, Close border on break, Keep Together, Data type=String, Line Spacing Type = Multiple Spacing 10, Text: ("Extension:"), Position=(2.5, 0.97), Size=(0.92 x 0.2) , Alignment=Left, Border=None, (BGColor=White), Style=None, Font=Arial, 12, Bold, Custom: R(0), G(102), B(102), Close border on break, Keep Together, Data type=String, Line Spacing Type = Multiple Spacing 11, Field: ({Employee.Extension}), Position=(3.5, 0.97), Size=(0.76 x 0.17) , Alignment=Left, Border=None, (BGColor=White), Style=None, Font=Arial, 10, Black Can Grow, Max lines=0, Close border on break, Keep Together, Data type=String, Line Spacing Type = Multiple Spacing 12, Text: ("Birthdate:"), Position=(2.5, 1.34), Size=(0.92 x 0.2) , Alignment=Left, Border=None, (BGColor=White), Style=None, Font=Arial, 12, Bold, Custom: R(0), G(102), B(102), Close border on break, Keep Together, Data type=String, Line Spacing Type = Multiple Spacing 13, Field: ({Employee.Birth Date}), Position=(3.5, 1.33), Size=(0.76 x 0.17) , Alignment=Left, Border=None, (BGColor=White), Style=None, Font=Arial, 10, Black Can Grow, Max lines=0, Close border on break, Keep Together, Data type=Date, Date format = Windows Short date format, Line Spacing Type = Multiple Spacing 14, Text: ("Home Phone:"), Position=(5.67, 1.71), Size=(0.77 x 0.39) , Alignment=Left, Border=None, (BGColor=White), Style=None, Font=Arial, 12, Bold, Custom: R(0), G(102), B(102) Can Grow, Max lines=0, Close border on break, Keep Together, Data type=String, Line Spacing Type = Multiple Spacing 15, Text: ("[Employee Addresses.Address1] [Employee Addresses.Address2] [@home address city/region] [Employee Addresses.Country] [Employee Addresses.Postal Code] "), Position=(3.5, 1.71), Size=(2.01 x 0.84) , Alignment=Left, Border=None, (BGColor=White), Style=None, Font=Arial, 10, Black Can Grow, Max lines=0, Close border on break, Keep Together, Data type=String, Line Spacing Type = Multiple Spacing 15.1 Embedded Field: Text = 'Employee Addresses.Address1', Font = Arial, Size = 10, Style = Regular, Color = Black, Spacing = 0, Underline = False, Strikeout = False 15.2 Embedded Field: Text = ' ', Font = Arial, Size = 10, Style = Regular, Color = Black, Spacing = 0, Underline = False, Strikeout = False 15.3 Embedded Field: Text = 'Employee Addresses.Address2', Font = Arial, Size = 10, Style = Regular, Color = Black, Spacing = 0, Underline = False, Strikeout = False 15.4 Embedded Field: Text = ' ', Font = Arial, Size = 10, Style = Regular, Color = Black, Spacing = 0, Underline = False, Strikeout = False 15.5 Embedded Field: Text = '@home address city/region', Font = Arial, Size = 10, Style = Regular, Color = Black, Spacing = 0, Underline = False, Strikeout = False 15.6 Embedded Field: Text = ' ', Font = Arial, Size = 10, Style = Regular, Color = Black, Spacing = 0, Underline = False, Strikeout = False 15.7 Embedded Field: Text = 'Employee Addresses.Country', Font = Arial, Size = 10, Style = Regular, Color = Black, Spacing = 0, Underline = False, Strikeout = False 15.8 Embedded Field: Text = ' ', Font = Arial, Size = 10, Style = Regular, Color = Black, Spacing = 0, Underline = False, Strikeout = False 15.9 Embedded Field: Text = 'Employee Addresses.Postal Code', Font = Arial, Size = 10, Style = Regular, Color = Black, Spacing = 0, Underline = False, Strikeout = False 15.10 Embedded Field: Text = ' ', Font = Arial, Size = 10, Style = Regular, Color = Black, Spacing = 0, Underline = False, Strikeout = False 16, Formula: ({@home phone}), Position=(5.67, 2.21), Size=(1.09 x 0.17) , Alignment=Left, Border=None, (BGColor=White), Style=None, Font=Arial, 10, Black Can Grow, Max lines=0, Close border on break, Keep Together, Data type=String, Line Spacing Type = Multiple Spacing 17, Text: ("Home ^Address:^"), Position=(2.5, 1.7), Size=(0.92 x 0.4) , Alignment=Left, Border=None, (BGColor=White), Style=None, Font=Arial, 12, Bold, Custom: R(0), G(102), B(102), Close border on break, Keep Together, Data type=String, Line Spacing Type = Multiple Spacing 18, Text: ("Name:"), Position=(2.5, 0.22), Size=(0.91 x 0.2) , Alignment=Left, Border=None, (BGColor=White), Style=None, Font=Arial, 12, Bold, Custom: R(0), G(102), B(102), Close border on break, Keep Together, Data type=String, Line Spacing Type = Multiple Spacing 19, Blob Object: ({Employee.Photo}), Position=(0.24, 0.12), Size=(2 x 2.32) , X Scaling = 100%, Y Scaling = 100% Detailb Height = 0.7, Keep Together, Background Color=Formula Name, Location(LxT), Size (WxH), Type, Contents, Suppress 20, Field: ({Employee.Notes}), Position=(0.9, 0.29), Size=(6.41 x 0.16) , Alignment=Default, Border=Single, Black, (BGColor=White), Style=Single, Font=Arial, 10, Black Can Grow, Max lines=0, Close border on break, Keep Together, Data type=Memo, Line Spacing Type = Multiple Spacing 21, Text: ("Notes:"), Position=(0.24, 0.3), Size=(0.53 x 0.18) , Alignment=Left, Border=None, (BGColor=White), Style=None, Font=Arial, 12, Bold, Custom: R(0), G(102), B(102), Close border on break, Keep Together, Data type=String, Line Spacing Type = Multiple Spacing 22, Line: Position=(2.48, 0.12), Size=(5.02 x 0) , Color = Custom: R(0), G(102), B(102), Thickness = 20, Extend to Bottom of Section = False Detailc Height = 0.2, Keep Together, Background Color=Formula No objects in this section. Group Footer 2 Height = 0.1, Keep Together No objects in this section. Group Footer 1 Suppressed, Height = 0.2, Keep Together No objects in this section. Report Footer Suppressed, Height = 0.3, Keep Together No objects in this section. Page Footer Height = 0.6, Keep Together Name, Location(LxT), Size (WxH), Type, Contents, Suppress 23, Spec Var: (PageNumber), Position=(6.82, 0.34), Size=(0.61 x 0.16) , Alignment=Right, Font=Arial, 10, Black, Close border on break, Keep Together, Data type=Integer, Show negatives as=Leading Minus, No thousands separator, Show leading zeros, Show zero as , Decimals=0, Round to 0 Decimals, Currency position=Leading Inside Negative, Currency symbol type ="None", Line Spacing Type = Multiple Spacing 24, Line: Position=(0.01, 0.02), Size=(7.49 x 0) , Color = Black, Thickness = 30, Extend to Bottom of Section = False 25, Text: ("Feedback on Samples by E-mail"), Position=(5.18, 0.09), Size=(2.25 x 0.16) , Alignment=Right, Font=Arial, 10, Blue, Close border on break, Keep Together, Data type=String, Line Spacing Type = Multiple Spacing, Hyperlink=mailto: feedbackSCR@seagatesoftware.com 26, Text: ("Seagate Software Support Site"), Position=(2.08, 0.08), Size=(3.5 x 0.19) , Alignment=Left, Font=Arial, 11, Blue, Close border on break, Keep Together, Data type=String, Line Spacing Type = Multiple Spacing, ToolTipText=Formula, Hyperlink=http://support.seagatesoftware.com Formulas for this object: Tool Tip Text = "Visit the Support Site for samples, web forums, tutorials, technical briefs and more!" 27, Text: ("© Copyright 2000 Seagate Software, Inc. All Rights Reserved."), Position=(2.08, 0.33), Size=(3.58 x 0.18) , Alignment=Left, Font=Arial, 10, Custom: R(102), G(153), B(204), Close border on break, Keep Together, Data type=String, Line Spacing Type = Multiple Spacing 28, Ole Object: Position=(0, 0), Size=(2.08 x 0.52) , X Scaling = 100%, Y Scaling = 100%, Hyperlink=http://www.seagatesoftware.com/ Formulas for this object: Tool Tip Text = "New Hyperlinking feature allows you to link to web sites, other reports, subreports and more!"