Grouping / Record Selection Question for Crystal Reports XI
Hello Experts,
I am working on a Crystal Report (version XI) that queries an Oracle database and is grouped by the following fields:
Court Date (for each day)
Judge Name
Case Number
Charge Number
The report is run for a date range that covers several months, so case numbers appear on the report multiple times if there are multiple court dates/judges for a single case number within the report date range. I'm wondering if there is a way, while maintaining the current grouping, to display case numbers only once for the most recent court date.
Additionally...I don't know if this is relevant to my question above...but the report is only displaying cases in which specified fields have null values. This is accomplished by using the following formula:
numberVar Nulls;
if (isnull({PTYCHRG.DCSN_CD})
and isnull({PTCGDSP.DSP_DT}) and isnull({PTCGDSP.CG_DSP_CD}
then Nulls := 0
else Nulls := 1
and then using the following group selection statement to suppress records:
Sum ({@Nulls}, {CASE.DSCR}) = 0
Thank you!!
I am working on a Crystal Report (version XI) that queries an Oracle database and is grouped by the following fields:
Court Date (for each day)
Judge Name
Case Number
Charge Number
The report is run for a date range that covers several months, so case numbers appear on the report multiple times if there are multiple court dates/judges for a single case number within the report date range. I'm wondering if there is a way, while maintaining the current grouping, to display case numbers only once for the most recent court date.
Additionally...I don't know if this is relevant to my question above...but the report is only displaying cases in which specified fields have null values. This is accomplished by using the following formula:
numberVar Nulls;
if (isnull({PTYCHRG.DCSN_CD})
and isnull({PTCGDSP.DSP_DT}) and isnull({PTCGDSP.CG_DSP_CD}
then Nulls := 0
else Nulls := 1
and then using the following group selection statement to suppress records:
Sum ({@Nulls}, {CASE.DSCR}) = 0
Thank you!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I need the report to group by the court date and Judge for the last court date available in the database for the case. I don't need any other court date and Judge information.
ASKER
The other charge information that I'm using in the report will be the same regardless of the court date and Judge.
Have you tried using the Group Select with TOP 1 based on the date?
mlmcc
mlmcc
ASKER
No, I have not tried that yet. I'll see how that works.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Do you need the information from the rest of the case for summaries or other analysis?
mlmcc