expression to exclude rows in ssrs report

[M_nwadibia]

Hello,

I need ssrs expression that will enable me exclude some rows in my report. I have three page report but I want the three pages on one page. I used the expression cint(Fields!Senate_District.Value)<=20 to get 1-20 rows and cint(Fields!Senate_District.Value)>50 

to get rows 50 to 90.

I need the expression for rows 21-49 but my expression cint(Fields!Senate_District.Value)<20 AND Fields!Senate_District.Value >49 IS FAILING

[d_gosbell · Accepted solution]

---

@M_nwadibia wrote:

I need the expression for rows 21-49 but my expression cint(Fields!Senate_District.Value)<20 AND Fields!Senate_District.Value >49 IS FAILING

---

This is because your expression is logically incorrect and will exclude all rows as now row can be both less than 20 and greater than 49. If you change your expression to use OR instead of AND it should work fine.

cint(Fields!Senate_District.Value)<20 OR cint(Fields!Senate_District.Value) >49 

However it would be more efficient to do this filtering in the query for your dataset so that these rows do not even get sent back to Report Server for processing.