Solved

How to do aggregate function in Visual Studio Reporting Services

Posted on 2010-11-16
3
370 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

707 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now