Parameters in OLE DB RRS feed

  • Question

  • See Parameters in OLE DB. I have the same question. For an Access database, how do we specify a report parameter. I understand that the SQL query must use unnamed parameters. Yet report parameters relate to query parameters using names, correct? Does the use of unnamed parameters by OLE DB prevent the use of parameters in reports?

    This is for a ReportViewer LocalReport in a desktop application. We need to allow the user to choose a from/to date to filter the report dynamically during execution. It seems to be a very reasonable and common requirement.

    Sam Hobbs; see my SimpleSamples.Info
    Tuesday, April 27, 2010 10:53 PM