Now that I have starttime/endtime as:

StartDate: 2010-04-20 16:58:18.000

EndDate: 2010-04-20 26:59:56.000

I need to calculate the difference as "TimeTaken" and show it in hh:mm:ss

What would be an effective wa to...

Will definitely keep that in mind.

thx.

You're a savior. That worked!!

thx.

Got it. Thanks.

It turns out I was casting the sales field in my sql code as Money and it was being passed as 0.00, so I removed the cast and it fixed...

I just ran the windows 7 upgrade advisor and it came back compatible with sql 2008.

It's not b/c the rows are collapsed. We have several reports w/hidden rows and no issue.

There are no subreports in this report, so that's not it either.

I did notice that...

Beautiful...thx

Thanks everyone for the responses. It fixed my issue.

I explicitly set the length of the field.

Thx,

Never mind, I figured it out; pass the time part of the datetime field in military format to the report from the sproc; then at the report level, sort on...

I ended up using the code below and it works for what I'm trying to do. Thanks for your input and I've saved it as well.

Case When [Hour] > 12...

Thanks Arunkumar, that's what I ended up doing although it was my last resort.

John

Yeah, I figured that out after I posted the message.

thx.

Ok, I'll give that a try.

On a somewhat different subject, if I need to check for the presence of character '\' in a field, will this work:

Case...