I am using Crystal Report 2008 and need to combine rows into one row in Command. For example:

User      Date1            Date2
A     8/1/2011     
A                  8/2/2011
--------------------------------------
A     8/1/2011        8/2/2011

User and Date are from following SQL command:
--------------------------------------
select   distinct V_LIST.user, Date1, Date2
FROM
(
SELECT user,
Date1,
To_Date('','MM/DD/YYYY') Date2
FROM …various table
Where…
Group by user

Union
SELECT user,
To_Date('','MM/DD/YYYY') Date1,
Date2
FROM …various table
Where…
Group by user
) V_LIST
-------------------------------------------------

I need to use "Command" (not Grouping and Running Total Field) becasue I need to link this one record from command to other tables.

Thanks for any suggestions!
Clin