Recent content by Gizmo0917

Thanks I will try this and let you know how it works.

I have a report that I am trying to use to receive total charges on NitricGas that we use. The patient can only be charged a max of $12,000.00 within a 30 day period. They may have a $9,750.00 charge on one day and a $10,625.00 charge on another day within that 30 day limit but in my report I...

I deleted a formula from my report and even tho I have done this it still says it is being used in the report and will not allow me to refresh my report. I know that the formula has been deleted and it is no longer in the report. When I go to insert the fields and go under formulas there is...

The Therapists all belong to a certain leadperson they are designated this by a team number and it doesn't show what time they work. 4 Teams and they are divided up among the teams. Some are not on the correct teams even as the guy that does are SQL support has not updated the information in the...

We use 1 date record per employee. They don't get overtime the times will always be from 6:45am to 7:30PM and 6:45Pm til 7:30 am. The productivity comes from their charting. so if they are late charting I give them until 7:30 to catch it up. {PRACTTEAMS.TEAMNAME} = {?TeamName} and...

I used that and got no errors however it still will not give me the correct information. I give up I have tried about 5 different ways to do this and Crystal will not give me that results I need. I must assume that there is not a way to get the correct data from 2 different days when a shift...

if time({PRACTWORK.DATE}>= time(7,30,0) and time({PRACTWORK.DATE}) < time(19,0,0)then "Shift 1" else "Shift 2" This is how I have it and I did this by creating a formula called shift in the new formula field not the edit selection formula. It gives me an error says I am missing a ). I named...

I am not sure what you mean by good and bad machines. But On the report options tab I do have it set for ConvertDate-Time Field to Date-Time.

{PRACTWORK.DATE}in DTStoDateTime({?StartDate}+ ""+{?StartTime} +":00.00")to DTStoDateTime({?EndDate} + "" +{?EndTime}+ ":00.00") I tried creating 4 parameters and using this formula that I got from the Crystal Reports Knowledge base. The formula gives me no errors but it still doesn't give me...

if time({table.field}) >= time(7,30,0) and time({table.field}) < time(19,0,0) then "Shift 1" else "Shift 2" I created a New Formula and called it Shift using this formula and got no errors. But when I placed it in the report or tried to group on it it put everyone in Shift2. I have a...

This is the entire formula I found one mistake where I left out something and tried it again and it said the result must be a boolean. The fields that I am getting this from our datetime fields. So I believe I have to account for the dates somehow but I am not sure how to do that. Thank you.

if time({table.field}) >= time(7,30,0) and time({table.field}) < time(19,0,0) then "Shift 1" else "Shift 2" I am getting an error that says a ) is missing. I have double checked and can not find where to put the paren. Any suggestions? Thank you,

I put this formula in and I am getting an error. That says I am missing ) . I have double checked the formula and have it exactly as it is in the post. Any suggestions? Thank you!

I will try this. We use a medical Software pkg that sits on a Sql Server I believe it is SQL 7 if that helps.

We operate on a 24X7 hour time range. I need to do a report that will allow me to capture the time range for my 2nd shift people. The time will be 7Pm to 7:30AM This allows me to do a productivity report. I have a report set up and it is getting my information for the dayshift just fine but the...