SQL Server Performance

URL parameters for Access / .mdb data

Discussion in 'SQL Server Reporting Services' started by bubberz, Apr 10, 2006.

  1. bubberz New Member

    I'm using an .mdb file in the meantime (before we upsize the data), and I've got to pass two parameters in a querystring.....for now I'm just using one in my testing. The other will be a date value. Since it's an OLEDB datasource, the parameters have to be unnamed....at least that's what reporting services is telling me.

    In my querystring, I pass the parameter value like:


    ...but the report doesn't pull any data.

    I can run it in the data tab of the report desginer, put in 2003, and the data does come back.

    Any suggestions?


Share This Page