Thanks for the response

here is a sample of the desired output.

for report_id 1

511153872003-12-13 11:37:00.000

for report_id 2

nothing returned because a 1 does not follow a 2

For report_id 3

nothing returned because a 1 does not follow a 2

for report_id 4

1441172212003-12-12 14:30:00.000

for report_id 5

2151172572003-12-19 15:17:00.000

for report_id 6

nothing returned because there is no 2, the report has not been submitted.

for report_id 7

nothing returned because there is no 2, the report has not been submitted.

for report_id 8

nothing returned because there is no 2, the report has not been submitted.

for report_id 9

nothing returned because a 1 does not follow a 2