Hi everyone!
I have a question regarding filters. When I create a tabular filter like CustomerContract.Contract.Current = 1 and then I have a dataitem in the report called "No of unique customers with a contract" where I filter like this:
if ([CustomerContract].[Customer].[Finished] = 'N' and[CustomerContract].[Customer].[Current] = 1) then
(total(count( distinct [CustomerContract].[Customer].[CustomerID]))) else (0)
Like this I get correct data in the report but when doing this another way, because I would also like a dataitem in the same report showing every customer regardless if CustomerContract.Contract.Current = 1 which dataitem looks like this and is called: "No of unique customers":
(total(count( distinct [CustomerContract].[Customer].[CustomerID])))
When deleting the tabular filter: CustomerContract.Contract.Current = 1
and instead puts this filter in the dataitem:"No of unique customers with a contract" so it looks like this:
if ([CustomerContract].[Customer].[Finished] = 'N' and[CustomerContract].[Customer].[Current] = 1 and CustomerContract.Contract.Current = 1) then
(total(count( distinct [CustomerContract].[Customer].[CustomerID]))) else (0)
When doing this I get no data in the dataitem "No of unique customers with a contract".
Why, how is this possible? I know the data is there somewhere
Thankful for any help in this subject!!
BR Dudden
I have a question regarding filters. When I create a tabular filter like CustomerContract.Contract.Current = 1 and then I have a dataitem in the report called "No of unique customers with a contract" where I filter like this:
if ([CustomerContract].[Customer].[Finished] = 'N' and[CustomerContract].[Customer].[Current] = 1) then
(total(count( distinct [CustomerContract].[Customer].[CustomerID]))) else (0)
Like this I get correct data in the report but when doing this another way, because I would also like a dataitem in the same report showing every customer regardless if CustomerContract.Contract.Current = 1 which dataitem looks like this and is called: "No of unique customers":
(total(count( distinct [CustomerContract].[Customer].[CustomerID])))
When deleting the tabular filter: CustomerContract.Contract.Current = 1
and instead puts this filter in the dataitem:"No of unique customers with a contract" so it looks like this:
if ([CustomerContract].[Customer].[Finished] = 'N' and[CustomerContract].[Customer].[Current] = 1 and CustomerContract.Contract.Current = 1) then
(total(count( distinct [CustomerContract].[Customer].[CustomerID]))) else (0)
When doing this I get no data in the dataitem "No of unique customers with a contract".
Why, how is this possible? I know the data is there somewhere
Thankful for any help in this subject!!
BR Dudden