CODEWITHSUNDEEP
c#vb.netvisual-studioreportrdlc
SamAyoub95
SamAyoub95

Reputation: 27

RDLC Sum Only Grouped Value

I have the data from the database in the following format

   Name   Amount  Price
    A      100     30
    A      100     50
    C      100     60
    --------------------------
    Total  300

Now I set Name as Parent Row Group And Amount As Child Group To Have This Format

   Name   Amount  Price
    A      100     30
                   50
    C      100     60
    --------------------------
    Total  300

But The Total Is Still 300, How i Can make it Sum Only Rows That Showing To Give Me Amount 200

I Use This Expression

=RunningValue(Fields!check_net.Value,Sum,"Tablix1")

And I Also Tried 

=Sum(Fields!check_net.Value)

But They Both Gave me Value 300

Sorry for my bad English, And Thanks

Upvotes: 1

Views: 6276

Answers (1)

Mavil
Mavil

Reputation: 302

The expression for the Total should be:

=Sum(Fields!Amount.Value,"Name")

Here, Name is the scope as you are grouping data by the Name field of the data set.

Upvotes: 1

Related Questions