Something like this?:
CREATE TABLE Test(BadData varchar(15));
GO
INSERT INTO Test(BadData) VALUES
('Data0 [2]'), ('Data1 [2602]'),('Data2 [130]');

SELECT BadData
    , LTRIM(LEFT(BadData, CHARINDEX('[',BadData,1)-1)) AS Loc
FROM Test;

SELECT ... NULL AS ColumnName
FROM MyTable
doesn't work?  Got some dummy data we can play with?

If the two result sets have a 1:1 relationship, use a JOIN.  If the two sets do not overlap, use UNION.

I think the easiest way into PowerBI is to get Rob Collie & Avi Singh's book, and to start playing. The book is only about $30, but absolutely...

Yeah, me too, Jeff. Definitely didn't mind getting schooled by someone that smart, but really humble (unlike some folk, like JC?)

Instead of this:
WHERE Orders.orid = (@IDs)

You want
WHERE Orders.OrID IN ( SELECT OrID....<rest of select/where clause>)....<rest of select/where clause>)

I think this...

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: