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:
ReferralTime
Hospital - this is only used as a dropdown parameter
What 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