Not sure if this makes a difference, but does the TargetServer property have any influence on this?

I've not done a whole lot with replication, but my guess is that you'll want to at some point turn off that table's replication.   I'd be looking at the following...

When you say you are getting locks, which object is being locked, and which SPID is holding that lock?   We'd need to see the query and perhaps the output of...

First, why are you trying to use JSON for this?   JSON is expensive to parse, and constructing JSON is even more challenging.   You may want to search the web for...

Well... re-formatting your code to improve it does mean that you still need to have it inside of the code="SQL" and /code tags, so the last post didn't help any...

If your objective is to be "version insensitive" to SQL Server versions, then you either have to know the version values and code for them, or you need to eliminate...

Understand that this is entirely a guess:
SELECT DISTINCT
    JOBNUMBER,
    TASKNAME,
    YEAR(ENTRYDATE) AS [Year],
    MONTH(ENTRYDATE) AS [Month],
    SUM(COSTPRICEREG) OVER (PARTITION BY JOBNUMBER, TASKNAME, YEAR(ENTRYDATE), MONTH(ENTRYDATE) ORDER BY YEAR(ENTRYDATE), MONTH(ENTRYDATE)) AS...

You could probably make use of an inline-table-valued function, as follows:
CREATE FUNCTION dbo.fnGetTempItems (
    @GetClassC tinyint = NULL
)
RETURNS TABLE WITH SCHEMABINDING
RETURN
SELECT TI.item, TI.class
FROM temp_item...

With no data to use to compare these, it's a little harder to ferret things out, but at a quick glance, you have a column name that is different in...

First problem...  You are expecting to use a single CASE statement that involves every column that you are looking to compare, and some of which are dates.
Whenever you encounter...

Take a look here:  https://docs.microsoft.com/en-us/sql/reporting-services/application-integration/using-the-winforms-reportviewer-control?view=sql-server-2017