Explain how you would transfer SSRS subscription information from one server to another....

Need list of reports that are executed from Report server...

When Database engine processing a query, it process "select" clause after "where" clause. So in this case, "Alias", given in "select" clause, is not known by "Where" clause, so it will raise an error....