adding reporting queries