Search results for query: *

Im brain dead on this. The report i called up did not have the ConditionID 358 in the table {IncPatientConditions}. When the {Incident} record is generated, it creates a record in the {IncPatientConditions} table. It includes the {IncidentID}, {ConditionID} fields. For each {ConditionID} that is...

My report is mainly comprised of fields from the {Incident} table. The second table ({IncPatientConditions}) has an entry of the {Incident.ID} for every {IncPatientCondition.ConditionID} that was selected. The third table ({MedicalHistoryCondition}) has a field for the...

I have a report that the main table is linked to another table and that table is linked yet to another table. Table 1 (main table) is linked from {Incident.ID} to {IncPatientCondition.IncidentID} and that table is linked from {IncPatientCondition.ConditionID} to {MedicalHistoryConditions.ID}...

It works great on the first group and shows the first and every tenth record. It continues the count even when the group changes and continues the count and showing of every tenth record. I do indeed have more than one group, and I can't figure out how to reset the count when group #1 starts...

Thanks LB Phillipg

I have a group in a report called incident.statenumber (which is a string field) and would like to show the first and tenth occurrence in the group. I used in the group's header suppress formula section the following and it shows the tenth occurrence: remainder(groupnumber, 10) <>0. I also...

lbass, I dont have any groups in the report to put those formulas in the header and footer. Thanks for your help. Phillipg

Thanks Lbass for getting me on the right tract, but, the field could have up to ten(10) results. I tried local stringvar inj; inj :=""; inj:={INCINJURIES.INJURYLOCATION}+": "+{INCINJURIES.INJURYTYPE}; inj:= inj+" "+next({INCINJURIES.INJURYLOCATION})+": "+next({INCINJURIES.INJURYTYPE}); inj:=...

I have a report that that when printed, produces two reports with all of the same results except one field. One table has the ability to have more than one answers in it. When I print the report it puts one answer on one report and the other answer on another report. What I would like to do is...

What ver of crystal are you using? In 8.5 and 9, this has worked for me: DateTimeValue({first. field} - {second.field}) and format it to show '00.00'. What are the formulas of the two fields you are trying to use, @Timeoncall and @timeoncall3? Phillipg

I have found a solution. It is a modified version of Lbass's recommendation. it seams to work fine. The 'Whileprintingrecords' function also returned an error so I removed it. The formula I used is as follows. Thanks to every one. Phillipg Numbervar H :=0; Numbervar M :=0; numbervar S :=0...

I tried cdatetime without any luck. Also, it won't process whileprintingrecords either. Thanks Phillipg

Normaly the difference in the two values is only a few minutes. It is formated to show only the time in a 24 hour time format, example, 0.03. It is the results (in time) of a subtraction of the two fields. Thanks, I'll try your suggestion. Phillipg

We have a program that calls reports designed in CR7 to view and print. I've designed a report in CR8.5 and saved as CR7 (have tried 8.5 also) but get an error when the report starts to load. The error is "Error in formula <AV>...

Yes, no luck. I've tried a formula to trim at 10 characters with no luck. thanks for your suggestion synapsevampire. Phillipg

Sorry, it's an Oracle database Phillipg

Thanks for the reply. The database is an ODBC(RDO). The field does vary in length, up to about 50 characters, but usually only 2 or 3 characters. It does truncate the last character if the memo is greater than 2 characters in length. I have tried Left to Right, Right to Left, return only the...

CR9 won't show the last character in a memo field. works fine in CR8.5 The report definition for CR9 has all the same characteristics as CR8.5 with one exception for the memo field and that is: Split Adornment. I have tried everything i could think of to get it to show that last character and...

in CR8.5 the results are correct, but in CR9 the results add 12 hours. I don't understand why. Both use the same data. if TimeValue ({INCIDENT.TIMEALERTED}-{INCIDENT.TIMENOTIFIED}) >= timevalue(00,02,00) and ({INCIDENT.PRIORITYTOSCENE}) = "Emergency" then "Disp.="+totext (TimeValue...

I have a report that displays the &quot;Date&quot;, a count of &quot;Refused&quot; and a count of all &quot;case numbers&quot; for that particular day. I have a group (group:1) that is of the date the cases were entered. The Detail section has other data from that case in it, but is hidden. The...