Tweet
Dear All,
i want to know whether Is it possible in OTM Powderdata->docmentation->repots when we are adding parameters to generate a dynamicl list ,that is for a particlular column it should take the all the values from th database and display in the OTM as a dropdown.
eg: location id of the table location is there. is it possible to connect this location id as parameter such that it displays all the values stored in the location_id as drop down and user can select one value as a parameter for the report.
curetlly we are using text box, where the location_id has to be manually entered.
May you please guide in this.
Thanks and Regards
Muthahar
i want to know whether Is it possible in OTM Powderdata->docmentation->repots when we are adding parameters to generate a dynamicl list ,that is for a particlular column it should take the all the values from th database and display in the OTM as a dropdown.
eg: location id of the table location is there. is it possible to connect this location id as parameter such that it displays all the values stored in the location_id as drop down and user can select one value as a parameter for the report.
curetlly we are using text box, where the location_id has to be manually entered.
May you please guide in this.
Thanks and Regards
Muthahar