Type own list of parameter values - Report Designer

[Matt]

Is there any way to type my own list of parameter values for a specific parameter? Instead of using a datasource? ie. Yes, No,  or a list of items defined by me? Or would I simply have to do a SQL list of things (  SELECT 'Yes' As [option]  FROM ... WHERE .... UNION SELECT 'No' As [option] ..... )

Would be nice to do an items collection from the designer instead of forcing us to use a data set. 

Thanks

Jason
Fortech Energy, Inc.


BTW Posted in wrong thread, I need moved to "Report Designer" thread.

[Peter]

Hi Jason,

We don't have an out of the box option to add static values. Still as you have guessed you can achieve this with SQL or with a simple method that you can bind to and pass a string with a comma separated values. Check out the following example:

class DataLayer
{
    [Description("Split comma separated values to string array.")]
    public string[] Split(string values)
    {
        return values.Split(',');
    }
}

If you decide to use this approach you may find useful the How to use external assemblies with custom CLR objects in the Report Designer KB article.

Regards,
Peter
Telerik