Recent content by Phillipg

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