In mdb file, you need to specify a sql statement for the report, such as the following VBA code:
Private Sub Report_Open(Cancel As Integer)
Me.RecordSource = "SELECT DISTINCTROW Categories.CategoryName, Products.ProductName, Products.QuantityPerUnit, Products.UnitsInStock, Products.Discontinued " _
& "FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID " _
& "WHERE (((Categories.CategoryName) = '" & Me.OpenArgs & "') And ((Products.Discontinued) <> Yes)) " _
& "ORDER BY Categories.CategoryName, Products.ProductName;"
End Sub
You can now pass in the ReportArgs argument into the GetReport method. This will be passed into the Access report using OpenArgs:
Dim strArgs As String = "Condiments"
strReturn = objReportClient.GetReport(strDatabaseName, strReportName, strReportFilter, strArgs, enmReportFormat)
Please note this will only work with Access 2002 and higher.