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?
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.