HomeGuidesRecipesAPI
HomeGuidesAPILog In

Repeating pages using a data source input

It is possible to use a question as an input on a Data Source question to allow a user to select how many pages to display on a page repeater at run time. The data source needs to call a SQL Stored Procedure which returns a sequential list of numbers based on a maximum number specified in the question.

The steps to implement this are as follows:

Create and Configure the Stored Procedure

ReturnConsecutiveNumbers stored procedure

create procedure [dbo].[ReturnConsecutiveNumbers]
(
    @val int
)
as
begin

SET NOCOUNT ON

    SELECT TOP (@val) row_number() over(order by t1.number) as Numbers
    FROM master..spt_values t1 
        CROSS JOIN master..spt_values t2

end
GO

Configure the Data Object

See screenshot below:

640640

Create the question in Designer
Create the number Question

The value captured in the Number question will determine how many pages are displayed by the repeating page control.

See screenshot below:

384384

Create the Data Source Question

See screenshots below :

729729 683683

Create the Repeating Page

See screenshot below:

679679