Report Parameter and Multi Value Prompt

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)

Report Parameter and Multi Value Prompt

Author

Topic

dewacorp.alliances

452 Posts

Posted - 2007-09-21 : 02:29:13

Hi all

Basically I had 2 paramater which ComputerName and MemberName.

The membername was set as Multi-Value as sets as follow:
Label: Value:
Exclude Domain Admins Domain Admins
Exclude Local Install Local Install

And the query is:

SELECT id,
ComputerName,
GroupName,
MemberName,
ScanDate
FROM GROUPMEMBERS WITH (NOLOCK)
WHERE ComputerCN LIKE '%' + @ComputerName + '%'
AND MemberName NOT IN (@MemberName)
ORDER BY ComputerName ASC

The prompt is like this:
Computer Name [ ] Excluded by [ ]

The issue is in the second prompt I have to select
"something" which is I don't want to. I want the user to have this parameter as an optional.

Any ideas?

Thanks

jhermiz

3564 Posts

Posted - 2007-09-21 : 22:48:36

Go to the menu for the RS parameters and select "Allow NULL values".

Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]

dewacorp.alliances

452 Posts

Posted - 2007-09-24 : 01:49:55

quote:
Go to the menu for the RS parameters and select "Allow NULL values".

I did try this and it said that: "The properties for the currently selected item are not valid. Please contact all errors before continuing."

BTW ... I've checked the "Multi-value" option. I don't think this work with "Multi-Value" checked.

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources