How to add another row to paramter list which from

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

How to add another row to paramter list which from

Author

Topic

fh200300us
Starting Member

28 Posts

Posted - 2008-01-29 : 10:35:57

Hi,

I want to know how to add another row to paramter lists which from a stored procedure in the report. Is it possible? I don't want to use Multi-value becaue User only have one select.

Thanks,

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-01-29 : 12:46:45

you question is not clear. Are you speaking of adding a custom value to parameter list, like 'select all'? Then use a union all inside your sp to add this value too

SELECT 'Select All'
UNION ALL
SELECT Value
FROM Table

fh200300us
Starting Member

28 Posts

Posted - 2008-01-29 : 17:27:54

I means if it is possible not touch the stored procedure? and have the same result as yours.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-01-29 : 23:44:44

Then use the Non queried option and add all values in list. You can use either or options (from query or non queried), cant combine both.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources