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

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