How to display each row of a query on separate page.

Hi Michael,
If you put your data into a List instead of a singleton, if you look at the List Properties you'll see an option for "Rows Per Page".   You can set this to 1, and I think this will give you your desired outcome -- each row will be on its own page.

Hi Jackie,

Thanks for the response, unfortunately I don’t think I explained my requirement well enough. I have a page that has fields a layout like Project Name: [Project Name] where [Project Name] is a column in the DB. Is it possible to display each [Project name from the DB in the layout without using a List item. I have many fields and essentially need each row from my query to be displayed in the page layout separately.

 

e.g.

Table has:

|Name|Surname|Age|

|A           |B               |12   |

|C           |D               |13   |

 

Page Layout is:

 

Name: [Name]

Surname: [Surname]

Age: [Age]

 

When I run the report I need to see

 

Name: A

Surname: B

Age: 12

 

Then be able to go the next record (clicking a button/ page down)

 

Name: C

Surname: D

Age: 13

Thank-you!

Regards,

Michael Alberda