Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 715
  • Last Modified:

SSRS 2008 Total of a Group

On the line labeled "Total" I'm trying to get a total of the group but I keep getting the total of the entire dataset not what actually appears in the report from the Top N in the StoreGameID group filter. Their has to be something I'm missing. This seems pretty standard.
 Tablix Row Groups
0
dk04
Asked:
dk04
  • 2
2 Solutions
 
itcoupleCommented:
Hi

With your current arrangment you will get total of dataset as expresion is outside the groups, however you might be able to SUM based on text boxes name. See below syntax

ReportItems!textbox1.Value

Hope that helps
Emil

0
 
dk04Author Commented:
With your Syntax I received the following error- Aggregate functions can be used only on report items contained in page headers and footers.

Is their a better arrangement I should have?
0
 
itcoupleCommented:
It seems I cannot find a way to use aggregate function on a group with Top N and normal function compeltelly ignore top n. The only option I can think of now is to limit the result in dataset instead of the group.

Regards
Emil
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now