Happy Programming

#region Using Directives

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Collections.Generic;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using ELearning.SystemCore.BLL.Object;

using ELearning.SystemCore.BLL;

using ELearning.Common;

#endregion

public partial class CRSurveyResultsGraphicReport : BasePage

{

protected void Page_Load(object sender, EventArgs e)

{

try

{

CrystalDecisions.CrystalReports.Engine.ReportDocument myReportDocument;

myReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();

DataTable dtRec = GetSurveyResultsGraphicReport();

myReportDocument.Load(Server.MapPath("Reports\\CRSurveyResultsGraphicReport.rpt"));

myReportDocument.SetDataSource(dtRec);

CRViewer.DisplayGroupTree = false;

myReportDocument.SetDataSource(dtRec);

CRViewer.DisplayGroupTree = false;

CRViewer.ReportSource = myReportDocument;

}

catch (Exception ex)

{

ELearning.ErrorLogger.Error.WriteErrorLog(ex);

}

}

private DataTable GetSurveyResultsGraphicReport()

{

DataTable dtRec = new DataTable();

dtRec.Columns.Add("intSurveyId");

dtRec.Columns.Add("vcSurveyName");

dtRec.Columns.Add("intQuestionId");

dtRec.Columns.Add("intUserId");

dtRec.Columns.Add("vcUserName");

dtRec.Columns.Add("vcSurveyResponse");

dtRec.Columns.Add("Count", typeof(Int32));

DataSet ds = new DataSet();

ManageSurvey manageSurvey = new ManageSurvey();

int surveyId = 1;

ds = manageSurvey.GetSurveyResultsSummary(ManageUser.GetLoggedUser().OrganizationId, surveyId);

if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)

{

foreach (DataRow dR in ds.Tables[0].Rows)

{

DataRow dRNew = dtRec.NewRow();

//dRNew["intSurveyId"] = NullHandler.AvoidNullint(dR["intSurveyId"]);

//dRNew["vcSurveyName"] = NullHandler.AvoidNullStr(dR["SurveyName"]);

dRNew["intQuestionId"] = NullHandler.AvoidNullint(dR["intSurveyQuestionId"]);

//dRNew["intUserId"] = NullHandler.AvoidNullint(dR["intUserId"]);

//dRNew["vcUserName"] = NullHandler.AvoidNullStr(dR["cUserName"]);

dRNew["vcSurveyResponse"] = NullHandler.AvoidNullStr(dR["SurveyResponse"]);

dRNew["Count"] = NullHandler.AvoidNullint(dR["Count"]);

dtRec.Rows.Add(dRNew);

}

}

return dtRec;

}

}