title: SSRS automation
body: <p>I need to build many different reports with exactly the same simple structure from many different datasets defined by many different queries.  Specifically, I need a report which shows, in table form, the information stored in a table.</p>
  
  <p>Is there a way of automatically generating these reports?  Can I use VBA or something to, for each table:
  - set up a dataset based on the query "select [tablename].* from [tablename]
  - title the report from [tablename]
  - display all fields retrieved in a table?</p>
  
  <p>Many thanks in advance
  Nick</p>