Hi - I am writing a report in BO 5.1.2, which prompts the user to enter a value, as follows:
@prompt('Enter classes?','A',{<values>},multi,constrained)
My question is, how can I get the <values> variable to be a list of the values in a particular table column in the DB I am querying on?
If I were to use SQL, the <values> would look like 'select distinct name from class'. I imagine its possible with VB, but I don't have that. Or perhaps a stored proc? Obviously the best way would be to do it on the fly.
Any ideas?
@prompt('Enter classes?','A',{<values>},multi,constrained)
My question is, how can I get the <values> variable to be a list of the values in a particular table column in the DB I am querying on?
If I were to use SQL, the <values> would look like 'select distinct name from class'. I imagine its possible with VB, but I don't have that. Or perhaps a stored proc? Obviously the best way would be to do it on the fly.
Any ideas?