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?
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
SQL Server Integration Services can read XML files, that’s known by every BI developer. (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.)
But how far can you go? When does the XML Source component become …
In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report.
I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…