This seems to be straightforward but it is just not working. My report has a combined query using the Union operator. Query1 and 2 both work fine when executed individually. The generated combined query script works perfectly on database as well. But when I execute the combined query in WebI, I get the blank report with message - No Data to Retrieve in Query 1. I can't figure out what is causing this issue and how to debug it.