need help on report?

[yaragalla]

 I have a bean like following

 

Employee.java

The fields are:  emp_id, emp_name, department

====The report should appear as follows===

Department:- (for example "HR")

           emp_id                 emp_name

          emp_Id                   emp_name

Department:-(For example "Mechanical)

         emp_id                    emp_Name

          emp_id                    emp_Name

 

Kindly help me in this. simple idea on how this can be done is enough. Thanks in advance

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

[yaragalla]

 kindly help me in this report?

[rajnagar]

You can do the following steps:

1) Create a report group. Right click on your file in Report Inspector and select the option 'Add report group'

2) Give the Group expression as 'Department' - select the department field from the list of fields retrieved from query.

3) Drag a 'Text field' into 'Group header' band and select 'Deapartment' field

4) place emp_id and another required field in detail band.

5) for the report grouping to work properly you have to sort the data on 'Department'. Use 'Sort Options' for the same.

 

I think this will solve your problem.