I finally resolved my issue, report is working perfectly, had nothing to do with my SQL Code. Just had to start all over again in recreating with subreports and parameters.

8th time's the charm.