Report filter in query UNION

[Former Member]

Hi all,

I've created a query UNION between Query_1 and Query_2... the result set is shown in a table.

How I can filter the table output with data from only Query_1 or from only Query_2??

[Former Member]

Hello,

You can qualify the objects by placing the name of the query before the object name in the table, such as [Query 1].[Dim 1], or [Query 2].[Dim 2], depending on which query you want the data to come from.

Thanks

[Former Member]

This is not a solution for my issue.

I've a table with 7 columns: this table is result set of Query_1 and Query_2 where the objects are merged.

Now I need to filter this table with a variable put into Report Filter toolbar. This avriable is able to take: ALL, Q_1 or Q_2 value... for filter all, only Query_1 result set or only Query_2 result set

[Former Member]

I resolved it.

When put varialble in Filter toolbar automatically this take ALL value