tags:

views:

32

answers:

2
Q: 

SSRS where-clause with value that contains an @

In SSRS 2005 we have a query in a dataset and the query filters on a certain value which happens to contain an @. Eg: select * from test where testfield = '@LC'. SSRS thinks this value should be a parameter and treats it that way. How can configure my query so that SSRS treats it as a fixed value? Thanks!

+1  A: 

Already tried with '[@]LC'

Greco  2010-09-20 08:18:27
I just tried but this is no solution since no records are found...
Koen VC  2010-09-20 08:38:38
Replace your statement with select * from test where testfield LIKE '@LC'and try it out.
Greco  2010-09-20 08:53:36
it's OK, i did a workaround with hidden parameters etc. Thanks anyway!
Koen VC  2010-09-20 09:44:41
A: 

Perhaps switch to stored procedure?

sfuqua  2010-09-25 01:35:40

related questions

.NET Table Adapters: Get vs. Fill?
How can I read multiple tables into a dataset?
.Net: Convert Generic List of Objects to DataSet
Synchronize DataSet
How to wire a middle tier of Objects to a data tier consisting of a DataSet?
How do I refresh the relationships in a dataset?
What triggers ConstraintException when loading DataSet?
Why is a SQL float different from a C# float
Point ADO.Net DataSet to different databases at runtime?
Should I return a strongly typed dataset from a webservice?
How many DataTable objects should I use in my C# app?
How to convert Typed DataSet Scheme when one of the types was changed?
DataSet.Select and DateTime
Select rows in dataset table based on other dataset table
Object initialization in C# (.Net)
What are the disadvantages of Typed DataSets
Read Access File into a DataSet
DBUnit dataset generation
Handling XSD Dataset ConstraintExceptions
VB.NET Get underlying system.type from nullable type
Get the DefaultView DataRowView from a DataRow
PHP Script to populate MySQL tables
C#: What Else Do You Use Besides DataSet
Is there some way of recycling a Crystal Reports dataset?
Datatable vs Dataset