Passing report parameter from TextBox

[Zash]

 Hello,

I have report datasource like the following:

SELECT

 

 

 

 

,firstname

 

 

 

,lastname

 

 

 

,email

 

 

 

,amount

 

 

 

,dcomments

 

 

 

 

 

FROM

 

[donation]

WHERE

 

firstname LIKE '%'+@firstname+'%'

 

OR

 

lastname LIKE '%'+@lastname+'%'

 

How do i pass @firstname parameter value from report. I am trying to display textbox where user can key in but i could not. I can do dropdown for firstname but i am trying to do textbox.

Do you have any example for my issue?
Thanks,

[Steve]

Hi Zash,

The built-in editors for the Report Parameters depend on the parameter type and whether it is multivalue or not. The editors for most types excluding DateTime are TextBox if you have a single value parameter. If you want to allow the user to type manually the parameter value in the editor, then do not bind the report parameter to show the firstname/lastname data, but of course this would mean that the user would have to know the available values beforehand.
If this is not what you're after, please elaborate on your scenario, so we can advise you accordingly.

Best wishes,
Steve
the Telerik team