Search results for query: *

Any suggestions on how to do the comparison of the case_status_date in the case_num group instead of using next?

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...

Would it be possible to add a date range to the DestroyDate formula of maximum([{@DOBPlus27},{@SharedVariable}]) Thanks

Thanks for your hard work. I tried more of your suggestions but just wasn't getting the results that I needed. So, I created another report that has a subreport bringing in the specific order events with the order event + 6 years. With what you showed me in this post I was able to get...

I tried what you suggested and it didn't group as expected. I put the DestroyDate formula in the report and a DestroyDate exists for each record because the formula is being calculated even when the EventIDReq is null. It is a bit complicated as I need the report to look at each group and if a...

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 don't know how right offhand, but I will look into it. Thanks!

Group header #1 = TEST CASE TITLE Details section: TS-2011-12345 Locate Date 07/29/11 Received Referral 08/30/11 Deadline Order 01/29/12 Group Footer #1 Pleadings Sent to Server 09/14/11 LN, FN, MN 09/14/11

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...

Thanks Mike - this worked perfectly!

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}...

Thanks - it works!

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...

Yes I am - Thanks!

Thanks LB you followed just fine. We decided to use the blank 2 as an integrity point. This is what occurs when there is not an event for the case: 1. Normandale 2. In most instances I do have an event so it displays as: 1. Normandale 2. Transcript delivered: 06/15/10 3. Transcript...

Thanks - both of these answers work!