Recent content by jcglenn

Found it. missing the = Thanks anyway

I am using this expression iif(Sum(Fields!Net_Sales.value) = 0, 0, sum(Fields!Aquisition_Cost.value)/sum(Fields!Net_Sales.value)) It returns the expression instead of the data. What am I doing wrong? Thanks, Craig

OK got all the kinks out. Works now that I got all the syntax right... Had to create a new column to extract the Day of the week to get around using datepart() in the iif statement and had to use quotes around the colors. =iif(fields!DOW.value = 1 or fields!DOW.value = 7, "Blue", "Black")

OK, part of my problem was I ommited the = now... =iif(datepart(dw,fields!reportdate.value) > 5, Blue, Black) returns error... The color expression for the textbox ‘ReportDate’ contains an error: [BC30451] Name 'dw' is not declared. Can I not use datepart() here? if not, please suggest...

I have a report that sorts sales figure summarys by date and I would like to change colors for Sat and Sun. I tried using a iif statement in the font properties for the textbox. I receive an error box stating my expression is not a valid color. iif(datepart(dw,fields!reportdate.value) > 5...

George! It works! It will take me a couple of days to figure out why, but thanks! Craig

OK, here is a short data set... Invoice id ProcessedDate Amount Summary 500003105 2006-09-01 18:05:00 29.95 29.95 600007979 2006-09-01 18:17:00 29.95 29.95 500003107 2006-09-01 18:22:00 29.95 29.95 500003109 2006-09-01 18:37:00 29.95 29.95 500003110 2006-09-01 19:40:00 29.95...

I would like to group my sales qry by a 24 hr time period other than the standard group by day. Our sales periods go from 7:30pm to 7:30pm. I have searched several datetime grouping post but can't find exactly what I am looking for. TIA for your help. QRY so far... DECLARE @SDate as...

OK, I got it. I had tried this several times but was having problems. Now it works. Just put a count in a text box and put at the top of the report. thanks anyway

I just want a record count in the header/footer/anywhere in my report. Should be really simple, but I can't figure it out. TIA Craig

Thanks M, I saw that in another post yesterday so I turned it on. Checked the log this morning and sure enough The last step is send mail and I was getting a mapi error. Thanks again for your help. Craig

I have a DTS Package that runs on a schedule. The package seems to run and my export files are created. However the job reports failure everyday. Here is the error log. TIA Craig... Executed as user: GTIDOMAIN\MSSQLUser. ...t: DTSStep_DTSDataPumpTask_1 DTSRun OnProgress...