Loading Crystal Report with parameters - ASP.NET Web forms

Question

Hello,

 

I'm trying to load a crystal reports with parameters using a stored procedure as a data source.I'm using Visual Studio 2015 with ASP.NET Web forms.

 

I've created the report (Report1.rpt) using wizard, binding it on my stored procedure. When I was asked to enter the parameters I left it blank.

 

Here's my code:

protected void Button1_Click(object sender, EventArgs e)
        {
             ReportDocument reportDocument = new ReportDocument();
             ParameterField paramField = new ParameterField();
             ParameterFields paramFields = new ParameterFields();
             ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();

             paramField.Name = "@id";
             paramDiscreteValue.Value = "123";
             paramField.CurrentValues.Add(paramDiscreteValue);
             paramFields.Add(paramField);

             paramFields.Add(paramField);

             CrystalReportViewer1.ParameterFieldInfo = paramFields;

             string reportPath = Server.MapPath("~/User/Report1.rpt");

            reportDocument.SetDatabaseLogon("user", "pass","SERVER", "DB1", false);

            reportDocument.Load(reportPath);

             CrystalReportViewer1.ReportSource = reportDocument;

 1. When I click on the button I get nothing. Any ideas why the report is not loading?

 

 2. If i use the following code I get error in "SERVER\TSQL2012"

reportDocument.SetDatabaseLogon("user", "pass","SERVER\TSQL2012", "DB1", false);

 

Any kind of help would be appreciated!

 

Thank you in advance.