?
Solved

Aggregate expressions ignore detail list filter in RS

Posted on 2011-02-11
5
Medium Priority
?
757 Views
Last Modified: 2012-05-11
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?
0
Comment
Question by:cogc_it
  • 3
  • 2
5 Comments
 
LVL 25

Expert Comment

by:TempDBA
ID: 34878420
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
 

Author Comment

by:cogc_it
ID: 34888147
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
 

Accepted Solution

by:
cogc_it earned 0 total points
ID: 34888593
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
 
LVL 25

Expert Comment

by:TempDBA
ID: 34894385
Yup.
0
 

Author Closing Comment

by:cogc_it
ID: 35135848
My DBA gave me the solution
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question