handing in a SQL string to my reportviewer

[William]

Hello All,

I have a report which works fine and it is set to my report viewer.  I have the SQL select statement hard coded.  I have a dropdown box on the same page and I want to append that user name to the select statement.  I am a bit confounded on how to change the select statement.  Here is the code and I want to dynamically hand in the user id (which is 4 in my hard coded case).  I know how to get the selected item out of the dropdown...it just isn't clear how I get the web page to hand it into the report.  Any thoughts? 
Thank you.
William

public ReportClass()

{

StringBuilder sb = new StringBuilder();

InitializeComponent();

　

sb.Append("select SY.name_system, SE.id_employee, SE.id_system, SE.id_user, SE.date_change").Append(" ");

sb.Append("from Secured SE").Append(" ");

sb.Append("inner join Systems SY on SY.id_system=SE.id_system").Append(" ");

sb.Append("where SE.is_active=1 and SE.id_employee=").Append("4").Append(" ");

sb.Append("Order by SE.date_change DESC");

sqlSource.SelectCommand = sb.ToString();

txtRunDate.Value = DateTime.Today.ToShortDateString();

}

[Stef]

Hello William,

Try using parametrized SQL query, where the SQL parameter can be mapped to a report parameter. The report parameter can be passed through the report source object or displayed in the ReportViewer parameters area. For more details take a look at the following materials:

• Using Parameterized Queries in Telerik Reporting with the SqlDataSource Component video tutorial;
• Using Parameters with the SqlDataSource component help article;
• Report Parameters help article;

I hope this helps.

Regards,
Stef
Telerik

[William]

Thanks Stef.

I found this to be the best option for flexibility.   I don't like parameters on open ended reports.  I like to give the users the ability to pick stuff off of the page as parameters and send them along on a select string.

protected void btnReports_Click(object sender, EventArgs e)

{

StringBuilder sb = new StringBuilder();

Master.SetStatus("Reports");

sb.Append("select SY.name_system, SE.id_employee, SE.id_system, SE.id_user, SE.date_change").Append(" ");

sb.Append("from Secured SE").Append(" ");

sb.Append("inner join Systems SY on SY.id_system=SE.id_system").Append(" ");

sb.Append("where SE.is_active=1 and SE.id_employee=");

sb.Append(int.Parse(ddEmployeeList.SelectedItem.Value).ToString()).Append(" ");

sb.Append("Order by SE.date_change DESC");

ReportViewer1.Report = new ReportClass(sb.ToString(), ddEmployeeList.SelectedItem.ToString());

ReportViewer1.RefreshReport();

}

William