Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 URL parameters for Access / .mdb data

Author  Topic 

bubberz
Constraint Violating Yak Guru

289 Posts

Posted - 2006-04-10 : 16:47:09
Posted - 04/10/2006 : 15:46:50
--------------------------------------------------------------------------------

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:

https://server/Reports/Pages/Report.aspx?ItemPath=%2fMig%2fTesting&?=20003

...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?

Thanks!
   

- Advertisement -