Solved

How to do aggregate function in Visual Studio Reporting Services

Posted on 2010-11-16
3
376 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

695 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