Search results for query: *

I have a report that is grouped by case number. Each record has a case_status_date and I am trying to return only the groups that contain matching case status dates. I created a formula called @new1 with the following: if {Command.CASE_STATUS_DATE} = next({Command.CASE_STATUS_DATE}) then 1...

I am using Crystal Reports 11 and have a report that is grouped by case number. In each group, there are 4 events. I'm not sure how to calculate the time difference in minutes between the Locate Date and each of the 3 deadline events. I attempted a formula but the time difference is always 0...

I am stuck. I am using Crystal Reports XI and retrieving data from a SQL database. The goal of the report is to return cases that can be destroyed each calendar year. To determine when a case can be destroyed, the youngest child dob + 27 years on the case is compared to the latest order event...

I'm using CR 11 and in my main report event data is being returned for specific events and then sorted by the event date for each case group. I then have a subreport that brings in another event, event date and two more fields which I have put in the group footer. The data being returned with...

Hi - I'm hoping someone can provide some help with this as I am a beginner CR user. Here's my dilemma: I’m using this formula (AssignAttyTrialDate) to identify which attorneys were assigned when the eventdate occurred. If date({T_EVENT.EVENT_DATE_TIME}) in minimum...

Hi, How do I compare the same field in a group? For example, I have the following data (grouped by CASE_NUM): CASE_NUM PID JD-2010-00001 12345 JD-2010-00001 12345 JD-2010-00002 12346 JD-2010-00002 12347 I need to compare the PID's in each group and if the PID's are different...

Hi, I don't know how to write a group selection formula with 2 sets of criteria. Here's my situation: 1. Report is grouped by Command.case_number. 2. 60911True formula: If {Command.IS_60911_APPLICABLE}= True then 1 else 0; 3. Current Group Selection formula: sum({@60911True}...

I'm using Crystal Reports 11 and have a report grouped by number. Each group may have several charge modifiers. I'd like my report to display each group that contains a certain charge modifier (for example 123.11). I've tried using a group selection formula of {V_SSRS_CHARGE.CHARGE_MODIFIERS}...

Hi, I have a subreport that I need to insert into an existing text object in my main report which contains several other fields. However, I cannot drag or cut the subreport link/field into my text object. Is this possible? Or is there some trick to this? If you need further information or...

Hi, I'm using CR 11 and I cannot figure out how to format a number field to include a hyphen after the first 2 digits in the number. Is this possible? For example, T_CASE_INCIDENT.INCIDENT_ID displays as 1001281 in my report. I need it to display as 10-01281. Thanks for any help you can...

Is there a way to to set up my running total fields count to start with the value 2 each time? This is what I have: Summarizing field = L_Event_Type.Event_Type_Name Type of Summary = count Evaluate = for each record Reset = on change of group T_Case.Case_Num I'm speculating I maybe need to...

I have a crystal report that displays the charging attys and charging staff on a case for a received referral event if their assignment date is null grouped by Last_Name and then by Case_Number. In some instances, both a charging atty and charging staff are on a case. In this situation, we...

I am a newbie to writing crystal reports formulas. In fact, I've never written a formula in my life so I apologize for all of the questions. Here's my dilemma: I have a report grouped on case number and in the details it shows each assigned staff and their role name. What we want the report...