default value for database parameter

ReportServer (EN)
1

hello guys,

I would like to create an optional database parameter. my idea is to leave the first value empty and then the list returned from my sql query. So if the user picks up a value, i would use it in my script, else i would do something else.

is there anyway i can do it?

thanks in advance.

2

Hi Marcos,

are you looking for the SQL UNION-Operator?

SELECT ‘none’ label, ‘none’ value UNION SELECT label, value FROM table

Cheers,
Thorsten

3

I thought about that but wanted to know if reportserver had a feature for it. Because for other types of paremeters we can set default values(for example: date).

But thanks Thorsten.