**************************************************************************** Location : Local or Network Folders Host : FINDITEZ-T460P Path : C:\Users\ken\Documents\Test Cases\SSRS\Employee Profile Subreport.rpt **************************************************************************** Report Information Version: 11.0 Author: Copyright © 2004 Business Objects Comments: Employee Profile with employee picture, listed alphabetically by employee last name. Title: Employee Profile (Alphabetical with Employee Picture) Subject: Human Resources Reports Printer: No Printer Main Body Data Sources Source: Connection #1 Database DLL: crdb_odbc.dll Database Type: ODBC (RDO) Server: Xtreme Sample Database 11.5 Properties: QE_LogonProperties DSN: Xtreme Sample Database 11.5 UseDSNProperties: False QE_SQLDB: True SSO Enabled: False Tables Table: Employee Connection: Connection #1 Used Columns: {Employee.Employee ID} : Number {Employee.Last Name} : String[42] {Employee.First Name} : String[22] {Employee.Position} : String[62] {Employee.Birth Date} : Date {Employee.Home Phone} : String[42] {Employee.Extension} : String[10] {Employee.Photo} : Unknown {Employee.Notes} : Unknown Table: Employee Addresses Connection: Connection #1 Report Alias: Employee_Addresses Table Links Joins: Employee INNER JOIN [Employee Addresses] Employee_Addresses ON Employee.[Employee ID] = Employee_Addresses.[Employee ID] Record Sorting Sort By: @first letter -- Ascending Order Group #1 @name -- Ascending Order Group #2 Formula Fields Field: name Formula: {Employee.Last Name} + ", " + {Employee.First Name} Field: first letter Formula: {Employee.Last Name}[1] Unused Formula Fields Field: home address city/region Formula: if IsNull({Employee_Addresses.Region}) then {Employee_Addresses.City} else {Employee_Addresses.City} + ", " + {Employee_Addresses.Region} Report Header Section: Section a Fields Field: Field1 Data Source: PrintDate Data Type: Date Format: Date and Time Order: Date Time Date Type: System Default Date Format: YYYY-MM-DD hh:mm:ss AM Field: Field2 Data Source: PrintTime Data Type: Time Format: Date and Time Order: Date Time Date Type: System Default Time Format: MM/DD/YY h:mm:ss AM Text Fields Text Field: Text1 Text: Employee Profiles Pictures Picture: Picture4 Size: 286x107 Lines Line: Line1 Ends in Section: Section1 Line Type: Single Line Thickness: 30 Page Header Section: Section a Headings Heading: Text14 Text: Home Phone Heading: Text15 Text: Photo Groups Group: Group #1 Grouped By: {@first letter} Group: Group #2 Grouped By: {@name} Group Header Section: Section a Fields Field: Field3 Data Source: GroupName ({@name}) Data Type: String Detail Section: Section a Conditional Formulas Condition: BackgroundColor Formula: if RecordNumber/2 <> Truncate(RecordNumber/2) then color(204,204,204) else color(191,165,125) Fields Field: Field4 Data Source: {Employee.Position} Data Type: String Field: Field5 Data Source: {Employee.Extension} Data Type: String Field: Field6 Data Source: {Employee.Birth Date} Data Type: Date Format: Date and Time Order: Date Time Date Type: System Default Date Format: YYYY-MM-DD hh:mm:ss AM Field: Field7 Data Source: {Employee.Home Phone} Data Type: String Text Fields Text Field: Text2 Text: {Employee.First Name} {Employee.Last Name} Text Field: Text3 Text: Position: Text Field: Text4 Text: Extension: Text Field: Text5 Text: Birthdate: Text Field: Text9 Text: Name: Text Field: Text6 Text: Home Phone: Pictures (Blobs) Picture (Blob): Photo2 Data Source: {Employee.Photo} Size: 177x224 SubReports SubReport: EmployeeAddress Links: {Employee.Employee ID} => {?EmployeeID} Section: Section b Conditional Formulas Condition: BackgroundColor Formula: if RecordNumber/2 <> Truncate(RecordNumber/2) then color(204,204,204) else color(191,165,125) Fields Field: Field9 Data Source: {Employee.Notes} Data Type: Unknown Text Fields Text Field: Text10 Text: Notes: Lines Line: Line2 Ends in Section: Section6 Line Type: Single Line Thickness: 20 Section: Section c Conditional Formulas Condition: BackgroundColor Formula: if RecordNumber/2 <> Truncate(RecordNumber/2) then color(204,204,204) else color(191,165,125) Page Footer Section: Section a Fields Field: Field10 Data Source: PageNumber Data Type: Number Format: Number Currency Symbol: None Suppress if Zero: False Leading Zero: True Reverse Sign: False Number Style: -5,555,555 Text Fields Text Field: Text11 Text: Feedback on Samples by E-mail Hyperlink: mailto:crfeedback@businessobjects.com Text Field: Text12 Text: Business Objects Technical Support Site Hyperlink: http://support.businessobjects.com Text Field: Text13 Text: Copyright 2004 Business Objects Software Limited. All rights reserved. Business Objects, the Business Objects logo, Crystal Reports, Crystal Enterprise, Crystal Analysis, WebIntelligence, RapidMarts, and BusinessQuery are trademarks or registered trademarks of Business Objects and its affiliates in the United States and/or other countries. Other trademarks are the property of their respective owners. Business Objects owns the following U.S. patents, which may cover products that are offered and sold by Business Objects: 5,555,403, 6,247,008 B1, 6,578,027 B2, 6,490,593 and 6,289,352. Pictures Picture: Picture2 Size: 150x40 Hyperlink: http://www.businessobjects.com Lines Line: Line3 Ends in Section: Section11 Line Type: Single Line Thickness: 30 Subreport: EmployeeAddress Data Sources Source: Connection #1 Database DLL: crdb_odbc.dll Database Type: ODBC (RDO) Server: Xtreme Sample Database 11.5 Properties: QE_LogonProperties DSN: Xtreme Sample Database 11.5 UseDSNProperties: False QE_SQLDB: True SSO Enabled: False Report Parameters Parameter: EmployeeID Data Type: Number List Type: Static Default Values: 13 Tables Table: Employee Addresses Connection: Connection #1 Report Alias: Employee_Addresses Used Columns: {Employee_Addresses.Employee ID} : Number {Employee_Addresses.Address1} : String[122] {Employee_Addresses.Address2} : String[42] {Employee_Addresses.City} : String[32] {Employee_Addresses.Region} : String[32] {Employee_Addresses.Country} : String[32] {Employee_Addresses.Postal Code} : String[22] Record Selection Formulas Formula: {Employee_Addresses.Employee ID}={?EmployeeID} Formula Fields Field: home address city/region Formula: if IsNull({Employee_Addresses.Region}) then {Employee_Addresses.City} else {Employee_Addresses.City} + ", " + {Employee_Addresses.Region} Detail Section: Section a Text Fields Text Field: Text8 Text: {Employee_Addresses.Address1} {Employee_Addresses.Address2} {@home address city/region} {Employee_Addresses.Country} {Employee_Addresses.Postal Code} Text Field: Text9 Text: Home Address: