SQL Reporting

SQL Reporting

Is there a way to create SQL reports to pull data from the hourly or daily tables?  The problem I have is with the date being appended to the table name, it makes it impossible to setup a scheduled report to run in SRSS since the query would change each day to reflect the new table name.

                New to ADSelfService Plus?