Export report to different group of people

Hi John,
I have several set of queries need the variable setting. I noticed that when there are more than 3 tables join together and with sub query, the variable is not substituted. I checked your Dropbox already, it’s very helpful( thank you!). But unfortunately I was not able to figure out the variable setting in some of my queries.