What to do if a report fails to generate for several projects?

One of the best methods to check which project is causing report generation to fail is to divide the entire batch of projects into several smaller ones and to repeat project generation. This might enable you to determine or narrow down the scope of the projects that might be causing issues.