Skip to Content
0
Former Member
Dec 02, 2009 at 04:35 PM

Creating a LOV by using a Command Object

27 Views

Hello All,

I have a report that's driven by a parameterized sproc, which is a year parameter. However, we have a table that I would like to use in my object command to populate this parameter with the values from the select statement to enforce consistency. A new year is inserted into to this table yearly by another process, which would keep me from having to go into a static list to update the year options yearly.

I've created the command object and saved it to the repository, but I can't figure out how to associate it to the report as the parameter.

Can anyone point me in the right direction?

Thanks in advance.