Ok, thx.

Thanks a lot Jack, that was very helpful.

John

Steve,

I think I agree with you on having the values twice in the sql code. I only thought of it just this morning, but I'll still try to do it...

I tried syntax =FormatDateTime(DateAdd("s",Fields!OutboundHours.Value,0),"HH:mm:ss")

and the report displays #Error for that field and my Output window says:

Build complete -- 0 errors, 0 warnings

The value expression for the textbox ‘OutboundHours’...

Thx, I believe it may exceed 24 hrs over the course of months.

I apologize. I believe it represents time in Seconds.

Message below:

Warning: Null value is eliminated by an aggregate or other SET operation.

Thanks,

I'll check them out.

I figured it out, it seems to be a RS2000 bug. When setting up your groups and visibility, set up the visibility/toggle from the properties box for that group...

Actually, I figured it out. I was saving the excel file as .xls and it should be saved as .csv.

thx,

John

I like this. This may actually work. I'll let you know.

thx a bunch.

John