How to limit number of rows

[Mohammad]

Hi everyone
I want to limit number of rows in each page
actually, I have a DataBand and I added a datasource with 50 rows to it.
How can I change setting to show only 5 rows in each page from my datasource?

[solomon78]

you need to select *from TableA where ${TableB.id} = TableA.id and ${TableB.mClass} = TableA.KClass; such condition will help you to filter and meet you desire