When manipulating data in a Pyramid Analytics report you may receive the message: “The Query Contains No Results.”
Usually this means that you have a slicer and column mismatch.
For example, in this report, you can see that the two columns display data for fall 2012 and 2013.
If I change the “Term by Type” slicer from “Fall” to “Spring” and rerun the report, I do not get any data and receive a message that “The Query Contains No Results.”
This is because the report displays data for fall term but I’ve selected to filter data on spring terms.
When I change the “Term by Type” slicer back to fall, the report runs and displays data.
You may also be interested in these topics: