I also experience this issue, and have yet to find a way to load an .RDL as a custom report under Database Snapshots in SSMS. Receiving the error "The definition of the report 'Main Report' is invalid. (Microsoft.ReportViewer.Common)"

I can, however, load it in SSRS under 'Add Existing Item.'

The report was built in ReportBuilder 2.0.