Parameter for column name

[Ctrax]

I am wondering if it is possible to build a report that contains 1 parameter where the user can select a column name, and 1 parameter where they enter a value.  Below is an example of a report query that would be used in this scenario:

select Name, City, State
from Customers
where @field = @value

Then if the following is selected for the parameters...

@field = City
@value = Boston

the report would return all customers where City = 'Boston'.  I understand that I can create separate parameters for each individual field, but in my actual scenario I am dealing with a much larger number of fields (20+), and am looking for a simpler solution where they can just select a column name from a dropdown.

So is it possible to use this type of parameter in a Telerik report?

[Peter]

Hi,

You can accomplish your requirement with report filter. You can use the Fields(fieldName) expression function in report filter. Where fieldName is the parameter value. Check out the following example:

Expression	Operator	Value
= Fields(Parameters.Parameter1.Value)	=	=Parameters.Parameter2.Value

Another approach is to utilize a stored procedure as elaborated in How to use TSQL parameters to actually use it as an Identifier rather than the value? MSDN blog.

Greetings,
Peter
the Telerik team