Thanks Naomi. I believe this one has solved my problem (I'll have to analyze it a little more closely to make sure everything is accurate, but there aren't any blank entries of rptname). I am not familiar with NVL so I'll have to look into it a bit, but it seems to have worked.

Sergey's seemed like a good idea as well, but it gave me the same output as though I hadn't put in that condition at all for some reason.

Thanks everybody for your quick responses.