Manual CrossTab Issue, need help.

[1128]

Can someone show me how can I show the time along with the user group's (User 11)row. I am using C9.



Monday Tuesday Wednesday Thursday Friday
A/P
User 11
02/20/2006 8:39:00 AM
02/21/2006 8:38:00 AM
02/22/2006 8:50:00 AM
02/23/2006 8:43:00 AM
02/24/2006 8:47:00 AM

 

[synapsevampire]

Is this a representation of the required output, or?

Generally posts should include basic technical information:

Crystal version
Database/connectvity
Example data
Expected output

-k

 

[1128]

K

The expected output is list below:

Monday Tuesday Wednesday Thursday Friday
A/P
User 11 8:39:00 AM8:38:00 AM8:50:00 AM8:43:00 AM8:47:00 AM
02/20/2006 8:39:00 AM
02/21/2006 8:38:00 AM
02/22/2006 8:50:00 AM
02/23/2006 8:43:00 AM
02/24/2006 8:47:00 AM

Crystal version = 9.0
Database/connectvity sql through odbc


Tim

 

[synapsevampire]

Why would there be days above the hours??? I don't see how you'd know which applies to which.

As previously requested, try posting example data (what's in the tables, not in some mock report)

Then show what the report would look like based on that data.

This just doesn't make sense, perhaps you'll do as requested or someone else can ferret out the requirements.

-k

 

[lbass]

If there is one time per date, then you could insert a crosstab, and assuming you are working with a datetime, you could use {table.user} as your first row field and{table.datetime} (->group options->print for each day) as your second row field, and use the following formula for your column field:

weekdayname(dayofweek({table.datetime}))

And for your summary, use a maximum of this formula:

time({table.datetime})

-LB