Adding CTE to SSRS / RDL

[Hally (Simon Hall)]

Word of caution… The query text box is not unlimited.

see here, a bit of an old post but I believe it still applies.

Report Builder Query Character Limit - Help Needed

I am trying to add columns to our pack slip for job lot number. When I go to add in T2.[LotNum] as ReqLotNum I am not allowed to add more characters to the query expression. What is the best way to add in the required column not using the Query Expression? What is the best way to reduce the size of the query expression? I am in gov cloud, so I do not believe I have direct sql access.