Search results for query: *

I know I've seen this formula before...but I can't for the life of me remember it. *argh* I have a field that displays a number 40.5...I need it to display in hours and minutes...like this - 40:30 Anybody got any ideas? Sincerely, Antiskeptic

I have never written a cursor from scratch...so I'm completely befuddled as to where to start, can anyone help me? I started this thread a couple days ago looking for a solution...and realized, and was told, that a LOOP or Cursor would be my only option...so here goes... I am working on a...

Don't know why I'm getting this error...very bizarre! I'm using CR 9.0 and I have a very simple report that works just fine until I go to put the parameters into effect in the Record selection My record selection statement looks like this: {rsp_RMS_ReconciliationReport;1.entry_date} >= {?From...

I am using SQL Server 2000. I am creating a stored procedure of which the output will be used in a Crystal report. But I need help getting the output right. I am making a payroll audit report to see how many consecutive days are taken off during a pay period. I have tried several different...

This may be impossible and I've tried everything I can think of. But does anyone have a clue how I can do this? I am working with SQL Server 2000 Query Analyzer The base table was originally a cvs file that I turned into an Access table...that I am now working with in SQL. MAinly because I...

Hopefully this is a quick question.... The field I need to analyze has data that looks similar to this: Accounting\NSF\2000 Logs\Jan Basically, as you can probably guess, this is a folder path. And I need to isolate the individual folders. What I am trying to do, is group another field...

Hopefully this is a quick question.... The field I need to analyze has data that looks similar to this: Accounting\NSF\2000 Logs\Jan Basically, as you can probably guess, this is a folder path. And I need to isolate the individual folders. What I am trying to do, is group another field...

Everything I have found so far is referring to time of day, or number of hours since a certain date, yadda, yadda, yadda. I need a format of 40:00 hours as opposed to 40.0 hours. The field I am deriving this from is a sum of minutes for a work week, for instance. In my Query, I am using a...

I know the title of this post leaves a lot to be desired, But I'm not quite awake yet and the terminology is just not coming to me this morning. *ha* I am working in SQL Server 2000, and I have a query pulling the basic fields needed for my report. I have one field however, that a little...

I am writing a stored proc with a few dates in the select statement (Using SQL Server 2000 / Query Analyzer). Only problem is, the dates aren't really date fields. They are integers of 4 digit numbers that I have to go through a conversion to get the date I want. And the formula I have below...

I'm not sure the subject is quite descriptive enough, but here is my situation. I have created a stored procedure (SQL Server 2000 - Using Query Analyzer)that gives me a daily record of employees' hours and workdays. I need to check this total on a daliy basis within this query. In other...

I have a Store Proc that pulls back employee and date information. I only need to display the 7th consecutive date and all it's corresponding information example: Employee ItemDate Start Stop WeekEnd #Hours Barney Rubble 6/26/04 12:00 6:00 7/02/04 6 Barney...

I am creating a report in Crystal 9, and working with data from a stored procedure out of SQL Server. My report consists of 4-5 groups, and details within those groups. However...there are several groups that do no match the criteria that I want to see. So I have created a few "rules"...

Here's my situation... I have "time" records in SQL that do not have an order or sequence number. So I have simply ordered them by the DetailDate and then by the StartTime. They are records of employee time, that keep track of when the employee punched in / Punched out...when they took lunch...

I'm very frustrated, and am not sure what I am doing wrong. Below is my formula in the Record Selection of my report: {PayPeriodEndDate} = {?Pay Period End Date} and ( (if {?CommunityID} = "" then {CommunityID}like "*" else {CommunityID}in ({?CommunityID})) or (if...

I have some really strange date fields in my current database. It is a number, counting the minutes since 1/1/1930. So my code to extract the date and time is as follows: substring(convert( varchar, dateadd( mi, process_raw.start_time, convert( datetime, '01/01/1930' ) ), 100 ), 13,6)...

I've looked throught the archives and found very similar problems to this, but not exactly what I need, so here goes...and I will try and be as specific as I can... I am using Crystal 9.0. I have a pretty simple report...three groups, and a detail section that is supressed when a certain field...