Report Design: Grouping by current Officer and most recent date

Print Page | Close Window

Grouping by current Officer and most recent date

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15873
Printed Date: 08 May 2024 at 2:40pm

Topic: Grouping by current Officer and most recent date

Posted By: Babea
Subject: Grouping by current Officer and most recent date
Date Posted: 13 Mar 2012 at 4:03pm

Hi,

I am trying to get the most recent hearing officer and the most recent hearing date. I should also show the most recent hearing ID and any appeal numbers that do not have a disposition for the client. I am also trying to sort by total age, so I can help prevent them from becoming late.

Hearing Officer
Client ID
Disposition = null
Appeal # (1 to many)
Hearing #(can be many if rescheduled = R)
Hearing Date = should be currentdate-1 for this report.
Timely = less than 30 days unless there is an R or an exception - then it is timely if done within 90 days.

I have tried to give all the fields and as much info as possible to help solve my issue.

I have the timely formula for 90 days with R or exception, but I have hearings pop that are untimely with an O that have not been rescheduled.

Thanks for your help. Babea

-------------
Thanks! Babea

Print Page | Close Window