Search

Saturday, February 7, 2009

Crystalt Report in Asp.net(C#)

//Display Crystal Report Using Asp.net with No Perameter

//Assembly to add
using CrystalDecisions.Shared;
using CrystalDecisions;
using CrystalDecisions.CrystalReports.Engine;

protected void Page_Load(object sender, EventArgs e)
{
CrystalReportViewer1.ReportSource = "~/Reports/Reportname.rpt";

configureCRYSTALREPORT();
}

private void configureCRYSTALREPORT()
{
ConnectionInfo myConnectionInfo = new ConnectionInfo();

myConnectionInfo.DatabaseName = "databasename";
myConnectionInfo.UserID = "sa";
myConnectionInfo.Password = "sa";
setDBLOGONforREPORT(myConnectionInfo);
}

private void setDBLOGONforREPORT(ConnectionInfo myconnectioninfo)
{
TableLogOnInfos mytableloginfos = new TableLogOnInfos();
mytableloginfos = CrystalReportViewer1.LogOnInfo;
foreach (TableLogOnInfo myTableLogOnInfo in mytableloginfos)
{
myTableLogOnInfo.ConnectionInfo = myconnectioninfo;
}

}


//Now Crystal report With Perameter
protected void Page_Load(object sender, EventArgs e)
{
CrystalReportViewer1.ReportSource = "~/Reports/Reportname.rpt";


//First Perameter

ParameterFields paramFields_pFrmDate = CrystalReportViewer1.ParameterFieldInfo;
ParameterField paramField_pFrmDate = paramFields_pFrmDate["@fromdate"];
ParameterValues curValues_pFrmDate = paramField_pFrmDate.CurrentValues;
ParameterDiscreteValue discreteValue_pFrmDate = new ParameterDiscreteValue();
discreteValue_pFrmDate.Value = Session["item_maingroup_fromdate"] ;
curValues_pFrmDate.Add(discreteValue_pFrmDate);
CrystalReportViewer1.ParameterFieldInfo = paramFields_pFrmDate;

//Second Perameter

ParameterFields paramFields_pToDate = CrystalReportViewer1.ParameterFieldInfo;
ParameterField paramField_pToDate = paramFields_pToDate["@todate"];
ParameterValues curValues_pToDate = paramField_pToDate.CurrentValues;
ParameterDiscreteValue discreteValue_pToDate = new ParameterDiscreteValue();
discreteValue_pToDate.Value = Session["item_maingroup_todate"];
curValues_pToDate.Add(discreteValue_pToDate);
CrystalReportViewer1.ParameterFieldInfo = paramFields_pToDate;

configureCRYSTALREPORT();
}

private void configureCRYSTALREPORT()
{
ConnectionInfo myConnectionInfo = new ConnectionInfo();

myConnectionInfo.DatabaseName = "DatabaseName";
myConnectionInfo.UserID = "sa";
myConnectionInfo.Password = "sa";
setDBLOGONforREPORT(myConnectionInfo);
}

private void setDBLOGONforREPORT(ConnectionInfo myconnectioninfo)
{
TableLogOnInfos mytableloginfos = new TableLogOnInfos();
mytableloginfos = CrystalReportViewer1.LogOnInfo;
foreach (TableLogOnInfo myTableLogOnInfo in mytableloginfos)
{
myTableLogOnInfo.ConnectionInfo = myconnectioninfo;
}

}

Blog Archive

Contributors