• It might also be worth seeing what the SQL that the report is actually running is. Use Extended Events to capture the SQL and run it yourself and see if you get the same result (no data), or maybe you'll notice it's running SQL that you weren't expecting.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk