Merging of two rows into a single row

[ramesh.kopparapu]

Hi,

I have a report which contains five fields called, "Employee number", "Trans date", "Time sheet comment", "Hours Bill", "KM bill".
I am getting one row for "Employee Number","Trans date","Hours Bill".
For the same "Employee number" and "Trans date" I am getting one more row with "Time sheet comment" and "KM bill".
I want to merge these two rows in a signle row containing the inforamtion of "Trans date", "Hours Bill" and "KM bill" for the same "Employee number" and "Trans date".
Could you please help me on this issue.

Regards,
Ramesh.K

[blom0344]

Use 2 queries and define a third one as a join (check cardinality you need)
However, adding or changing your underlying model can be more effective (let the database perform the join-strategy)
Joining 2 queries in your report requires additional work at the Cognos server. Databases are much better equipped for this work..

[crn.siva]

Hi ramesh,

If you don't mind explain how u want in the sense

in first column what you want display and in the second column what you can display, you are saying two columns.