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 |
|
stharish
Starting Member
43 Posts |
 Posted - 2011-11-28 : 18:15:18
|
| I'm working with Report Builder 3.0 and trying to count scheduled ON/OFF days on a pilot rotation calendar I created. As far as I can see Report Builder does not have any CountIf functionality so I'm using the following expression I found online:=Sum(iif(Fields!ActualOn.Value="True", 1, 0))The report runs okay but the totals in the column for days ON are incorrect (in the hundreds).Is there a better way to do this? Any idea why the totals would be so far off? Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-29 : 03:26:44
|
quote:
Originally posted by stharish
I'm working with Report Builder 3.0 and trying to count scheduled ON/OFF days on a pilot rotation calendar I created. As far as I can see Report Builder does not have any CountIf functionality so I'm using the following expression I found online:=Sum(iif(Fields!ActualOn.Value="True", 1, 0))The report runs okay but the totals in the column for days ON are incorrect (in the hundreds).Is there a better way to do this? Any idea why the totals would be so far off? Thanks
the expression looks finewhats the discrepancy you're noticing?can you explain with data sample?also is this column inside a group within report?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Count Functions