Create Parameters for Custom Dataset

In this tutorial we will add a parameter for Customers to a dataset, this guide can also help you to add other parameters to your dataset(s)

First we need to make a selection from the dataset containing the customers data.

Create a new datatable
We select the customerID as value and customerNAME as disp

Select
customerID as val
customerNAME as disp
From dbo.MyDataTable

Then we create a new parameter with value and disp from our dataset
Choose val as Value column name
and disp as Caption column name

Once the parameter is made go to your dataset «Columns» and click the parameter button on the right hand side for the column you made the parameter for.
Find your parameter and click add then save, remember to save the datatable aswell.