blancesheetfinal cryRpt = new blancesheetfinal(); crinfo.IntegratedSecurity = true; TableLogOnInfos crLoginfos = new TableLogOnInfos(); TableLogOnInfo crLoginfo = new TableLogOnInfo(); Tables Crtables; Crtables = cryRpt.Database.Tables; foreach (Table crtable in Crtables) { crLoginfo = crtable.LogOnInfo; crLoginfo.ConnectionInfo = crinfo; crtable.ApplyLogOnInfo(crLoginfo); } /////// for first parameter feild ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = textBox1.Text; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["cid"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); ///////// parameter for sub report ParameterFieldDefinitions ccrParameterFieldDefinitions; ParameterFieldDefinition ccrParameterFieldDefinition; ParameterValues ccrParameterValues = new ParameterValues(); ParameterDiscreteValue ccrParameterDiscreteValue = new ParameterDiscreteValue(); //ccrParameterDiscreteValue.Value = textBox1.Text; ccrParameterDiscreteValue.Value = dateTimePicker1.Text; ccrParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; ccrParameterFieldDefinition = ccrParameterFieldDefinitions["date"]; ccrParameterValues = ccrParameterFieldDefinition.CurrentValues; ccrParameterValues.Clear(); ccrParameterValues.Add(ccrParameterDiscreteValue); ccrParameterFieldDefinition.ApplyCurrentValues(ccrParameterValues); crystalReportViewer1.ReportSource = cryRpt; crystalReportViewer1.Refresh(); crystalReportViewer1.ReportSource = cryRpt; crystalReportViewer1.Refresh();
ReportDocument cryRpt = new ReportDocument(); cryRpt.Load("rptMainReport.rpt"); cryRpt.SetParameterValue("myRoleId", 2, "subreport name");
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)