Uncle Gizmo, thanks for your response, I am looking essentially at making 3 reports into 1 on the report viewer. The drop down list would hopefully be created by using the report parameter function. I believe the way to do this would be using report parameters but seem to have exhausted this...