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?

I could do that. I was trying to make sure I had it all installed correctly before going on to harder things. SSIS is bad enough for me as is,...

Just to make sure I wasn't doing something really stupid, I ran the Import wizard from SSMS, and tried to import the same data saved as a Text file.  The...

Did that already too. =(  That's why I'm completely perplexed by this one.  What else did I miss?

Then explain in plain English how that's supposed to happen. Once I know that, I can probably code it.

first you'd have to post the definitions of views 1, 2, and 3.

SELECT Client_ID
    , MAX([Amount]) AS MaxAmount
FROM ##TEMP
WHERE Amount>0
GROUP BY Client_ID;

without some CREATE TABLE statements and some consumable sample data, there's no way for anyone to really help you. Please read this article and follow the instructions so...

I posted a link to Jeff's article so you would read it. One of the keys to getting an answer is asking a good question, and Jeff explains how to...