select substr(a.desctv,1,8),substr(a.desctv,-6,12),to_char(a.start_date,'mm/dd/yyyy'),
to_char(a.start_date,'hhAM')||'-'||to_char(a.end_date,'hhAM'),
b.income_sales GR,b.income_returns ER,(b.income_sales-b.income_returns) NR,
((b.income_sales-income_returns) * b.margin_perc) GM
from acntv.SHOWS a,intra.pbb_batch_sum b
where a.Start_date >= (TRUNC(to_date('07242003000000','MMDDYYYYHH24MISS')) + 7/24)
and a.start_date < (TRUNC(to_date('07242003000000','MMDDYYYYHH24MISS')) + 7/24 + 1)
and a.batch=b.batch(+)
order by a.start_date,a.end_date

This query works perfect when the report is built in tabular format.
I get the proper time in asc order too
for example
SUBSTR(A SUBSTR TO_CHAR(A. TO_CHAR(A
-------- ------ ---------- ---------
Jewelry Angie 07/24/2003 07AM-12PM
Jewelry Heidi 07/24/2003 12PM-05PM
Jewelry Misty 07/24/2003 05PM-10PM
Gemstone Tommy 07/24/2003 10PM-03AM
Jewelry Robert 07/25/2003 03AM-07AM


but I need a matrix by group report and for the same query,the time will come different since I guess it is going to use the group by. If group by is used then result is different.
it looks like this

SUBSTR(A SUBSTR TO_CHAR(A. TO_CHAR(A
-------- ------ ---------- ---------
Gemstone Tommy 07/24/2003 10PM-03AM
Jewelry Heidi 07/24/2003 12PM-05PM
Jewelry Misty 07/24/2003 05PM-10PM
Jewelry Angie 07/24/2003 07AM-12PM
Jewelry Robert 07/25/2003 03AM-07AM

How to solve the issue when i choose matrix by group.

Thanks