ssrs 2008 - remove row where column group total = 0

0
votes

in ssrs 2008, I am getting My report output like below

enter image description here I need to remove/hide sr.no. = 3, condition to apply where total qty=0

I used RowVisibility Show or Hide but output shows : Sr.No. is showing like 1 , 2 , 4 (my serial number should come in line 1,2,3 and hide the row where total = 0)

thru tablix property applied filter as below but it is not filtering output ( I tried [expression] = Sum(Fields!QTY.Value, "DataSet1") Text [Operator] = <> [Value] = 0 or ""

I have row groups like [matrix_descriptopn, Matrix_OutletGroup , Outlet] I have Colum Groups like [Matrix_month]

enter image description hereenter image description here

1
ssrs-2008
Why don't you filter out rows having total = 0 from your dataset query ? – Konrad Z.
I tried, may be I am missing something, you can see above i tried , can you please give me a step to do – BhaveshParmar
But could you show me your SQL query for your dataset? – Konrad Z.
You can try to remove "dataset1" from your filter and change Text to Integer or Float. Something like: [expression] = Sum(Fields!QTY.Value) Integer [Operator] = <> [Value] 0 – Konrad Z.
Hi, I tried, as you said, but it is not showing any data, visible header and total only, I need to hide = 0 value, I tried = operator than also same thing – BhaveshParmar

1 Answers

1
votes

I would recode the filter e.g.

[expression] = Sum(Fields!QTY.Value) <> 0 
Boolean 
[Operator] = 
[Value] True

This is the only reliable way I have found to use Filters in SSRS.