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 |
|
mrm23
Posting Yak Master
198 Posts |
 Posted - 2010-05-21 : 03:16:08
|
| Hi All,In my last post i had asked can we use SP in report builder...i could not find anything related to it...so i am using query itself...now i am getting the report, but it is not as desired.i want to take count for each status....it is displaying all the status....ex i want something like:User position status1 status2AAAA 2--------- 3--------4-----but i am getting:AAAA 2 status1AAAA 2 status1AAAA 2 status1total 3 can anyone suggest how can i do this?m prob is i am not getting where i can write code for this :( |
|
|
|
|
|
applying filters based on conditions and grouping