Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 382
  • Last Modified:

How to do aggregate function in Visual Studio Reporting Services

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
zintech
Asked:
zintech
  • 2
1 Solution
 
QPRCommented:
What data type is hours?
0
 
zintechAuthor Commented:
It is data type Int64
0
 
QPRCommented:
no more details when in design view?
can you check the formula when in design view (are you using BIDs?)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now