SELECT CodiceCliente, RagioneSociale, Articolo, Comma, descrizione, Area, dtDeroga, dtFineDeroga, SuContratto, Parametri
FROM MasterDeroghe
WHERE Articolo = (?CodArt)
I want to pass a parameter at a report of reporting services with this query but this query don't conceid it.
why?
what's wrong?
My database is access
If ?CodArt is supposed to be your parameter, that is your problem. Report server parameter variables start with @., i.e. @.CodArt|||The parameter syntax really depends on the data source being used. Some data provider (such as SQL Server, Oracle) support named parameters, other data providers only support unnamed parameters (e.g. OleDB provider)
Examples for parameter syntax:
SQL Server select * from table where column = @.ParameterName
Oracle select * from table where column = :ParameterName
OleDB (unnamed parameters) select * from table where column = ?
-- Robert
No comments:
Post a Comment