For most SEO Recon reports, this can be a few hours or a few days. Usually, the size of the domain itself (how many keywords it has) determines the time it takes to create the report.
The AdWords Advisor reports are the fastest reports, and there are instant results available on the PPC Overview tab.