Hi Asifpatel,

Please refer the below link.You need to modify as per your requirement and change the Textbox instead of the Dropdownlist.

Filter RDLC Report ReportViewer control using DropDownList selection in ASP.Net

Display image of employee in ReportViewer depending on DropDownList using C# and VB.Net in ASP.Net

Hi Indresh,

Thanks but Its not about having a textbox (like dropdown) within report. I want to have a rdl report run based on a SQL cmd which picks up parameters -textbox from the web page.

Just like displaying gridview which is created from a SQL cmd (written in C#) picking up parameters entered in the textbox fileds

Hi Asifpatel,

Filter RDLC Report ReportViewer control using DropDownList selection in ASP.Net

In above thread i have already used Dropdownlist value as parameter for sql query on which i m fetching the records and generating the crystal report as per the dropdownlist selected item so go through above link carefully you will get the idea.

Hi Indresh, that is useful. In fact this is something that will fine tune my report.

However I am looking to see if there is a way to have the report generate from a SQL command (from C# or asp GUI) 

classic example : "select Company, Department, Employee, Date name from client_table where employee name = '" + textbox1.text +'" and department = ........ and Date = ..............."

This is the essential requirment as per the project that I am working on

Any ideas?

You can simple change the select query and pass additional parameter to the command object to filter the report.