sql server reporting services: Insert a value in a SQL query result for a parameter list. -- sql server reporting services

Insert a value in a SQL query result for a parameter list.

Mike
5/10/2005 12:50:02 PM

sql server reporting services:

I can create a parameter list box with values from a query from a database
table. Note: The database table does not contain any spaces or Nulls.
I am trying to find out if it's possible to have a value inserted into the
results of the SQL query. This value could be a space or specific value.
For example of the SQL resuts:
Medium
Low
High
Urgent

I would like to insert a space into the above query results. Is this
possible.

Re: Insert a value in a SQL query result for a parameter list.

Mike G.
5/10/2005 4:05:21 PM

Sure:

Select field from table

union

select 'whatever text you want'

Mike G.

[quoted text, click to view]