Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Tabular filter vs. definition filter for a dataitem in ReportNet

Status
Not open for further replies.

dudden

IS-IT--Management
Oct 21, 2005
9
SE
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top