We have a requirement where we know that a good solution is to create Divs and DataTables using Repeat Elements. Where we are struggling is implementing the datalayer for the Repeat Elements. This layer is a call to SQL with a number of parameters, a mixture of strings and dates. These values will either be from @session tokens or selected by the users from Input Select Lists or Calendar Inputs. These user inputs are to have a default value on the initial report load.
The issue I have is you cannot use parameters set by the Default Request Parameter element in a Repeat Element datalayer. I have tried to implement this using a main and subreport setup, with the user controls in the main report (with default values set) and the subreport being the actual content created using Repeat Elements. This almost works, but the default values don't get sent through to the subreport on inital load. It only works once the user invokes the Action.Refresh to update the SubReport.
How can I send default values on initial report load, so that the Repeat Element datalayer is populated (unfortunately having the database handle default values is not an option in this case as some parameters are user specific).
Please sign in to leave a comment.