There is no way to directly place Passthrough SQL into a Report RecordSource property.

Reports want DAO recordsources and in some cases, need a table object to work off of.

However, if you are using SQL server and want to utilize a SQL view, you can link it as a table in Access.

You also can use a local QueryDef you’ve created and saved (queries in the Nav panel) and select them in the Report RecordSource property, OR you can build your own local DAO SQL against that named query. That named query can be a passthrough query.

I’ve found it can be useful to update the querydef SQL property to filter the report prior to getting to the DAO stage of filtering via the normal Report object methods. If you have a very large amount of data to process, using the Passthrough query to filter the data first will make things much faster!