Multi-valued parameter - SQL Server Forums

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

Development Tools

Reporting Services Development

Multi-valued parameter

Author

Topic

RobertParker
Starting Member

10 Posts

Posted - 2007-11-14 : 10:39:42

I have a report which uses a multi-valued parameter as part of it's query. That part of the report runs fine.

I'm trying to write an expression or some VB code that would find out how many values are in the parameter. This is some of the code that I was trying to write, it was more complex. I commented out some lines, but it still causes errors.

Function changeArray(myArray() as Integer) as Integer
return 7
End Function

I was calling it from this expression:
=Code.changeArray(Parameters!SelectedLocationGroupID.Value)

I can't even pass the parameter as an array without it causing an error. Is there a way I can do this?

Thanks

RobertParker
Starting Member

10 Posts

Posted - 2007-11-14 : 13:10:30

nevermind I found the answer, I hate it when it turns out to be this simple

Parameters!SelectedLocationGroupID.Count

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources