Hello,
I've been having some issues with creating a union in report studio. I have three different queries that provide data that I want to use in a crosstab.
Query 1: Mobile Phone costs within condition A (during workweek)
Query 2: Mobile Phone costs within condition B (outside workweek)
Query 3: Mobile Phone costs within condition C (international calls)
Each query works on it's own and returns the correct results.
When I run the union query, through "View Tubalar Data", I am getting the following error:
SubQuery 'Total_Query_during_workweek' used in a set operation cannot use members or member functions.
At first I thought the query was still linked to something or other in the report but I've removed it there.
Any tips or pointers are appreciated.
-Luhaine
Issue is fixed. Haven't quite figured it out yet what went wrong but I based the union on two working queries that were already present in the report (made them a 1:1 copy), this gave the error.
I rebuild each query into a new one from scratch and then it worked.