Hi Adrian,
I’ve just looked into this for you. Unfortunately it is not possible yet to include metadata status levels in queries in the report builder.
We want to support your workflow, so we’re working on the feature now and we anticipate it will be delivered by next week.
Also, we have an upcoming webinar looking at the report builder at more depth here, and also on the community here.
I’ll let you know when its ready for you to use!