Crystal Report Blank Page in asp.net c#

It's My Code 

 

 

private ReportDocument customerReport;

ReportDocument rprt = new ReportDocument();

SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["con2"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)

{

}

protected void pageinit()

{

customerReport = new ReportDocument();

string reportPath = Server.MapPath("CrystalReport2.rpt");

customerReport.Load(reportPath);

System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["con2"].ConnectionString);

System.Data.SqlClient.SqlDataAdapter adpt = new System.Data.SqlClient.SqlDataAdapter(" SELECT distinct Shift = STUFF((SELECT ', ' + CAST(g.Shift AS VARCHAR(MAX))FROM paySwipeLOG g WHERE g.EmployeeCode = 'ma0222' and CONVERT(CHAR(7), g.ProcessDate, 120) = '2021-06' order by g.ProcessDate FOR XMl PATH('')), 1, 1, '')FROM paySwipeLOG t1 where t1.EmployeeCode = 'ma0222' and CONVERT(CHAR(7), t1.ProcessDate, 120)= '2021-06'", conn);

DataSet dataSet = new DataSet();

adpt.Fill(dataSet, "DataSet1");

customerReport.SetDataSource(dataSet);

CrystalReportViewer1.ReportSource = customerReport;

}

Show me the ado.net code, where you filled the dataset

now use it in Page_Init

 

Yes, I Copied and include  my project

 

 

 -

Dear Sachin Singh ,

2. "businessObjects">
3. "crystalReports">
4. "rptBuildProvider" type="CrystalDecisions.Shared.RptBuildProviderHandler, CrystalDecisions.Shared, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, Custom=null" />
5. "crystalReportViewer" type="System.Configuration.NameValueSectionHandler" />
13. "true" />
16. "ResourceUri" value="/crystalreportviewers13" />

 

                                  I Tried This but not working 

step 1. Copy the folder "C:\inetpub\wwwroot\aspnet_client\system_web\4_0_30319\crystalreportviewers13" into the application folder.

 

step 2. copy-paste below code in web.config under section