How to Sum Out Of Scope Element Inside Group Using Reporting Services

Hello everyone,

Some weeks ago I faced this problem, I had the task of SUM all element on a single sheet in a RPT file of reporting services.

After looking for the solution trying and failing, I found the way and here I give you the glue.

First, when we add TextBox Element on our group, it is created with a name which appear right down the property title in the property windows. This name is important for us to make all this possible.

Textbox selected inside the group:



Property Windows of the Textbox selected.



Feel free to change that name of the textbox, now we simply SUM the values in the sheet using the object: ReportItems as shown in below:

=Sum(ReportItems!Textbox1)

Now adding this to the element localized out of the group scope we will be able to sum all amount inside a group in the same sheet.

See you soon.

Ing. Edgar Perez

Comments

Post a Comment

Popular posts from this blog

WebSockets Implementation With SignalR And Xamarin.Forms

Image
What is SignalR? ASP.NET SignalR is a .NET framework focus on real-time communications between clients and server, the server can push content instantly to the connected clients when is needed rather than having a server waiting till new client request. so , using SignalR client and server could call method on each other at any time, like image below: (Image Source: https://docs.microsoft.com/en-us/aspnet/signalr/overview/getting-started/introduction-to-signalr) SignalR can be used to add any real-time functionality you want since a chat to any other real-time communication you web or mobile app need and is really easy to use. SignalR, WebSocket  And Transport Falls Back One of the most interesting features of the SignalR Framework is the possibility to support all real time communication supported for the different clients, for example, if one of your client doesn’t support WebSocket then the connection could be made using Long Polling or Server Sent-Event withou...
Read more

Creating A Push Notification Server with ASP.NET And Xamarin.Form App With Firebase Push Notification, Refit, And LiteDB - Part 1 (Firebase Configuration)

Image
This is going to be a series of articles, we are going to explain and develop a single Mobile Application and its respective backend that will handle all operations needed. The application is a proximity geolocation alert application that notifies people close on a defined ration specified by the user who published the issue. The mobile app work for Android and IOS and is developed using Xamarin.Forms. What do we you need to make it possible? Visual Studio 2015 or higher Basic knowledge of C# Google Developer Account Apple Developer Account Basic knowledge of Xamarin.form and cross-platform Let's start! In this first article, we are going to focus on the configuration of our application on the Google Firebase Console. First, we are going to create the set up to be able to use Firebase on our Mobile and ASP.NET Backend API. Login to the Firebase Console (https://console.firebase.google.com/) if you don't have an account yet,  just create a...
Read more

Dependency Inversion Principle Applied To Controllers With ASP.NET MVC and StructureMap

Image
The Dependency Inversion Principle is one of the five Solid Principles, this one state about making class dependent of abstraction instead of concrete object thus we obtain isolated and low coupling modules and low-level implementation details. The first time I heard about the Dependency Inversion Principle I used to confused it with the Dependency Injection Design Pattern but I was wrong because they are not the same although has relations each other. Since the Dependency Inversion is how we call the act of a class depending from an abstraction, the Dependency Injection instead is a design pattern where by object X is supplied the dependency of another object B. There are two ways of doing the dependency Injection, by constructors or Setters, here is an example: DI by Setter: public Class ObjectB {     // Internal reference to the ObjectC used by this ObjectB.     private ObjectC obj;     // Set the objectC that this ObjectB is to use. ...
Read more