Forum Discussion

M_nwadibia's avatar
M_nwadibia
Resolver III
3 years ago
Solved

expression to exclude rows in ssrs report

  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_Distric...
22
  • d_gosbell's avatar
    d_gosbell
    3 years ago
    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.

d_gosbell's avatar
d_gosbell
Super User
3 years ago
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.