Almost two million people have not worked for at least six months due to the economic impact of the pandemic, according to a report.