MS-Access Report Record Sources of type "Table/Query" are converted to SQL Server stored procedures and are referred to in the CommandText property of the DataSet element of the report. SSRS Query and Report Parameters are defined when the underlying QueryDef contains parameters. Users are prompted to enter parameter values when the SSRS report is run.
Report Parameters are assigned data types that are equivalent to those explicitly defined on the Query | Parameters Form. Note that query parameters are assigned the Text data type by default. Explicitly assigning query parameter types is recommended.
Unbound Access Reports are converted to SSRS Reports that do not include data elements.