When my report is filtered to one record the subreport opens with no problem. When the main report is not filtered the report hangs, task manager shows 'Not responding', and only Ctl+Break can get me out. There's no code behind the report and joining the 2 queries the 2 reports are based on works fine too.