Report question

Question: T-SQL, Insert into with MAX()+1 in subquery doesn't increment, alternatives?