ReportServer Forum

marcosfilho

Member

Registered: 2014-08-04

default value for database parameter

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.

Thorsten J. Krause

datenwerke

Registered: 2012-02-15

Website

Re: default value for database parameter

Hi Marcos,

are you looking for the SQL UNION-Operator?

SELECT 'none' label, 'none' value UNION SELECT label, value FROM table

Cheers,
Thorsten

marcosfilho

Member

Registered: 2014-08-04

Re: default value for database parameter

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.