Hi,
I would like to incorporate a dynamic parameter field into my report. What I would like to do is instead of the user typing in the required value, I would like to have a drop-down of all available values. Now, when I click on Default values, I notice you can browse a table and use those values as defaults. However, when new values are added to the table they are not included in the drop-down since they weren't in the table at the time I added them to the default list. So my question is is there a way to set a parameter field that will query a table and return a list for the user to pick from?
Thank YOu
I would like to incorporate a dynamic parameter field into my report. What I would like to do is instead of the user typing in the required value, I would like to have a drop-down of all available values. Now, when I click on Default values, I notice you can browse a table and use those values as defaults. However, when new values are added to the table they are not included in the drop-down since they weren't in the table at the time I added them to the default list. So my question is is there a way to set a parameter field that will query a table and return a list for the user to pick from?
Thank YOu