How to build a Report Definition?
I'm having some difficulty building a Report Definition to make a simple database query. I understand how to build the query, but I don't see how to set the database or table to do the query in. It seems like it should be in the Data Access Tab, but I don't want to do a join. I have some database connections set up using Connect-SQL but I'm having difficulty making a similar query as a Report Definition. Any help?