Display data in CrystalReportViewer WebApplication
frmMain.cs:
private void btnMasterCopy_Click(object sender, System.EventArgs e)
{
PrintReport( enmCopyType.Master );
}
private void PrintReport(enmCopyType copyType)
{
int poId;
string poNum;
poNum = txtPONumber.Text.Trim().ToString();
DataSet ds = GetPOID(poNum);
int x = ds.Tables[0].Rows.Count;
poId = Convert.ToInt32(ds.Tables[0].Rows[0]["POID"].ToString());
string RoleID = clsResources.DefaultRoleID;
Session["poId"]=poId;
Session["poNum"]=poNum;
Session["copyType"]=copyType;
Session["RoleID"]=RoleID;
Response.Redirect("frmReport.aspx");
}
}
frmReport.cs::
private void Page_Load(object sender, System.EventArgs e)
{
long poId = Convert.ToInt64(Session["poId"]);
string poNum = Session["poNum"].ToString();
enmCopyType copyType = (enmCopyType)Session["copyType"];
string RoleID = Session["RoleID"].ToString();
docReport( poId, copyType, "PO #" + poNum,RoleID);
}
public void docReport(long plngPOID, enmCopyType pType, string poNumber,string RoleID)
{
ReportDocument rpt = new ReportDocument();
rpt.Load(Server.MapPath("PO.rpt"));
string userName = "sa";
string password = "system";
string databaseName = "POS_DEV1";
string serverName = "99LADA1";
ParameterFields allFields = new ParameterFields ();
ParameterField poIDfield = new ParameterField ();
ParameterDiscreteValue poIDfieldValue = new ParameterDiscreteValue();
ParameterField copyTypeField = new ParameterField ();
ParameterDiscreteValue copyTypeValue = new ParameterDiscreteValue();
ParameterField roleIdField = new ParameterField ();
ParameterDiscreteValue roleIdValue = new ParameterDiscreteValue();
poIDfield.ParameterFieldName = "POID";
poIDfieldValue.Value = plngPOID;
poIDfield.CurrentValues.Add( poIDfieldValue );
allFields.Add( poIDfield );
copyTypeField.ParameterFieldName = "CopyType";
copyTypeValue.Value = (int) pType;
copyTypeField.CurrentValues.Add( copyTypeValue );
allFields.Add( copyTypeField );
roleIdField.ParameterFieldName = "RoleId";
roleIdValue.Value = RoleID;
roleIdField.CurrentValues.Add( roleIdValue );
allFields.Add( roleIdField );
CrystalReportViewer CrystalReportWebFormViewer2 = new CrystalReportViewer();
CrystalReportWebFormViewer2.ParameterFieldInfo = allFields;
rpt.SetDatabaseLogon(userName, password, serverName, databaseName);
CrystalReportWebFormViewer2.ReportSource = rpt;
CrystalReportWebFormViewer2.DataBind();
CrystalReportWebFormViewer2.Visible = true;
}
These are my 2 classes.When debugging i am not getting any Exception.But Data was not loading or displayed in CrystalReportViewer.
|