mn20: I think the other guys have mis-understood your question. Let me see if I've got it?
You need to create the effect of a cross tab using dates as columns and names as rows with a count of the number of times a name appears on a specific date?
To do this without the use of a cross tab at all (whether using the expert or inserting a cross tab object) requires that you create a series of formulae to select the appropriate data. This is something I have done successfully in the past but you have to limit the process to a defined number of columns and you need to restrict the response to data within those defined columns or you will get wrong results. Here's a suggestion
Date1 - If Dow(Date)=1 and Name_Chosen = Name then 1 else 0
Date2 - If Dow(Date)=2 and Name_Chosen = Name then 1 else 0
Date3 - If Dow(Date)=3 and Name_Chosen = Name then 1 else 0
Date4 - If Dow(Date)=4 and Name_Chosen = Name then 1 else 0
Date5 - If Dow(Date)=5 and Name_Chosen = Name then 1 else 0
Date6 - If Dow(Date)=6 and Name_Chosen = Name then 1 else 0
Date7 - If Dow(Date)=7 and Name_Chosen = Name then 1 else 0
Then you'll need Sum formulae for each column resetting for each name and suppress the Details
HTH David C. Monks
david.monks@chase-international.com
Accredited Seagate Enterprise Partner