In my ssrs report, I have a column "Total" and it contains integer values. Now I want to remove the entire row from report, where value of column Total = -1.
Asked
Active
Viewed 599 times
0
-
how do you get the `Total`? from sql query or the ssrs? – LONG May 17 '17 at 14:50
-
from sql query..but I cannot modify the sql code... – A.G May 17 '17 at 14:52
-
you cannot modify the query from the datasets? – LONG May 17 '17 at 14:55
-
I can modify the dataset..but the query is quite complex and already tested..so don't want to take the risk of altering query. – A.G May 17 '17 at 14:58
-
paste your query, should be a way to add `where` condition to it – LONG May 17 '17 at 15:03
-
2Set row viability false if textbox that represents Total is 1. ReportItems!Total.value – Snowlockk May 17 '17 at 15:12
1 Answers
0
If you can't filter the data from the query, you can do so either via the tablix properties or the dataset properties. To add a filter to your dataset, right click the Dataset name and select "Dataset properties". Similarly, you can modify the tablix properties by right clicking the small square in the corner of your tablix and selecting "Tablix properties". Then select "Filters" and add your desired filter. See image:
C Bell
- 347
- 1
- 8
-
While this is correct, it's not very helpful because you didn't explain how to do this. If he already knew how to filter data in the dataset properties he probably wouldn't have asked this question. – StevenWhite May 17 '17 at 16:50