| Groups | Blog | Home |
sql server reporting services : Multi-Select Error, easy question
beta 2. In the parameter I have the following: Data Type: String Multi-value - checked Label: General Info Value: GeneralInfo In the properties for the report I have the following under Visibility: =IIF(Parameters!DisplayInfo.Value = "GeneralInfo", False, True) When I execute the report and choose the only parameter value I get the following. (once I get this to work I will add additional parameters) Error: Processing Error "The Hidden expression for the table 'Table_Header' contains an error: Overload resolution failed because no Public '=' can be called with these arguments: Public Shared Operator =(a As String, b As String) As Boolen': Argument matching parameter 'a' connot convert from 'Object()' to 'String'. Thanks!!! --
Once you mark a parameter as "multi-value", the .Value property will return
an object[] with all selected values. If only one value is selected, it will be an object array of length = 1. Object arrays cannot be directly compared with Strings. To access individual values of a multi value parameter you can use expressions like this: =Parameters!MVP1.IsMultiValue boolean flag - tells if a parameter is defined as multi value =Parameters!MVP1.Count returns the number of values in the array =Parameters!MVP1.Value(0) returns the first selected value =Join(Parameters!MVP1.Value) creates a space separated list of values =Join(Parameters!MVP1.Value, ", ") creates a comma separated list of values =Split("a b c", " ") to create a multi value object array from a string (this can be used e.g. for drillthrough parameters, subreports, or query parameters) See also MSDN: * http://msdn.microsoft.com/library/en-us/vblr7/html/vafctjoin.asp * http://msdn.microsoft.com/library/en-us/vbenlr98/html/vafctsplit.asp -- Robert This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Shane Eckel" <ShaneEckel@discussions.microsoft.com> wrote in message news:5D2D2514-991E-4D75-87AE-DDC546D171A9@microsoft.com... >I am trying to show/hide a table based on a multi-select parameter in VS >2005 > beta 2. > > In the parameter I have the following: > Data Type: String > Multi-value - checked > Label: General Info > Value: GeneralInfo > > In the properties for the report I have the following under Visibility: > =IIF(Parameters!DisplayInfo.Value = "GeneralInfo", False, True) > > When I execute the report and choose the only parameter value I get the > following. (once I get this to work I will add additional parameters) > > > Error: > Processing Error > "The Hidden expression for the table 'Table_Header' contains an error: > Overload resolution failed because no Public '=' can be called with these > arguments: > Public Shared Operator =(a As String, b As String) As Boolen': > Argument matching parameter 'a' connot convert from 'Object()' to > 'String'. > > Thanks!!! > > -- > Thank You!
Robert, thanks my man, thanks for taking the time to respond. I'll try this
out first thing tomorrow. Thanks! Shane -- Thank You! [quoted text, click to view] "Robert Bruckner [MSFT]" wrote:
> Once you mark a parameter as "multi-value", the .Value property will return > an object[] with all selected values. If only one value is selected, it will > be an object array of length = 1. Object arrays cannot be directly compared > with Strings. > > To access individual values of a multi value parameter you can use > expressions like this: > =Parameters!MVP1.IsMultiValue > boolean flag - tells if a parameter is defined as multi value > =Parameters!MVP1.Count > returns the number of values in the array > =Parameters!MVP1.Value(0) > returns the first selected value > =Join(Parameters!MVP1.Value) > creates a space separated list of values > =Join(Parameters!MVP1.Value, ", ") > creates a comma separated list of values > =Split("a b c", " ") > to create a multi value object array from a string (this can be used > e.g. for drillthrough parameters, subreports, or query parameters) > > See also MSDN: > * http://msdn.microsoft.com/library/en-us/vblr7/html/vafctjoin.asp > * http://msdn.microsoft.com/library/en-us/vbenlr98/html/vafctsplit.asp > > -- Robert > This posting is provided "AS IS" with no warranties, and confers no rights. > > > > "Shane Eckel" <ShaneEckel@discussions.microsoft.com> wrote in message > news:5D2D2514-991E-4D75-87AE-DDC546D171A9@microsoft.com... > >I am trying to show/hide a table based on a multi-select parameter in VS > >2005 > > beta 2. > > > > In the parameter I have the following: > > Data Type: String > > Multi-value - checked > > Label: General Info > > Value: GeneralInfo > > > > In the properties for the report I have the following under Visibility: > > =IIF(Parameters!DisplayInfo.Value = "GeneralInfo", False, True) > > > > When I execute the report and choose the only parameter value I get the > > following. (once I get this to work I will add additional parameters) > > > > > > Error: > > Processing Error > > "The Hidden expression for the table 'Table_Header' contains an error: > > Overload resolution failed because no Public '=' can be called with these > > arguments: > > Public Shared Operator =(a As String, b As String) As Boolen': > > Argument matching parameter 'a' connot convert from 'Object()' to > > 'String'. > > > > Thanks!!! > > > > -- > > Thank You! > >
Robert, thanks for your reply. Very valuable information for this report and
for my future reports. You wrote, "Object arrays cannot be directly compared with strings." Do you know how I could do this 'indirectly'? Let's say the user selects 'GeneralInfo' and 'Contact Info' in the multi-select. Do you know of a way to evaluate their selection so I can take action on it? (such as visability) Thanks again for your help. Shane -- Thank You! [quoted text, click to view] "Robert Bruckner [MSFT]" wrote:
> Once you mark a parameter as "multi-value", the .Value property will return > an object[] with all selected values. If only one value is selected, it will > be an object array of length = 1. Object arrays cannot be directly compared > with Strings. > > To access individual values of a multi value parameter you can use > expressions like this: > =Parameters!MVP1.IsMultiValue > boolean flag - tells if a parameter is defined as multi value > =Parameters!MVP1.Count > returns the number of values in the array > =Parameters!MVP1.Value(0) > returns the first selected value > =Join(Parameters!MVP1.Value) > creates a space separated list of values > =Join(Parameters!MVP1.Value, ", ") > creates a comma separated list of values > =Split("a b c", " ") > to create a multi value object array from a string (this can be used > e.g. for drillthrough parameters, subreports, or query parameters) > > See also MSDN: > * http://msdn.microsoft.com/library/en-us/vblr7/html/vafctjoin.asp > * http://msdn.microsoft.com/library/en-us/vbenlr98/html/vafctsplit.asp > > -- Robert > This posting is provided "AS IS" with no warranties, and confers no rights. > > > > "Shane Eckel" <ShaneEckel@discussions.microsoft.com> wrote in message > news:5D2D2514-991E-4D75-87AE-DDC546D171A9@microsoft.com... > >I am trying to show/hide a table based on a multi-select parameter in VS > >2005 > > beta 2. > > > > In the parameter I have the following: > > Data Type: String > > Multi-value - checked > > Label: General Info > > Value: GeneralInfo > > > > In the properties for the report I have the following under Visibility: > > =IIF(Parameters!DisplayInfo.Value = "GeneralInfo", False, True) > > > > When I execute the report and choose the only parameter value I get the > > following. (once I get this to work I will add additional parameters) > > > > > > Error: > > Processing Error > > "The Hidden expression for the table 'Table_Header' contains an error: > > Overload resolution failed because no Public '=' can be called with these > > arguments: > > Public Shared Operator =(a As String, b As String) As Boolen': > > Argument matching parameter 'a' connot convert from 'Object()' to > > 'String'. > > > > Thanks!!! > > > > -- > > Thank You! > >
Hi Robert, don't worry about replying again. I think I figured it out. I
need to split it after I join it, right? -- Thank You! [quoted text, click to view] "Robert Bruckner [MSFT]" wrote:
> Once you mark a parameter as "multi-value", the .Value property will return > an object[] with all selected values. If only one value is selected, it will > be an object array of length = 1. Object arrays cannot be directly compared > with Strings. > > To access individual values of a multi value parameter you can use > expressions like this: > =Parameters!MVP1.IsMultiValue > boolean flag - tells if a parameter is defined as multi value > =Parameters!MVP1.Count > returns the number of values in the array > =Parameters!MVP1.Value(0) > returns the first selected value > =Join(Parameters!MVP1.Value) > creates a space separated list of values > =Join(Parameters!MVP1.Value, ", ") > creates a comma separated list of values > =Split("a b c", " ") > to create a multi value object array from a string (this can be used > e.g. for drillthrough parameters, subreports, or query parameters) > > See also MSDN: > * http://msdn.microsoft.com/library/en-us/vblr7/html/vafctjoin.asp > * http://msdn.microsoft.com/library/en-us/vbenlr98/html/vafctsplit.asp > > -- Robert > This posting is provided "AS IS" with no warranties, and confers no rights. > > > > "Shane Eckel" <ShaneEckel@discussions.microsoft.com> wrote in message > news:5D2D2514-991E-4D75-87AE-DDC546D171A9@microsoft.com... > >I am trying to show/hide a table based on a multi-select parameter in VS > >2005 > > beta 2. > > > > In the parameter I have the following: > > Data Type: String > > Multi-value - checked > > Label: General Info > > Value: GeneralInfo > > > > In the properties for the report I have the following under Visibility: > > =IIF(Parameters!DisplayInfo.Value = "GeneralInfo", False, True) > > > > When I execute the report and choose the only parameter value I get the > > following. (once I get this to work I will add additional parameters) > > > > > > Error: > > Processing Error > > "The Hidden expression for the table 'Table_Header' contains an error: > > Overload resolution failed because no Public '=' can be called with these > > arguments: > > Public Shared Operator =(a As String, b As String) As Boolen': > > Argument matching parameter 'a' connot convert from 'Object()' to > > 'String'. > > > > Thanks!!! > > > > -- > > Thank You! > >
Yes. The Join() will create a string from a multi dimensional object array.
The Split() function is the inverse function; it splits the string into a multi dimensional array. -- Robert This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Shane Eckel" <ShaneEckel@discussions.microsoft.com> wrote in message news:05BDA0D3-9D01-4C62-A844-99FE9F2BD791@microsoft.com... > Hi Robert, don't worry about replying again. I think I figured it out. I > need to split it after I join it, right? > -- > Thank You! > > > "Robert Bruckner [MSFT]" wrote: > >> Once you mark a parameter as "multi-value", the .Value property will >> return >> an object[] with all selected values. If only one value is selected, it >> will >> be an object array of length = 1. Object arrays cannot be directly >> compared >> with Strings. >> >> To access individual values of a multi value parameter you can use >> expressions like this: >> =Parameters!MVP1.IsMultiValue >> boolean flag - tells if a parameter is defined as multi value >> =Parameters!MVP1.Count >> returns the number of values in the array >> =Parameters!MVP1.Value(0) >> returns the first selected value >> =Join(Parameters!MVP1.Value) >> creates a space separated list of values >> =Join(Parameters!MVP1.Value, ", ") >> creates a comma separated list of values >> =Split("a b c", " ") >> to create a multi value object array from a string (this can be used >> e.g. for drillthrough parameters, subreports, or query parameters) >> >> See also MSDN: >> * http://msdn.microsoft.com/library/en-us/vblr7/html/vafctjoin.asp >> * http://msdn.microsoft.com/library/en-us/vbenlr98/html/vafctsplit.asp >> >> -- Robert >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> >> >> >> "Shane Eckel" <ShaneEckel@discussions.microsoft.com> wrote in message >> news:5D2D2514-991E-4D75-87AE-DDC546D171A9@microsoft.com... >> >I am trying to show/hide a table based on a multi-select parameter in VS >> >2005 >> > beta 2. >> > >> > In the parameter I have the following: >> > Data Type: String >> > Multi-value - checked >> > Label: General Info >> > Value: GeneralInfo >> > >> > In the properties for the report I have the following under Visibility: >> > =IIF(Parameters!DisplayInfo.Value = "GeneralInfo", False, True) >> > >> > When I execute the report and choose the only parameter value I get the >> > following. (once I get this to work I will add additional parameters) >> > >> > >> > Error: >> > Processing Error >> > "The Hidden expression for the table 'Table_Header' contains an error: >> > Overload resolution failed because no Public '=' can be called with >> > these >> > arguments: >> > Public Shared Operator =(a As String, b As String) As Boolen': >> > Argument matching parameter 'a' connot convert from 'Object()' to >> > 'String'. >> > >> > Thanks!!! >> > >> > -- >> > Thank You! >> >> >>
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |