Showing results for 
Search instead for 
Did you mean: 
jfenico Regular Visitor
Regular Visitor

Dynamic Parameter for appending tables based off of servers

Currently I have a report where each server we query is a parameter. When someone wants to create a new report, they load up the template and it will prompt them for the name of the servers to query. While this works, the problem we are running into is if the number of servers is different from what the template is looking for (e.g. the template is looking for 3 servers but the report is only need to report on 2).


This is due to an appended table looking not being happy with null values (where the other servers would exist).

Is there a way to basically say

If there are X amount of servers, only append X amount of tables together?

Moderator v-yuezhe-msft

Re: Dynamic Parameter for appending tables based off of servers


Would you please describe more details about how you define the parameter and post the code in Advanced Editor that you use to append the tables? Sample data is appreciated.


Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.