how do i sum multiple fields in ms sql reporting services

Posted on 2006-04-04
Last Modified: 2012-06-27
for example i have fields1, fields2 etc..

In an expression how do I add these all together

I need currency format..

Question by:LHood1
    1 Comment
    LVL 14

    Accepted Solution

    If they are within the same dataset just add an expression to the table cell:

    =Fields!MYFIELD1.Value + Fields!MYFIELD2.Value + Fields!MYFIELD3.Value ...

    Depending on your data you might need to use the SUM function =Sum(Fields!MYFIELD1.Value) + ...

    Then just format the cell as Currency (Format=C2)

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Hi, In my previous Article  ( discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
    How to increase the row limit in Jasper Server.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    754 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

    21 Experts available now in Live!

    Get 1:1 Help Now