If you want to display multiple or all records from a database, you must add a server behavior so that multiple or all records are displayed consecutively as required.
MX2004 enables you to display multiple records on a single page by providing a repeat region server behavior. It can display either a record or multiple records. The Bindings panel provides logging statistics, and you can create a record counter when you display a page that contains more than one record.
It is important to note that if you display multiple records on one page, you must specify a selection area that contains dynamic content as a repeating region. Any selection can be converted to a repeating region, most commonly a table, a table row, or a series of table rows, or even letters, text.
Step, first click the + button on the Server Behaviors panel, select the Repeat Region menu item from the pop-up menu, and then specify the appropriate recordset to specify the number of sparring records displayed per page
Next click the recordset tree in the Bindings panel to select the field, and then click Insert.
If there is a section of text below the table: it now shows a record from A to B, with a total of N records
Select a and select [first record index] on the recordset tree on the bindings panel, and then click the Insert button.
Select B and select [last Record index] on the recordset tree on the bindings panel, and then click the Insert button,
Select N and select [Total Records] on the recordset tree on the bindings panel, and then click the Insert button.