Search results for query: *

Thank you, but I was hoping I could do it as a simple expression on the report itself, using a iif statement or datediff but the syntax is eluding me My query itself is already pulling the first cases of the the day (MIN). I want all of the data from that query but simply want to count and...

I'm trying to check for any fields that are higher than a specific time in a datetime filed (i.e everything after 7:30am for that date). I'm used to working in Crystal Reports and I just can't seem to find the proper syntax to get this to work Any help would be appreciated

try : If Not isNull({cpmain.udftext6}) Then If isNumeric({cpmain.udftext6}) Then ToNumber({cpmain.udftext6}) Else 0 I believe you can also change the way CR handles NUL fields also but it is probably very different on my version than yours.

Please keep in mind I am using a version of CR from another time (7..gulp) but I believe you can just put: if IsNull({cpmain.udftext6}) = false then TONUMBER ({cpmain.udftext6}) else 0;

Goto Format text-->Suppress and add this formula (on the button to the right of suppress): IsNull ({YOURDATABASEFIELDHERE}) = True

No, I tried every conceivable syntax for loops and to no avail. One of the users here confirmed that it was not available till 8x http://www.tek-tips.com/viewthread.cfm?qid=1158515&page=5 Which kind of boggle the mind, but I'm trapped with this program for at least the short term so I'll have...

Thanks, I'm gonna give it a try. I just worry about the limitations in crystal 7, wasted 2 hours only to find it didn't support loops. And will it let me write a 200+ line formula ? Time to find out : )

Sorry I am just not explaining properly (monday) Crystal version 7 Database used BTRIEVE Example data (one of the 62 formulas): ---------------- IF ({Post Anes Type.ANES START TIME} > {Post Case.START TIME}) AND ({Post Anes Type.ANES START DATE} = {Post Case.START DATE}) THEN "INCISION...

Sorry I'll give more detail. The formulas all check various potential problems (end time before stop time, wrong resource assigned, ect), but they will all return "" if the condition is not met. I created the formula field that should check if all the formula's (@NO ERRORS) are "" (so...

I'm trying to make an existing report more "readable". It is a validation report that checks 62 different conditions (62 different formula fields) and will display whatever doesnt pass. Currently it will show Every record, even when all conditions are me. I've tried to make a formula like...

I've recently started at a position and and in the process of cleaning out a mess of uneeded records (1000's). However I have been a Network Tech for a while and am only recently back into programming. I have created the queuery in Crystal (v7 7) and need to create the exact same one in...

Being an ORSOS administrator (v8.5.5.2, gulp) I'm limited to having to use Crystal 7, I tried to emulate your problem and receive the same thing until I do as someone mentioned and create multiple formula fields and "suppress if zero" on them. If you look at you're built in ORSOS error...

I have to run to catch my train but, this would be the function for a Datetime var. I'll research tomorrow if it can be done with datevar Local DateTimeVar Start := {StartDate}; Local DateTimeVar End := {EndDate}; global numbervar diff; //remove saturday and sunday this does not take...

wow : ( Thanks for the quick answer, I had expected it, I probably lost 2 hours of productivety trying to track down sites on this ancient program. I guess this will make my reports a little more challenging.

Hello, I'm trying to creaste a simple loop in Crystal Reports 7 (for then, while do, ect..) in a formula and just receive an "The remaining text does not seem to be part of the formula" error (I have tried crystal and basic syntax). I have worked with newer version of Crystal but am forced to...