how to set rdlc report tablix to show record in one page

Hi sanny007,

In order to achieve your requirement, we can refer to the following steps:

1. Add two tablixes to design surface.
   


2. On the Detail row of the first tablix, insert one field, then use the following expression to control the row visibility:
   
   =iif(rownumber(nothing)<30,false,true)
   


3. On the Detail row of the second tablix, insert the same field, then use the following opposite expression to control the row visibility:
   
   =iif(rownumber(nothing)>=30,false,true)

This means that the first tablix will print the first 29 rows and the second tablix will print the remaining results. And we can modify the value based on the rows in the report.

If there are any other questions, please feel free to let me know.

Thanks,

Katherine Xiong

---

Katherine Xiong

TechNet Community Support