Maybe something like Monarch? I used a product called Monarch decades ago that sounds like this tool.

There are some industries/groups of customers with more discipline than others, and some...

<reference_number> is an element, not an attribute.

That error seems to indicate you're not using SQL Server 2022. (Which is probably why DesNorton wrote " (NOTE the extra parameter in STRING_SPLIT)"

Are you on SQL Server 2022? You...

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

&amp;

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...