Nested aggregate?
hi -
i'm using ssrs 05 , believe trying accomplish nested aggregate. in table have expression show date difference.
i'm using ssrs 05 , believe trying accomplish nested aggregate. in table have expression show date difference.
=iif((sum(iif(fields!progdescr.value =
"typed",1,0)) = 1),(fields!progdt.value - fields!recvdt.value),"-")
this part working fine. trying average of field in month grouping.
any appreciated.
lee -
2008 r2 supports nested aggregates
workaround 2005 involves including first aggregate within query each row include sum of monthly grouping:
select ...., (select sum(val) foo month(dateval) = month(t.dateval))
foo t
...
ofcourse situation bit more complicated moving if-else expression sql
workaround 2005 involves including first aggregate within query each row include sum of monthly grouping:
select ...., (select sum(val) foo month(dateval) = month(t.dateval))
foo t
...
ofcourse situation bit more complicated moving if-else expression sql
SQL Server > SQL Server Reporting Services, Power View
Comments
Post a Comment