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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-11-09 : 07:09:29
|
| Rice writes "I was wondering if someone could explain to me why my Group Filtering doesn't work.I have a table where I am selecting six types of Actions and all of their totals.(Here is an example of my output.)JAN-2005 Cycle NEW 3 REN 4 CANC 10 REI 3 NET 7 END 4Now I need to total those counts but I do not need any of the NET values in my totals. The reason being is that NET equals CANC minus REI - so I don't need that 7 count because it would be doubling up.I have a Group created based on monthly cycles. So underneath each monthly cycle I need the data to total without including NET. I placed a filter on the Group Footer where my totals are but it doesn't work. All my totals still include the NET records. My filter in my Group Footer looks like this -Expression Operator Value =Fields!ActionCode.Value != 'NET'I am running SQL Server Reporting Services SP1. So if that is my problem please let me know and I will upgrade to SP2.Any help regarding this filtering mishap would be greatly appreciated.Thank you,Rice" |
|
|
Rice_Black
Starting Member
1 Post |
Posted - 2005-11-18 : 15:13:11
|
| I see people are really enthused about answering this question.It's a simple question - does Group Filtering work and if so how is it done?And if there is no such thing as Group Filtering then way did MS place a tab in the Edit Group selection called Filtering?I could have my store procedure (SP) do this work but I figured Reporting Services was built for complex business reporting – but maybe I’m wrong.Thank you,Rice |
 |
|
|
|
|
|
SQL Srvr - Reporting Services - Group Filtering