General :: Shell Script To Extract Single Report By Pattern Then Both Backward And Forward

I have to admit that I register to LQ after I failed to search for similar solutions.let me see whether I can explain my problem clearly. I need to extract a single report from a big file. The big file looks something like this:

Report for yyyyyy
Your info 999-9999999
End of Report

[code]....

I need to search for a user provided string, say 999-9999999, in the big file. Then I have to extract the single report. My logic is simple,

1) find 999-9999999
2) backward search for "Report for", note down the line number
3) forward search for "End of Report", note down the line number
4) extract the record by using info found from step 2) and 3).

I am trying to do this in bash, with awk and sed (I am new to both).