rs:about the Scope parameter of a aggregate function

A valid scope is the name of a grouping, dataset, or data region. Only
groupings or data regions valid scope is the name of a grouping, dataset, or
data region. Only groupings or data regions .
the meaning of data region? for example?A data region is a list, matrix, table, or chart.
Please check Reporting Services BOL for more information, e.g.:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_structure_objects_v1_8epf.asp
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"aoeabc" <aoeabc@.discussions.microsoft.com> wrote in message
news:72ABECDD-41BB-427E-8CD8-AEC0776BF9F6@.microsoft.com...
>A valid scope is the name of a grouping, dataset, or data region. Only
> groupings or data regions valid scope is the name of a grouping, dataset,
> or
> data region. Only groupings or data regions .
> the meaning of data region? for example?|||Tell me an idea how to do this:
I have three records like this:
Type: 1
Amount: 100
Type 2
Amount: 200
Type 2
Amount: 100
The types of 1 must be negative and the 2 positive, so when I sum must be
-100+300 = 200 positive. I want to make a conditional sum. Now I made it
making the type 1 * -1 and then when I want to print the value amount *
iif(type = 1, -1, 1), so its very tired.
Any idea?
"Robert Bruckner [MSFT]" wrote:
> A data region is a list, matrix, table, or chart.
> Please check Reporting Services BOL for more information, e.g.:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_structure_objects_v1_8epf.asp
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "aoeabc" <aoeabc@.discussions.microsoft.com> wrote in message
> news:72ABECDD-41BB-427E-8CD8-AEC0776BF9F6@.microsoft.com...
> >A valid scope is the name of a grouping, dataset, or data region. Only
> > groupings or data regions valid scope is the name of a grouping, dataset,
> > or
> > data region. Only groupings or data regions .
> > the meaning of data region? for example?
>
>