MSSQL Reporting Services - custom report by who the auth'ed user is.
Need pointers about constructing this:
Given multiple authenticated users of Reporting Services.
Custom reports from a table filtered by whoever is logged in.
select * from table where table.user = [the person who is browsing the report]
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
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 …