I have a requirement where we have to put a user prompt on the first page of the report. This prompt will enable the user to select one of the many reports that drops down. Does anybody have any idea of how to accomplish this task.

 I typically do this within UI code rather than the db.  I haven't programmed UI code in a long, long time but I recall there being some sort of change event in VB that could be captured on a field that can trigger changes in another field.  Perhaps someone out there who does more UI coding in .NET (assuming you're using a .NET language) can give a more a precise answer.