sql server reporting services: rs:about the Scope parameter of a aggregate function -- sql server reporting services

You're in the

sql server reporting services

group:

rs:about the Scope parameter of a aggregate function

aoeabc
10/26/2005 4:44:02 PM

sql server reporting services: 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 .

Re: rs:about the Scope parameter of a aggregate function

Robert Bruckner [MSFT]
10/26/2005 7:49:51 PM

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.

[quoted text, click to view]

Re: rs:about the Scope parameter of a aggregate function

Carlos Javier
12/22/2005 8:08:01 PM

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???

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn