you could put all the steps in a single stored procedure. 
-- check for existence of record in destination table using the parameter values you pass into stored procedure.
If...

SELECT id, ClockIn AS EventTime, 'IN' AS Event
FROM
(SELECT 1 AS id, 1234 AS ClockIn, 2345 AS Clockout) a
UNION ALL
SELECT id, ClockOut AS EventTime, 'OUT'...

Here's a YouTube tutorial on data-driven subscriptions in SSRS 2014... He's using Dynamics CRM (I think)... it's SQL Server database under the covers.
and then here is...

Look up subscriptions.

ROUND(num,2) doesn't work for you?

That's the most non-sensical reason for using a different function I've ever heard. If FLOOR does what you need it to do, then use it. If you need a decimal...

ORDER BY ZipCode, CustomerName

ORDER BY is in ascending order unless you specify otherwise

ORDER BY CustomerName DESC

Okay, I think I worked this out.  Since a BIT column stores either 1 or 0, I filtered the dataset by setting the Filter property of the report to this:

The easiest way of doing this is to make the parameter optional. If nothing is selected, then the report doesn't get filtered (Same as "ALL"/"BOTH")

You really need to read about NOLOCK and what it really does.  Here's a quick article by Denny Cherry, SQL Server MVP, former MCM.
It's not what you...

Uh oh, one of those "Reading Is Fundamental" things... Off to go read a little... Thanks!

Who in the world ever inserts graphs and charts into PowerPoint? I mean, that's just plain weird!
Took long enough!  And I still can't do it with 2016 Desktop.

At least now I know I'm on the right track... next thing is to work my way through Devin Knight's mapping of SQL Server to SSIS data types.  The good...

Got it to work finally.  Had to insert a Data Conversion task in between the Source and Destination.  This is going to be a long process, I think, but I...

Sue,
thanks for that.  ACE.OLEDB.12.0 is listed.  Can i use it with Access and Excel 2016?