Solved

Aggregate expressions ignore detail list filter in RS

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
This video discusses moving either the default database or any database to a new volume.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

744 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

10 Experts available now in Live!

Get 1:1 Help Now