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 |
|
JacobOstop
Starting Member
2 Posts |
 Posted - 2009-06-09 : 10:51:08
|
| I have a SQL report with a table in it that is grouped by a specific field. For each grouping I need to count the total number of fields that have a field ="IN" and then also a seperate counter for the same field where the field="OUT" I am pretty sure I need to use an IIF statement with acount statement inside. Can anyone help guide me in the correct direction. Any help would be greatly appreciated!!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-09 : 14:11:11
|
| =SUM(IIF(Fields!YourField.value="IN",1,0))=SUM(IIF(Fields!YourField.value="OUT",1,0)) |
 |
|
|
|
|
|
Counting Specific rows in SQL Reports