Home > IT Answers > Business Intelligence > Isolating records for a report
babeas
40 pts.
 Isolating records for a report
Crystal Reports 11, Crystal Reports Record
Current Syntax: IsNull ({DISPOSITION.DISPOSITION}) AND {HEARING.OFFICERID}=987 AND {HEARING.HEARING_DATE}<CurrentDate I am trying to isolate appeals that need to be rescheduled. They can be rescheduled multiple times, and I end up with a lot of appeals in my results that have already been rescheduled. Any ideas would be greatly appreciated. This will allow us to go paperless if we can isolate these records for reschedules. Thanks! Babeas

Software/Hardware used:
Crystal Reports XI
ASKED: March 4, 2013  4:26 PM
UPDATED: March 4, 2013  6:54 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question. Michael Tidmarsh   11,400 pts. , babeas   40 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Hi babeas, welcome to ITKE. 

Anyone wanting to help you will need more details about your database design.   

How do you identify appeals that need to be rescheduled?, and how would you identify a rescheduled appeal and relate it to the original one?

carlosdl
 63,535 pts.