I've been tasked with splitting several existing reports into two (one for one set of users, one for a different set) and while I was looking at using Linked Reports unfortunately the software program that actually does the pushing out of the reports to the end-users doesn't support Linked Reports.There also doesn't seem to be a "Dependencies" link which would allow me to see what reports are dependent on the Sub report I've been asked to change.Digging through various SQL examples that are out there there didn't seem to be anything to do exactly...
Thursday, May 16, 2013
Wednesday, May 1, 2013
I would have thought that dragging in data from SQL Server into Excel (both Microsoft products) would be easy - and it is if you're looking to drag in entire tables, views, etc. But if you want to do something a little more complicated with parameters it becomes a lot harder and less intuitive to get it to work.The example below shows how to get the ExecutionLogs from a SQL Server instance between two dates. I'm going to use Excel 2013 as it's...
Subscribe to:
Posts (Atom)
