Passing @ to database instead of interpreting it as a parameter

I am using a secondary datasource in my reports, but it requires the @. symbol
to be passed to the database instead of being used as a parameter (functions
begin with @.). Is there any way to get this to work with reporting services?Open your datasource query, double click onthe ellipsis (...) go to the
parameters tab and make sure the @.functions are not mapped to a parameter...
I suspect you will have problems with this... It may keep adding the
parameter.
You can also try using dynamic sql...or maybe changing the name of those
functions... @. is a special character in SQL...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Ben" wrote:
> I am using a secondary datasource in my reports, but it requires the @. symbol
> to be passed to the database instead of being used as a parameter (functions
> begin with @.). Is there any way to get this to work with reporting services?