Is it possible for a cross tab (or other RTF template report format) to accomplish this?

The one issue with our cross tab report is the data needs to be grouped by day. This is the format we would like to achieve:

Employee-----Mon-----------Tues-------------Wed
John------------08:15AM-----08:15AM------11:00AM
------------------12:15PM-----08:15AM------16:00PM
------------------01:15PM-----08:15AM------17:00PM
------------------17:30PM-----08:15AM------19:30PM
Mary-----------10:00AM-----08:15AM------10:00AM
------------------14:15PM-----11:15AM------14:15PM
------------------15:15PM-----12:15AM------15:15PM
------------------19:30PM-----17:15AM------19:30PM

In this way, each employee (John and Mary) shows the time they started work and below that the time they went on their lunch break below that the time back from lunch break and below that the time they finished work.

With a cross tab report we are getting these results:

Employee-----Mon-----------Tues-------------Wed-----------Thurs
John------------08:15AM-----12:15PM------01:15PM------17:30PM
Mary-----------10:00AM-----14:15PM------ 15:15PM-------19:30PM

The data is going across the row instead of down. John's 12:15PM time going to lunch should display directly below the 08:15AM time he started work as in the first example.

Any suggestions to get a cross tab report (or any other kind of format) to display data like that?

Thank you very much!

We are working with XML Publisher (built into PeopleTools in PeopleSoft CRM 9. Tools 8.49.0.4. The XML is created from a PeopleSoft query (in App Designer) and looks like this:

<?xml version="1.0" ?>
- <query numrows="10" queryname="XML_QUERY1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="">
- <row rownumber="1">
<PKT_POST_ID>PKT_POST_I</PKT_POST_ID>
<PKT_CHECKIN_TYPE>P</PKT_CHECKIN_TYPE>
<EMPLID>EMPLID samp</EMPLID>
<ROW_ADDED_DTTM>2009-11-09T16:52:55-05:00</ROW_ADDED_DTTM>
<ACTIVITY_CODE>ACTIVITY</ACTIVITY_CODE>
<PHONE>PHONE sample data</PHONE>
<DESCR80>DESCR80 sample data</DESCR80>
<PKT_RC_NUMBER>PKT_RC_NUM</PKT_RC_NUMBER>
<DESCR50>DESCR50 sample data</DESCR50>
<DESCR>DESCR sample data</DESCR>
<COMPANYID>COMPANYID sampl</COMPANYID>
<BO_NAME>BO_NAME sample data</BO_NAME>
<BO_NAME_1>BO_NAME_1 sample data</BO_NAME_1>
<ADDRESS1>ADDRESS1 sample data</ADDRESS1>
<CITY>CITY sample data</CITY>
<STATE>STATE</STATE>
<EXP17_44>EXP17_44 sample</EXP17_44>
<EXP18_40>EXP18_40 sample</EXP18_40>
<EXP12_52>EXP12_52 sample</EXP12_52>
<EXP9_52>EXP9_52 sample</EXP9_52>
<EXP11_164>EXP11_164 sampl</EXP11_164>
</row>
- <row rownumber="2">
<PKT_POST_ID>PKT_POST_I</PKT_POST_ID>
<PKT_CHECKIN_TYPE>P</PKT_CHECKIN_TYPE>
<EMPLID>EMPLID samp</EMPLID>
<ROW_ADDED_DTTM>2009-11-09T16:52:55-05:00</ROW_ADDED_DTTM>
<ACTIVITY_CODE>ACTIVITY</ACTIVITY_CODE>
<PHONE>PHONE sample data</PHONE>
<DESCR80>DESCR80 sample data</DESCR80>
<PKT_RC_NUMBER>PKT_RC_NUM</PKT_RC_NUMBER>
<DESCR50>DESCR50 sample data</DESCR50>
<DESCR>DESCR sample data</DESCR>
<COMPANYID>COMPANYID sampl</COMPANYID>
<BO_NAME>BO_NAME sample data</BO_NAME>
<BO_NAME_1>BO_NAME_1 sample data</BO_NAME_1>
<ADDRESS1>ADDRESS1 sample data</ADDRESS1>
<CITY>CITY sample data</CITY>
<STATE>STATE</STATE>
<EXP17_44>EXP17_44 sample</EXP17_44>
<EXP18_40>EXP18_40 sample</EXP18_40>
<EXP12_52>EXP12_52 sample</EXP12_52>
<EXP9_52>EXP9_52 sample</EXP9_52>
<EXP11_164>EXP11_164 sampl</EXP11_164>
</row>
</query>

I can send you the RTF template too. Thank you!

Removing the @column created a single column with the same day listed. No other day columns were created.

I sent you the RTF and XML. Thank you.

Edited by: user10597210 on Nov 17, 2009 11:55 AM

Update: The cross tab now displays like this:

Employee-----Monday---------Tuesday---------Wednesday
------------------11/16/2009---11/17/2009-----11/18/2009
John------------08:15------------08:15--------------11:00
Mary-----------10:00-------------08:15--------------10:00

Thank you Vetsrini for the great sample on this page:

http://winrichman.blogspot.com/2008/08/cross-tabs-problem-with-grouping-and.html

However, there is only a single row for each employee for each day. The cross tab only displays the time they started work. What does not display is the time they went to lunch, came back from lunch and time they finished work. The display below is the requirement for this report.

Employee-----Monday---------Tuesday---------Wednesday
------------------11/16/2009---11/17/2009-----11/18/2009
John------------08:15------------08:15--------------11:00
------------------12:15------------08:15--------------16:00
------------------01:15------------08:15--------------17:00
------------------17:30------------08:15--------------19:30
Mary-----------10:00-------------08:15--------------10:00
------------------14:15------------11:15--------------14:15
------------------15:15------------12:15--------------15:15
------------------19:30------------17:15--------------19:30

Getting closer, just need to figure out how to get to this last step.

Thank you very much for any advice!

This woks great! Thanks for your help!