Reportviewer

[Zack Snyders]

Good day,

I need a simple example to implement reportviewer into asp.net web forms (visual studio 2017)

The report will have a single datasource (sql server table or view)

kind regards

[Yuvaraj Devarajan]

Hi Zack, 

 

Thanks for contacting Syncfusion support.  

 

We have prepared a ReportViewer sample based on ASP.NET Web platform and it can be downloaded from below location,      

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/ReportViewerSample366520474.zip   

    

Please refer the below UG documentation link to create the sample in ASP.NET web platform,   

https://help.syncfusion.com/aspnet/reportviewer/getting-started    

 

Also you can obtain the ASP.Net ReportViewer samples from the below build installed location,     

%userprofile%\AppData\Local\Syncfusion\EssentialStudio\version\Web\Samples\Web  

 

Regards, 

Yuvaraj D. 

[Zack Snyders]

Hi Yuvaraj,

Thank you for this.Can you please expand on this by providing an example where I can dynamically do a sqlserver query in C# codebehind and pass the results to the report.

Your example is fine but the data is embedded in the report itself. 

Unless I am missing something?

Thank you very much

rgs

Zack

[Yuvaraj Devarajan]

Hi Zack, 

We can load the datasource value by passing the dataset query from command text in OnReportLoaded method in web API method as shown in below code snippet.  

  

public void OnReportLoaded(ReportViewerOptions reportOption) 

        { 

            string querystr = "SELECT Person.Address.AddressID , Person.Address.City , Person.Address.StateProvinceID FROM Person.Address"; 

            string connection = "Data Source=mvc.syncfusion.com;Initial Catalog=AdventureWorks;User Id=ssrs1;password=RDLReport1;"; 

            reportOption.ReportModel.DataSources.Clear(); 

            reportOption.ReportModel.DataSources.Add(new ReportDataSource { Name = "DataSet1", Value = GetDataTable(querystr, connection) }); 

        } 

 

        public DataTable GetDataTable(string querystr, string connection) 

        { 

            string query = querystr; 

            DataTable dt = new DataTable(); 

 

            using (SqlConnection sqlConn = new SqlConnection(connection)) 

            using (SqlCommand cmd = new SqlCommand(string.Format(query), sqlConn)) 

            { 

                sqlConn.Open();                

                using (SqlDataReader reader = cmd.ExecuteReader()) 

                { 

                    dt.Load(reader); 

                    var r = dt.Rows.Count; 

                } 

                return dt; 

            } 

        } 

We have modified the shared sample and it can be downloaded from below location, 

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/ReportViewerSample1535221716.zip  

Please refer to the below UG documentation link for more detail, 

https://help.syncfusion.com/aspnet/reportviewer/report-datasources   

Regards, 

Yuvaraj D. 

[Zack Snyders]

Hi Yuvaraj,

Thank you for this. I am almost there!

If I want to specify my database and credentials in web.config and not hardcode the connection details in OnReportLoaded and use an approach like:

            string connectionString = null;
            SqlConnection sqlCnn;
            SqlCommand sqlCmd;
            string sql = null;

            connectionString = Properties.Settings.Default.PatrolConnectionString;
            sql = "SELECT * FROM SystemUsers " + " WHERE UserName = '" + usernameTextBox.Text + "'";

            sqlCnn = new SqlConnection(connectionString);
            try
            {
                sqlCnn.Open();
                sqlCmd = new SqlCommand(sql, sqlCnn);
                SqlDataReader sqlReader = sqlCmd.ExecuteReader();
                while (sqlReader.Read())

etc.

How would I change OnReportLoaded or what would the correct approach be?

rgs

Zack

[Vijay Raja]

  

Hi  Zack, 

We need to set the connection information in ‘OnReportLoaded’ to change the values dynamically but you can store or maintain your connection details in web.config or somewhere else based on your security needs. Please makes sure to assign the values in OnReportLoaded to update connection details dynamically. 

Regards, 

Vijay R. 

[Zack Snyders]

Got this working, thank you.

I included the connection string in web.config (standard method)

and in OnReportLoaded I changed it to:

      string querystr = "SELECT * FROM [dbo].[XYZ]";

      string connection = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
     

Please close 

rgs

[Vijay Raja]

Hi  Zack, 

Thanks for your update. Please let us know if you require any further assistance on this. 

Regards, 

Vijay R.