sql server reporting services: hi all,
i have a little problem ,my report use data from Orcale
db to view slaes reports for salesmen, i made the salemen
name as a report parameter ,when running the report and
after choosing the salesmen name from the paramter list i
have this error"Oracle ODBC does not support passing

I had the same problem. What you need to do is select the Oracle date provider - NOT the Oracle OLE driver. Then use the : not the & as the parameter prefix. When you setup the Dataset you have the choice of SQL Server & Oracle drivers. If you use the report wizard, the correct option is available. If you don't use the wizard, it's not obvious, but select the ... beside the dataset then select the Oracle driver.

If you use the Oracle OLE driver you can't use named parameters.

Hope this helps.
Regards,
Mike Dolan

[quoted text, click to view]