Solved

How to do aggregate function in Visual Studio Reporting Services

Posted on 2010-11-16
3
372 Views
Last Modified: 2012-08-14
I need to do an aggregate function to sum the number of hours, which is the data values in the image below.  I need to place the aggregate function where the "#Error" is in the image.  I already tried using the expression "Sum(Fields!Hours.Value)" but this does not work.
\
 View of the Report
0
Comment
Question by:zintech
  • 2
3 Comments
 
LVL 29

Accepted Solution

by:
QPR earned 500 total points
ID: 34161536
What data type is hours?
0
 

Author Comment

by:zintech
ID: 34164287
It is data type Int64
0
 
LVL 29

Expert Comment

by:QPR
ID: 34183871
no more details when in design view?
can you check the formula when in design view (are you using BIDs?)
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

772 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