my source is
AutoDataBind="True" DisplayPage="False" ReportSourceID="CrystalReportSource2"
Width="500px" BestFitPage="False" Height="800px" />
my code is
ReportDocument reportdocument = new ReportDocument();
string iid = Request.QueryString["id"].ToString();
ParameterFields paramFields = new ParameterFields();
ParameterField paramField = new ParameterField();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
paramField.Name = "id";
paramDiscreteValue.Value = iid;
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
CrystalReportViewer1.ParameterFieldInfo = paramFields;
reportdocument.Load(Server.MapPath("Cashvoucher.rpt"));
reportdocument.SetParameterValue("id", iid);
// string str = "select id,Name,Section,Details,advance from salary where id='" + iid + "'";
string str = "select Name,daysinmonth,presentdays from salary where id='" + iid + "'";
DataSet ds = mvl.GETDS(str);
reportdocument.SetDataSource(ds.Tables[0]);
CrystalReportViewer1.ReportSource = reportdocument;
//CrystalReportViewer1.RefreshReport();
}
2 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
selvi subramanianPosted Jul 8, 2014, 12:34 AM
Guest UserPosted Jul 7, 2014, 9:00 AM
# May I know why you're using Crystal Report, I believe it's paid software? You may want to look at certain open source free libraries, e.g, NVD3 (charting) etc. to accomplish your task.
twitter @sumitjolly