I can tell you maximum recursion is not your problem, you are running code in a virtual view which is using many local temp tables SSRS rejects most temp table code so you need to convert your temp tables to either View or regular temp table.

To fix your current code try ## global temp table remember to drop all or try table variables.