You probably have one or more calculations w/ a result > 100

Contrived example...  This succeeds:

This succeeds:
SELECT 'Symbol',
'2023-05-02',
CAST(IIF(0 = -1, 0, 1.0 * 1.234567 / .01234567) AS NUMERIC(7,4))...

Post duplicated

What are the data types (w/ precision & scale) of T3.P_V, T4.C_V, T3.P_O, T4.C_O, T3.P_D, & T4.C_D?

Can you provide a sample script of failing data?

Your example using

WHERE PRM_StartDate = (SELECT MAX(PRM_StartDate) FROM PriceMatrix)

would , fixing the double WHERE, only return rows where PRM_StartDate is the maximum where  IMA_ItemStatusCode = 'Active'.

So...

Based on some other links, try replacing & with %26

https://www.sqlservercentral.com/forums/topic/reportviewer-doesnt-work-if-a-parameter-contains-an-ampersand

&

PLAN & COUNT are reserved keywords. If you're going to use them as an object (e.g., column) name or alias, you need to wrap them in double quotes or...

Posting DDL & insert scripts rather than links to download is more likely to get you help.

How to post code problems

Not getting snippy with a generous expert like Grant...

That would happen if you did not have ord.Amount wrapped in the aggregate SUM function.

It should work w/ the query listed.

How many rows does the CTE body (the subquery portion) return? I'm not sure if the query engine is smart enough to short-cut the query based on the top 1...

You can't parameterize a from clause. You could parameterize the WHERE clauses.

You could concatenate the table type into dynamic sql as described here: https://odetocode.com/articles/365.aspx

where Date From >=  '2020-04-01'  and  Date To <= '2020-04-28'

There is no data in your sample that meets that requirement.

In

2  ----- 2020-04-01 ----- 2020-04-30

Date...

Is there a reason you don't have a clustered index or primary key? (may or may not be  the same)

Is TempDB on the C Drive? Is it growing/filling the drive?

Or is it actually SSMS temp files mentioned previously?

Check/tune their queries if possible.

Is there a reason the app team can't tell you which columns are unused?

You could use server-side trace or extended events to log executions over a period long enough to...