Good Morning Jeff,

Yes, The first thing I did was print @sql & @ColumnName variable. Both looks ok to the eye, with the exception of the NULL's.

Here are the...

Hi Andrew,

Thank you for getting back to me. I'm so relieved to hear I do not have to rebuild the folder. I deleted the .data file for that report and...

Thank you Sean!!

I will review the article you sent. I did get the while loop to work, but as you said it was not very efficient when pulling longer date...

Thank you Phil for the constructive criticism... I think I will go lie down now.

Thank you everyone for your feedback!!

My apologies but I'm still a little confused. I actually have two while loops happening here.... mostly because the first while loop output each data...

rdsb_2170@cfl.rr.com

My apologies Phil. I only saw the signature message on my phone.

Hi Phil,

I can assure you I did a google search before reaching out to the forum.  If you can't assist with the inquiry, then please don't insult users by implying...

Thank you for getting back to me so quickly. I believe that should work wonderfully!!! I've run the test and all looks good, just walking through the code now to...

Hi Sue,

Thank you for getting back to me. Sorry for omitting some critical details. Good news is I think the issue is resolved.
Apparently an update had applied...

I hate to be a pest, but has anyone else experienced this behavior? It is driving me crazy and really hosing up productivity.
Any suggestions would be very appreciated !!

You are awesome. That worked like a charm. Thank you!!!!

I was able to figure this out. Way to end a Friday!!

Hi Luis,

That worked perfectly!! Thank you very much for helping me with this.

Best Regards,
Cervello

Correction. This is my formula that is resulting in the error.

Expression:
=IIF(Len(Fields!SLAHours.Value) = 9,
(left(Fields!SLAHours.Value,3)*3600) +(mid(Fields!SLAHours.Value,5,2)*60) + (right(Fields!SLAHours.Value,2)),

IIF(Len(Fields!SLAHours.Value) = 8,
(left(Fields!SLAHours.Value,2)*3600) +(mid(Fields!SLAHours.Value,4,2)*60) + (right(Fields!SLAHours.Value,2)),0))