Search results for query: *

I am using Cyrstal 8.0 and the data that I am working with is basically set up like this; I have two tables accounts and encounters. Each account can be linked to may encounters. In the account table a flag is set if the user didn't update it correctly when an encounter was created. I only...

I thought of that but we have a dynamic list of users as well as potentialy hundreds of them. Would lead to a lot of hard coding

You could use: file report options convert database null values or If isnull(Field) then 0 else (field)

Hello everyone, I was wondering if anyone out there has ever tried anything like this: I have accounts that get updated on different dates by different people. If the user does not follow the correct process the account gets flagged. What I would like is a count of the accounts, by user that...

You are absolutely amazing! Thank you very much, Charlie

Currently I am using three formulas. 1 is used for determining when the last test was performed: shared yearnum as number dim RecentYear as number shared recentmonth as number yearnum = year(cdate({ORDER_PROC.ORDERING_DATE})) recentyear = 0 if recentyear < yearnum then recentyear = yearnum...

I have tried that but I get the error &quot;This formula can not be used because it must be evaulated later.&quot; Charlie

Hello all, Here is my problem: In our database we have people that need to have tests done at different intervals and I want to create a report that will pull only the people that are due to come in in the next month. In the database we have has a field that lists how often test needs to be...

Is there a way to select records based on the result of a formula? Essentialy what I am trying to do is report off of a report. I have tried everything I can think of and haven't been able to discover a way to do it. Any assistance would be greatly appreciated. Thanks, Charlie

That is where the problem lies. When I try and set the variable to zero I get an error saying a Datetime is required here. What needs to be done to set a datetime to zero?

When an order is created it has a status of new in the order status history table. When it is acknowledged it creates another record in the order status history table. I am trying to get the amount that elapses form when an order is new to when it is acknowledged. I am comparing the times...

I am having a problem with CR8.5. What I want to do is find the difference between two datetime records. I can get the difference but what I need to do now is zero out the variables when I switch to a new record. I can't find a way to set a datetime variable to zero (or null)