turaks
asked on
Multiple datasets in report
Hello,
I have developed a report model from which I have created a report. The report contains two tables/tablices/tablix each pointing to it's own dataset. The fields that make up both datasets are taken from the model.
I am using the same fieldnames in each dataset.
I want to show different results in each tablx e.g
dataset 1: select * from country where salesteam='Active
dataset 2: select * from country where salesteam='Inactive'
Each dataset has a prompt parameter for address
My problem is that when I'm prompted to enter the address to search by , the second dataset ignores the search criteria and brings back everything. Can anyone suggest how to go about this? Can the two tables use the same dataset but using expression to limit the result e.g iif(field!status.value='Ac tive',fiel d!status.v alue,"") in the first table and iif(field!status.value='In Active',fi eld!status .value,"") in the second table
I have developed a report model from which I have created a report. The report contains two tables/tablices/tablix each pointing to it's own dataset. The fields that make up both datasets are taken from the model.
I am using the same fieldnames in each dataset.
I want to show different results in each tablx e.g
dataset 1: select * from country where salesteam='Active
dataset 2: select * from country where salesteam='Inactive'
Each dataset has a prompt parameter for address
My problem is that when I'm prompted to enter the address to search by , the second dataset ignores the search criteria and brings back everything. Can anyone suggest how to go about this? Can the two tables use the same dataset but using expression to limit the result e.g iif(field!status.value='Ac
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Create 2 different data set for Active and Inactive.
Put 2 Matrix and give different Dataset name to property of matrix.