Aggregate expressions ignore detail list filter in RS

I have a report with a list data region (detail) that is filtered to show records where the cost is over $100.  Outside of the list I have a text box that shows a count of records.  The count is counting all records, ignoring the filter.  Any suggestions on how to make the count see the filter in the data region?
cogc_itAsked:
Who is Participating?
 
cogc_itConnect With a Mentor Author Commented:
After speaking with the DBA I found that if I filter the dataset in the dataset properties instead of applying the filter in the layout I get the results I desire.

Thanks!
0
 
TempDBACommented:
you can apply the same filter condition here to.
What I understood from your question is suppose you have 10 records but 6 of them with value more than $100 and you are just displaying in the body with 6 values but your textbox displays its 10 right.
How are you filtering out 4 records from the body and how are you calculating the value for the textbox?
0
 
cogc_itAuthor Commented:
What I understood from your question is suppose you have 10 records but 6 of them with value more than $100 and you are just displaying in the body with 6 values but your textbox displays its 10 right.

Correct

How are you filtering out 4 records from the body and how are you calculating the value for the textbox?

In the properties of the Detail list (right click > Properties) I have set a filter that looks like this:
=Fields!Cost.Value > =100

How I am calculating the value for the textbox:
="Count = "   & Count(Fields!RecordID.Value)


0
 
TempDBACommented:
Yup.
0
 
cogc_itAuthor Commented:
My DBA gave me the solution
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.