Hi J Lam
There aren't really any reports around question banks that I can see.
It is possible to move questions and categories so you could create a top level category for all questions and move all categories/questions into this. There is an export option in question bank under Quiz setting. If you choose the top level category then this will produce a file with questions from all subcategories in it to help identify duplicate questions.
regards