Solved

Aggregate expressions ignore detail list filter in RS

Posted on 2011-02-11
5
743 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

Suggested Solutions

Title # Comments Views Activity
SSRS  integration 5 102
Ssrs date parameters 12 175
How to connect Power BI Desktop to ssrs report server 2 106
SQL Stored Proc - Performance Enhancement 15 86
After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
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 shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

738 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