the report comes up blank when set to database2 where it returned records with database1. I remember hearing somewhere that the database parameter would not work if the report was design with the report location containing the fully qualified stored procedure name, have you ever heard anything about this ?