I would like to create a report in report builder that would allow a users to select any table within a database then allow them to select a date range which after selection will provide all fields within that table and date range. The query (a) below gets me the list of tables. I would like then a vairable that takes the selected table name and passes to a query simliar to (b)
FROM sysobjects sobjects
WHERE sobjects.xtype = 'U'
FROM (the variable)
WHERE (Date BETWEEN (@StartDate) AND (@EndDate))
Is this possible and if so how can I wedge this into SQL server report builder?