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

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

CDN And Cloud Storage On Azure

Image
In this article I want to show you how to use the Azure Account Storage and a CDN associate to the Storage account already mentioned. Explaining the two concepts: Azure Storage Accounts Is a component on Azure platform used to storage files, data and anyother information we want to. The storage account can be: Blob Storage: for store files like we use on our PC. Files Storage : for File sharing using the SMB protocol, with this we can for example read and write the same file by multiple VMs.. Table Storage : for store data like noSql, is used to store data like database. Queues Storage : for store and retrieve messages, to scale apps depending on traffic. In this article we are going to focus on Blob Storage. Azure CDN CDN stands for Content Delivery Network and is a secure, reliable content delivery that allow our app access the static content faster lighten up the load of the server and enriching the client experience. What you need to make it ...
Read more