Hi All
I am creating a dashboard report, with two list and combination chart.
In Query 1 I have the following fields and i am using two filters
Member_active ='1' and Date prompt filter..
Product type
Product Group
Product Code
Account Balance
Member Active
In Query 2 Iam using one filter to get all Active member
Product Type
Product Group
Product Code
Account Balance
Member_Active
Query 1 display data for selected date,how many member are active and account balance.
query 2 display data for all members who are active and their account balance
Now in combination chart, i want show both the query1.account balance and query2.account balance.. and i am using combination chart..
If i do union on both queries. i am only getting quer2 result. query 1 is missing. now how do i get query1.acccount balance in the chart
comination charts
Measure-- Query1.account balance
Categroy--Product Type,
Series, query2.account balance
product group, product code.
Now when i run the report, i am getting a crossproduct join error, now who do i resolve this issue..
Help me guys..
Thanks
Phani
Problem Solved.
I used paramters value to get the information..
Thank you for taking the time to post your solution.