Creating SQL Stored Procedures via SQL Server is easier than you might have originally thought, so let us explain what to do.

How do I go about creating a dataset for this report that uses a stored procedure/sql view which will pull out a dynamic list of tables to query from? My goal is to be able to select "Server1 ...