I have a BSC_DropDownMenu pulling a list from a DB. The control is being populated correctly for presentation.
However, I want the selected item (multiple items = False) to become the value of a parameter/variable. That is not happening, thus the report is not running correctly.
For simple key-entry BSC controls, I just put the desired parameter name in the BSC_CorrespondingParameterName property and the pre-defined parameter gets the value at run-time. With a drop down box, that property has to be the DB column that I want to populate the list with. So... I have to find another way to take the selected value out of the control and put it into the pre-defined parameter.
I have tried to use the GetValue() function in various ways and in various locations. It gets a compile error for not having a property associated - even when I am specifying the BSC_DropDownMenu control by every different way I can think of.
I've created a memory variable and I think I have associated it with the BSC_DropDownMenu control by putting it in the ObjectVariable property. But I have had no luck referencing it anywhere else I thought (based upon timing of the firing of the controls) it would work. It either ignores it or complains about an invalid reference (of some kind.)
Nothing works! Can anybody suggest a way to accomplish this?
Thank you very much, in advance, for any assistance you can render.
Regards,
Jeff Emslie.
However, I want the selected item (multiple items = False) to become the value of a parameter/variable. That is not happening, thus the report is not running correctly.
For simple key-entry BSC controls, I just put the desired parameter name in the BSC_CorrespondingParameterName property and the pre-defined parameter gets the value at run-time. With a drop down box, that property has to be the DB column that I want to populate the list with. So... I have to find another way to take the selected value out of the control and put it into the pre-defined parameter.
I have tried to use the GetValue() function in various ways and in various locations. It gets a compile error for not having a property associated - even when I am specifying the BSC_DropDownMenu control by every different way I can think of.
I've created a memory variable and I think I have associated it with the BSC_DropDownMenu control by putting it in the ObjectVariable property. But I have had no luck referencing it anywhere else I thought (based upon timing of the firing of the controls) it would work. It either ignores it or complains about an invalid reference (of some kind.)
Nothing works! Can anybody suggest a way to accomplish this?
Thank you very much, in advance, for any assistance you can render.
Regards,
Jeff Emslie.