Populate a parameter in report dynamically

Question

I have report which is listing all the users. I have a parameter for departments which is used as filters and it is a checkbox list. I am using this in report so we can filter the users based on the selceted departments and it is working well.

The report is using script to use the parameter and filter the users as per selected departments. This parameter is now manually populated with values of all departments we have so far. Is there a way in script I can dynamically get a list of departments and populate this parameter.

Answer 1

Hello,

Yes, it is possible. Unfortunately, we do not have the exact script, but the following one should be helpful: https://www.adaxes.com/script-repository/update-custom-command-parameter-values-based-on-unique-property-values-s527.htm.

Comments

Thank you instead of Custom command parameter I will need to use smimilar method for my report parameter right

---

Hello,

Yes, that is correct.