Multiple datasets in report
Posted on 2012-09-20
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='Active',field!status.value,"") in the first table and iif(field!status.value='InActive',field!status.value,"") in the second table