| Author |
Topic |
|
JC55
Starting Member
4 Posts |
 Posted - 2011-10-17 : 22:16:11
|
| Is there any way of hiding a complete row in a SSRS 2008 Matrix Report?There are several row groups and a single static column and a single dynamic column group. If the total of the static column = 0 then I wish all elements including those of the row groups to be hidden. I have had no luck with setting an expression in the visibility of either the row groups, the static row, the static column or the dynamic column (though the static column is the sum of the dynamic columns)I apologise I am relatively new to SSRS and not sure whether I am missing something entirely elementary or if it really is more complicated.Any assistance would be appreciated. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-18 : 00:26:07
|
| i think you need to apply row filter to matrix. if you can give more details on grouping, i will try to come up with expression for filter------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
JC55
Starting Member
4 Posts |
Posted - 2011-10-18 : 00:59:00
|
| Thanks for your replyMy Matrix Layout isCUSTID CUSTNAME CMPNY CURNCYID:: BALANCE CURRENT AGE1 ETC (These are the row groups) :: (These are the detail columns)Column Groups:AGNGBCKT (Populates dynamic columns Current, Age1, Age2, Age3)Static ColumnBALANCE - sums all amounts.For every customer there may be an invoice/credit from one or more companies and each of these invoices or credits may be in a different currency and I need to reflect in the report that the value is being expressed in a certain currency, hence the need to use them as row groups (my assumption).However, the view may be returning a customer that actually owes $0 because the sum of the invoices and credits = $0 (summed in the Balance column (static)) and these documents may or may not be in different aging periods. If the customer owes $0 then there is no reason to include them in the report, hence my enquiry. Each of the row groupings will have a value for this customer, but the sum of outstandings = $0 - so it is not like I have duplicate rows or empty rows. I hope that I have given enough information to enable you to assist me further |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-18 : 01:43:52
|
| try putting a filter like SUM(Fileds!Balance.value) > 0------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
JC55
Starting Member
4 Posts |
Posted - 2011-10-18 : 02:00:51
|
| Thank you. That worked. There is one little anomaly where a $0 value shows (customer has invoices in both currencies but invoices in one currency total $0) but that is something I can live with. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-18 : 02:02:37
|
quote:
Originally posted by JC55
Thank you. That worked. There is one little anomaly where a $0 value shows (customer has invoices in both currencies but invoices in one currency total $0) but that is something I can live with.
and you should show both or only one currency?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
JC55
Starting Member
4 Posts |
Posted - 2011-10-18 : 02:27:17
|
| I think to get rid of it I have to apply the same filter at the currency row grouping. I currently only have it set at the Custmbr row grouping. Again thanks, because this has clarified the difference between using filters and using visibility settings. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-18 : 02:28:47
|
| ok.. n probs...you're welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
Hiding a row in a matrix