<p>Hello,</p>
<p> </p>
<p>I'm creating a report where I have UNION in query. The results are good for the data set "Preview Results", but when I start the report viewer the report returns only the first query before union, the second one after the union isn't showing or working.</p>
<p>I checked this by creating 2 identical data sets, but switching the queries in union and it returns the other results which are missing from the first data set.</p>
<p>Screenshots in attachements for better understanding.</p>
<p> </p>
<p>How to get that the results in birt viewer are the same as in data set preview?</p>
<p> </p>
<p>Best Regards,</p>
<p>Rudolfs</p>
<p> </p>
