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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.