Creating the results page for the report

• Left = 565
• Max rows = 0
• Name = dsEmployees
• Order by = emp_lastname
• Source Parameter

  select emp_lastname, e.paygrp_id, paygrp_name,
  					 emp_firstname, to_char(emp_hire_date,'MM/DD/YYYY') HIRE_DATE from employee e,
  					 pay_group p where e.paygrp_id in (#request.dbPayGroups#) and p.paygrp_id =
  					 e.paygrp_id 

  Note: If you are using DB2, replace the above Source Parameter SQL code with the following since DB2 is not compatible with to_char:

  select emp_lastname, e.paygrp_id, paygrp_name,
  					 emp_firstname, char(date(emp_hire_date),USA) as HIRE_DATE from employee e,
  					 pay_group p where e.paygrp_id in (#request.dbPayGroups#) and p.paygrp_id =
  					 e.paygrp_id

• Top = 285
• Source Type = Query

In the above example, the data source selects records from the EMPLOYEE table (for example, employee last name, employee first name, employee pay group ID, and employee hire date) that fit the criteria specified on the first page of the report (for example, the pay group ID that the user selects from the dbPayGroups DBLookup control). A request object is used in the above query. See Requesting Data From Controls.

After the Data Source control values have been modified, the Property Inspector displays your new information.

• Left = 565
• Max Rows = 0
• Name = dsEmployees
• Order By = emp_lastname
• Source Parameter

  select emp_lastname, emp_firstname, 
  to_char(emp_hire_date, 'MM/DD/YYYY') HIRE_DATE from employee 

  Note: If you are using a DB2 database, replace the above Source Parameter SQL code with the following:

  select emp_lastname, emp_firstname, 
  char(date(emp_hire_date),USA) as HIRE_DATE from employee;

• Top = 285
• Source Type = Query

In the above example, the data that the report retrieves is ordered by employee last names. The data source selects from the EMPLOYEE table, the last names and first names of employees who were hired on a specified date and orders them by last name and first name.

Once the Data Source control values have been modified, the Property Inspector displays your new information.

• Left = 565
• Max Rows = 10
• Name = dsDate
• Source Parameter

  select to_char(sysdate,'Mon DD, YYYY') TODAY from dual

  Note: If you are using a DB2 database, replace the above Source Parameter SQL code with the following code because DB2 does not use the DUAL table:

  select char(current date,usa) as TODAY from LOC_QUICK_TIME 

• Top = 24
• Source Type = Query

In the above example, the data source retrieves the system date in the format Month/DD/YYYY (for example, Feb. 13, 2002). Once the data source values have been modified, the Property Inspector displays your new information.

• Height = 100
• Name = Page Header

Once the Page Header control values have been modified, the Property Inspector displays your new information.

Some controls have default values. Unless otherwise noted, maintain the defaults for these controls when you complete the Process Steps described in this document. For example:

• Alignment (Left)
• Contains HTML (the checkbox is selected)
• Foreground (set to Black color)
• Preserve Value (the checkbox is selected)
• Read only (select this checkbox)
• Tab Order (0)
• Thickness (1)
• Viewable by (All, Sender)

• Background = Cyan from Standard Colors
• Datasource = dsEmployees
• Name = Detail

Once the control values have been modified, the Property Inspector displays your new information.

• Background = Select a custom color with the following settings:
  • Red = 0
  • Green = 44
  • Blue = 99
• Height = 62
• Name = ReportHeader

Once the control values have been modified, the Property Inspector displays your new information.

• Background = Unselect the Default Color checkbox and then select a custom color with the following settings:
  • Red = 0
  • Green = 44
  • Blue = 99
• Caption = Employee Report
• Font = 22
• Foreground = White from Standard Colors
• Height = 26
• Left = 13
• Top = 22
• Width = 239

Once the control values have been modified, the Property Inspector displays your new information.

• Caption = System Date
• Datafield = TODAY
• Datasource = dsDate
• Font = 12, Bold
• Left = 528
• Name = systemdate
• Top = 74
• Width = 94

System Date: In the above example, the Label displays today's date, which is retrieved from dsDate data source.

Once Label control values have been modified, the Property Inspector displays your new information.

• Left = 323
• Name = Logo
• Top = 10
• URL = /images/newlogobuildings.gif

Once the Image control values have been modified, the Property Inspector displays your new information.

• Caption = Page:
• Font = 12, Bold
• Left = 241
• Name = PageNumber
• Top = 151
• Width = 45

Once the Label control values have been modified, the Property Inspector displays your new information.

• Expression = #report.pageNumber#
• Font = 12, Bold
• Left = 294
• Name = PageNumberExpression
• Top = 151
• Width = 23

Once the values for the Report Summary control have been modified, the Property Inspector displays your new information. See Report Summary expressions.

• Caption = Last Name
• Font = 12, Bold
• Left = 14
• Name = LastName
• Top = 74

Once the Label control values have been modified, the Property Inspector displays your new information.

• Caption = First Name
• Font = 12, Bold
• Left = 124
• Name = FirstName
• Top = 74

Once the Label control values have been modified, the Property Inspector displays your new information.

• Caption = Hire Date
• Font = 12, Bold
• Left = 224
• Name = HireDate
• Top = 74

Once the Label control values have been modified, the Property Inspector displays your new information.

Note: The Datasource field is automatically populated with the data source for the Details section (for example, dsEmployees).

• Caption = First Name
• Datafield = EMP_FIRSTNAME
• Font = 14
• Left = 139
• Name = empfirstname
• Top = 110

Once the Label control values have been modified, the Property Inspector displays your new information.

• Caption = First Name
• Datafield = HIRE_DATE
• Datasource = dsEmployees
• Font = 14
• Left = 237
• Name = HireDateFirstName
• Top = 110

Once the Label control values have been modified, the Property Inspector displays your new information.

• Caption = Pay Group
• Font = 12, Bold
• Left = 338
• Name = PayGroup
• Top = 81

• Caption = Pay Group
• Datafield = PAYGRP_NAME
• Datasource = dsEmployees
• Font = 14
• Left = 335
• Name = PayGroupsLabel
• Top = 110
• Width = 74

When you have completed the steps, the results page of the Employee Report with Criteria should look like this example: