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?

Pass report parameters to data source (2000)?

In the data tab of my report (Reporting Services for SQL Server 2000), I'd like to run a query that requires parameters be passed to it. Is there a way to pass the parameters of the report to that query?

Thank you.

Hello,

Yes, of course you can. Let's say you have a parameter named Param1, in the data tab, your query would look something like this:

select * from table1 where field2 = @.Param1

Hope this helps.

Jarret

|||I knew it had to be simple... Thank you so much!