Make sure that you connect the Sub-report to the database as well. While you may have connected the main report the sub-report may not be connect to the right server, if my memory serves me correctly.