Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
@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.