Search results for query: *

If I enter 4/30/2010 as @end the value returned is 5/30/2010 and there are 31 days in May?

I can increment @start as dateadd(mm,1,@start) and get the correct value, but how do I get the end of the next month considering that march has 31 days and April has 30 days? That is where my issue comes in at, figuring out the formula for @end? Thanks,

I have 2 parameters I am passing in and they are being used as below: @start = '2010-03-01' @end = '2010-03-31'. sum(case when o.startdate between @start and @end then originalopenings else 0 end) as newopenings, now I need to create another formula but this time I want the ones with start...

Thanks for all of your help!!!

I have a formula that I have created: checkdate between '2010-01-01' and (Select checkdate from prcheckheader where checknumber = @checknumber) I don't want to have to remember to change ('2010-01-01' ) to always be the first of the year? How can I write the date so it always picks up the...

Okay, I will give that a try. Yes the YTD field is already a calculated field in the table. That is why it is showing multiple times depending on the description. No matter how many times it shows, I only need it to calculate once?

Even if I change it to evaluate on all records, it is not adding the 2 lines together, it only returns the 6437.50?

If I place the running total in the detail section it populates for the first weekend, but nothing is returned for the second weekending. The running total is placed in my report footer section because that is where my totals are; could that be the issue?

I have a running total I created based on the following formula: IF {Command.paycodedesc} in ['Regular Hours', 'Overtime 1', 'Overtime 2', 'Overtime 3'] then {Command.ytdpay} ELSE 0 Here is the data being pulled: WeekEnding: 3/27/10 Name Desc Units YTDPay Company1 OT...

Beautiful thanks!!

I have 3 fields that I want to print out as (M-3-0) w.filingstatus+'-'+w.allowances+'-'+ w.exempt I keep getting error: Syntax error converting the varchar value 'M-' to a column of data type tinyint. What am I missing here? Thanks!!!

Got it!!! Thanks

I am new to this and have read over some posts prior to asking for help. I have a main repor that has employee data: Then I have a couple of sub reports that have totals in them as well (these are in the report footer because they wouldn't work in the GF becuase I am grouping on a date range...

I have 2 date fields that I want to concantenate to print as: 1/1/2010 to 2/2/2010. I have this code: k.startdate+'to'+k.enddate as date but get this error: Msg 241, Level 16, State 1, Line 6 Syntax error converting datetime from character string. What am I not doing? Thanks!

Awesome!! Thanks a million!!

I have a SSN field: 000000000 I want it to print out as : ***-**-0000 How can I accomplish this? Thanks for any suggestions!

I have a bar graph and the label is by months: January, February, etc. It prints February, January and I am thinking it is displaying alphabetically. Is there a way I can get those to print in the correct order? Thanks for any suggestions!

I have a query that I am doing a left outer join on and it returns rows with all "0" and I don't want those to show; how can I do about doing this? I tried doing something like: a <>0 or b <> 0 or c <> 0 but that eliminates needed data? select clientname, c.clientid...

Nevermind I got it. I guess I needed to type it to figure it out.

I am getting this error; Incorrect syntax near '–' For this code and cannot figure out what am I doing wrong: Select clientid, r.orderid, r.totalactive – CASE WHEN totalplaced > totalactive then totalactive...