I don't think a negative size makes sense in a TreeMap.  How would that be represented when it expresses a number as a size?

Here's an article that shows you how...
https://www.mssqltips.com/sqlservertip/3453/sql-server-reporting-services-reports-with-optional-query-parameters/

What did you try? As stated, it almost sounds like homework.

"PatchTime column which is nvarchar datatype"  Why?  Because storing it as a date with time would be too...

Are you saying that there is a database for which you are the admin? Then you can put DelimitedSplit8K there and reference it using the 4-part naming syntax.  Lots of...

Are you connecting to Oracle?

If you are always going to filter a column, you could use a parameterized stored procedure...
CREATE PROC GetMyData
   @param1 VARCHAR(20)
AS
SELECT...

If the two datasets have one or more fields in common, then you can use LOOKUP, otherwise, you're stuck I think.

Does the GetData dataset have a DepartmentID or some way to relate the two datasets? You could use LOOKUP to grab a value from the other dataset.  Then hiding the...

DECLARE @Ref VARCHAR(7) = '103-B00';
SELECT LEFT(@Ref,CHARINDEX('-',@Ref,1)-1);

Consumable data?

Can you post the values assigned to the input parameters when you called it? And the CREATE TABLE script for the table you're inserting into?

If all you want is a verbatim copy as a base for your new stored procedure, you can do something like this:

Right-click on the stored procedure you want...

Build out a piece of it, add some dummy data and write some queries. Lather, rinse repeat.  That's the way most of us learned. If you make a mistake, your...

Not near enough information to tell. Reducing the number of subreports by merging datasets, if possible.

You know you sound exactly like Wendy Elizabeth?  Same expressions and speech patterns,...

Could you post the CREATE TABLE and INSERT scripts to give us some sample data and then an example of the expected output?  Answering your questions is just waaaay too...