The report works fine when I run it on the database that it was created on. So I know all the sub-report paramters are set right, the problem only happens when the database name changes !