Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LarryC74
Yak Posting Veteran
94 Posts |
 Posted - 2009-08-10 : 11:43:30
|
| Good morning all,I am having a little bit of a time trying to either count or sum values in a dataset scope.The datasets:ReferralTimeHospital - this is only used as a dropdown parameterWhat I have is a table that shows the details of the records I want to count. There is a name column,,,time column. What I want to do is create another table or text boxes above the detailed table showing the counts of time that are <60, >60 & <70, >70. However the SSRS 2005 system isn't playing nice.I have tried this:=count(IIF(Fields!Time.Value <61,1,0))=Sum(IIF(Fields!Time.Value, "ReferralTime") <61,1,0)Anyone have any suggestions? to me this seems like a no brainer but it is making it difficult...Help!Larry |
|
|
|
|
|
Aggregate Functions and data scopes