How to assign a scope to a report variable in ssrs 2012

Question

I'm new to SSRS (2012), coming from the loooong background using BusinessObjects, so it’s sometimes difficult for me to find out how to find the right terminology.

I have a report like this, where the sections are on the tablix and Grand Total tabs in another. This layout is necessary (or it will be a little easier!)

Section 1
                Date 1  Date 2  Date 3  % of Grand Total
Product1        value   value   Value   Value3/GT3 (12%)
Product2        value   value   Value   Value3/GT3 (14%)
Section Total   Total1  Total   Total3  Value3/GT3 (7%)

Section 2
                Date 1  Date 2  Date 3
Product1        value   value   Value   Value3/GT3 (30%)
Product2        value   value   Value   Value3/GT3 (22%)
Section Total   Total1  Total 2 Total3  Value3/GT3 (22%)

Grand Total     GT1     GT2     GT3     GT3/GT3 (100%)

I find it difficult to calculate% of Grand Total, as the numerator and denominator are not in the same volume. I thought maybe a report variable, but I can't figure out how to create the equivalent of this formula from BusinessObjects -

=Sum(Value) where (Date = "Date 3")

I want to assign a context or scope to my report variable, but I don't know how to do this, or if it will even work.

, , , ?

, .

Answer 1

SSRS . - , "" . , , . , , . ( F4).

, , . , , SQL. , , tablix . (- "Tablix1" "DataSetName" .)

, , , . . Business Objects SSRS, :

=SUM(IIF(Date = "Date 3",Value,0), "DataSetName")

, Date "Date 3", SUM. , Date = "Date 3" Value, SUM().

SSRS :

• MSDN: , ( SSRS)
• MSDN: ( SSRS)

Answer 2

- - ; : , ; SSRS 2012 " " (*), :

=Sum(IIf(Fields!ROWTYPE.Value = 9, Fields!TAXES.Value, 0), "DataSet1")

, : TAXES , 0 -... ! CDec(0)! Ciao

(*) ssrs. - ( ): "The expression for the variable myVAR uses an aggregation function on different data type"