Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
7 | |
3 | |
3 | |
2 |
User | Count |
---|---|
15 | |
11 | |
5 | |
5 | |
2 |