Solved

Aggregate expressions ignore detail list filter in RS

Posted on 2011-02-11
5
717 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…

929 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now