Is it possible to load the million records report with Report Viewer and Report Writer?

Yes. You can load reports with a million records in the Bold Reports^® Report Viewer and Report Writer components.

To handle a million records, use the EnableVirtualEvaluation and DisablePageSplitting API with the Report Viewer and Report Writer. For details, see the following document.

Improve performance when loading a report with huge data in Report Viewer