The way you are asking for it to work is the way it works by default. If it’s not working, then there is no relationship between region and state in the report. I have posted this before, including a screen shot in this topic.
Dave Rathbun 
(BOB member since 2002-06-06)