Duplicate Entries on BO Report

[TheFitz]

I am relatively new to Business Objects and I have beens asked to produce a report that has duplicate entries e.g. as shown below:

Emp Name     Project       Hours
--------     -------       -----
Mr J Bloggs  Project A     2.5
Mr J Bloggs  Project B     2.5
Mr J Bloggs  Project B     1.5
Mr J Bloggs  Project B     3.5
Mr F Bloggs  Project A     2.5
Mr F Bloggs  Project A     2.5
Mr F Bloggs  Project B     2.5

And I want to see:

Emp Name     Project       Hours
--------     -------       -----
Mr J Bloggs  Project A     2.5
             Project B     2.5
                           1.5
                           3.5
Mr F Bloggs  Project A     2.5
                           2.5
             Project B     2.5

Hope this makes sense, and can anyone help??

Thanks for your time in advance,

TheFitz

Fitz
Did you know, there are 10 types of people in this world:
* Those who understand binary
and
* Those who Don't!!

 

[nimmy99]

For duplicate records, goto optins in the Query panel and check the radio button to see dupliacte records.

Second thing, insert break on Emp Name column

 

[BrianTyler]

You should select the EMP Name column by clicking on J Bloggs, then click on the BREAK icon (the one next to the filter).
Then do the same for the Project Column.

This will give you the report you are looking for.

Once you have set these breaks you can format them to include or exclude the employee and project names.

If Hours is defined as a measure, each row will simply show the total hours an employee spent on each project.

To keep the level of detail in your example, you may need to include a week number or something, alternatively define the hours as a dimension.