Search results for query: *

Thanks! @DateHour and Group By Formula are changed, but I received an error on @mygroup, so I changed it to @DateHour. Now I have an error that this part of the statement: "totext(time(dateadd("n",29,{@datehour})),"hh:mm tt")" does not appear to be part of the formula. I tired a coma...

LB - thank you very much for all your help. I have learned so much in the past few days. Because I am such a newbie I failed to provide the right information to solve this problem. I believe this is the problem: @DateHour = DatePart("h",(History.CalldateTime)) and the Group By sorts by...

I have this SQL query to pull the data in half hourly increments, could this be something I could use in Crystal Reports? select dateadd(minute, -1 * datediff(minute, 0, calldatetime) % 30, dateadd(minute, datediff(minute, 0, calldatetime), 0)) as time, count(*), projectid from history...

LB - I think you have me on the right track - Thank You! I had been trying to figure out how the totals were calculated without a formula. I think my problem now is the fact that I can not use DatePart for half hour increments. I can pull the correct Data now, but the Group Header prints...

LB - The {@DateHour} is: DatePart("n",(History.CalldateTime)) and The {@NumOffered} is: Sum({@ManHour}, {@DateHour))

Thanks Madawc. It is CR 2008. I am wondering if I would best to try and make a whole new report instead of changing the existing one using the formula you provided. The book I mentioned is 2 inches thick and the boss needs this by next week. I was hoping to change all the formulas like this...

Hello! I do not know anything about Crystal Reports but I am desperate for help. I just got the book "The Complete Ref Crystal Reports 2008" but there is no way I will be able to get thru it in a week and be able to fix this report for my boss. This report came from a reporting application...